SYSRULES – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
SYR
Primary key
TASK, SYSTEM, KEY1, KEY2, KEY3, KEY4, KEY5
Fields
19
Updated by
14 programs
Referenced by
44 programs

SYSRULES is a Lawson Human Resources table (prefix SYR); no description in the lawson data dictionary. It is indexed by TASK, SYSTEM, KEY1, KEY2, KEY3, KEY4, KEY5 (SYRSET1); alternate indexes: SYRSET2. It is updated by BS01.1, BS05.1, BS07.1, ES02.2, ES02.3, ES03.1, HS00.1, HS06.1 and 6 more and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 and 36 more. The table has 19 fields, 2 indexes and 0 documented relations.

About SYSRULES

No description in the Lawson data dictionary.

Fields (19)

Column = COBOL field name without the SYR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
SYR-TASK PK
TASK
Alpha 20BS01.1, BS05.1, BS07.1, ES02.2, ES02.3, ES03.1, HS00.1, HS06.1 +6 more
SYR-SYSTEM PK
SYSTEM
Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)BS01.1, BS05.1, BS07.1, ES02.2, ES02.3, ES03.1, HS00.1, HS06.1 +6 more
SYR-KEY1 PK
KEY1
Alpha 10First key element.BS01.1, BS05.1, BS07.1, ES02.2, ES02.3, ES03.1, HS00.1, HS06.1 +6 more
SYR-KEY2 PK
KEY2
Alpha 10Second key element.BS01.1, BS05.1, BS07.1, ES02.2, ES02.3, ES03.1, HS00.1, HS06.1 +6 more
SYR-KEY3 PK
KEY3
Alpha 10Third key element.BS01.1, BS05.1, BS07.1, ES02.2, ES02.3, HS00.1, HS06.1, HS07.1 +5 more
SYR-KEY4 PK
KEY4
Alpha 10Fourth key element.BS01.1, BS05.1, BS07.1, ES02.2, ES02.3, HS00.1, HS06.1, HS07.1 +5 more
SYR-KEY5 PK
KEY5
Alpha 10Fifth key element.BS01.1, BS05.1, BS07.1, ES02.2, ES02.3, HS00.1, HS06.1, HS07.1 +5 more
SYR-DESC
DESC
Alpha 30 (Lower Case)This field displays the description.ES02.2, HS00.1, PA182
SYR-ALPHADATA1
ALPHADATA1
Alpha 1 Occurs 13 Times ×13BS01.1, BS07.1, ES02.2, ES03.1, HS00.1, HS06.1, HS23.1
SYR-ALPHADATA2
ALPHADATA2
Alpha 190BS01.1, ES02.2, HS00.1, HS06.1, HS07.1, HS18.1
SYR-ALPHADATA3
ALPHADATA3
Alpha 10BS01.1, BS05.1, ES02.2, ES03.1, HS00.1, HS06.1
SYR-ALPHADATA4
ALPHADATA4
Alpha 10ES02.2, ES03.1, HS00.1, HS06.1
SYR-ALPHADATA5
ALPHADATA5
Alpha 10ES02.2, HS00.1, HS06.1
SYR-NUMERIC1
NUMERIC1
Signed 15.4BS05.1, ES02.2, ES02.3, ES03.1, HS00.1, HS06.1, HS09.1, HS16.1 +1 more
SYR-NUMERIC2
NUMERIC2
Signed 15.4ES03.1, HS00.1, HS18.1
SYR-DATE1
DATE1
Numeric 8 (yyyymmdd)HS00.1, HS09.1, HS18.1
SYR-DATE2
DATE2
Numeric 8 (yyyymmdd)HS00.1, HS09.1, HS18.1
SYR-EMAIL-ADDRESS
EMAIL_ADDRESS
Alpha 60 (Lower Case)e-mail address.HS06.1, HS07.1
SYR-EMAIL-FORMAT
EMAIL_FORMAT
Numeric 1
  • 0 HTML
  • 1 Plain Text
HS07.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SYRSET1TASK, SYSTEM, KEY1, KEY2, KEY3, KEY4, KEY5PrimaryBN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
SYRSET2SYSTEM, KEY1, KEY2, KEY3, KEY4, KEY5, TASKBS05.1, ES02.2, ES02.3, HS00.1, HS06.1, HS07.1, HS23.1

Programs

Updated by (14)

Referenced by (44)