TAREASONS is the Reason Class & Code Relations table in Lawson Absence Management (prefix TRO). It is indexed by COMPANY, REASON-CLASS, REASON-CODE (TROSET1); alternate indexes: TROSET2. It is related 1:1 to PRSYSTEM, TAREASCLSS and TAREASCODE. It is updated by HR00.1, HR01.1, LP09.1, LP09.2, LP09.3 and LP09.4 and referenced by LP199, LP211, LP251, LP260, LP262, LP353, LP60.2, LP60.4 and 3 more. The table has 3 fields, 2 indexes and 3 documented relations.
About TAREASONS
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the TRO- 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.
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.
Index
Keys
Flags
Condition
Used in
TROSET1
COMPANY
REASON-CLASS
REASON-CODE
Primary
HR00.1, HR01.1, LP09.1, LP09.3, LP211, LP251, LP260, LP262 +6 more
TROSET2
COMPANY
REASON-CODE
REASON-CLASS
LP09.2, LP09.4, LP199
Relations
Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
