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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#SYR-TASK PK
TASK
Alpha 20—BS01.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 ×13—BS01.1, BS07.1, ES02.2, ES03.1, HS00.1, HS06.1, HS23.1
#SYR-ALPHADATA2
ALPHADATA2
Alpha 190—BS01.1, ES02.2, HS00.1, HS06.1, HS07.1, HS18.1
#SYR-ALPHADATA3
ALPHADATA3
Alpha 10—BS01.1, BS05.1, ES02.2, ES03.1, HS00.1, HS06.1
#SYR-ALPHADATA4
ALPHADATA4
Alpha 10—ES02.2, ES03.1, HS00.1, HS06.1
#SYR-ALPHADATA5
ALPHADATA5
Alpha 10—ES02.2, HS00.1, HS06.1
#SYR-NUMERIC1
NUMERIC1
Signed 15.4—BS05.1, ES02.2, ES02.3, ES03.1, HS00.1, HS06.1, HS09.1, HS16.1 +1 more
#SYR-NUMERIC2
NUMERIC2
Signed 15.4—ES03.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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SYRSET1
  1. TASK
  2. SYSTEM
  3. KEY1
  4. KEY2
  5. KEY3
  6. KEY4
  7. KEY5
PrimaryBN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
SYRSET2
  1. SYSTEM
  2. KEY1
  3. KEY2
  4. KEY3
  5. KEY4
  6. KEY5
  7. TASK
BS05.1, ES02.2, ES02.3, HS00.1, HS06.1, HS07.1, HS23.1

Programs

Updated by (14)

Referenced by (44)