TRNOVERCAT – No description in the Lawson data dictionary

System
Compensation D Mart (HC)
Prefix
TRT
Primary key
MEAS-OBJ-ID, TURNOVER-TYPE, GROUP-NAME
Fields
8
Updated by
4 programs
Referenced by
2 programs

TRNOVERCAT is a Lawson Compensation D Mart table (prefix TRT); no description in the lawson data dictionary. It is indexed by MEAS-OBJ-ID, TURNOVER-TYPE, GROUP-NAME (TRTSET1); alternate indexes: TRTSET2 and TRTSET3. It is updated by HC02.2, HC02.5, HC02.6 and HC10.1 and referenced by HCHM.1 and HCHP.1. The table has 8 fields, 3 indexes and 0 documented relations.

About TRNOVERCAT

No description in the Lawson data dictionary.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
TRT-MEAS-OBJ-ID PK
MEAS_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.HC02.6, HC10.1
TRT-TURNOVER-TYPE PK
TURNOVER_TYPE		Alpha 1—HC02.6, HC10.1
TRT-GROUP-NAME PK
GROUP_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.HC02.6, HC10.1
TRT-GRP-ALIAS-NAME
GRP_ALIAS_NAME		Alpha 80 (Lower Case)The Alias Name field contains an alias name for the dimension.HC02.6, HC10.1
TRT-GROUP-VALUE
GROUP_VALUE		Alpha 1—HC02.6, HC10.1
TRT-GROUP-DATE
GROUP_DATE		Alpha 1—HC02.6, HC10.1
TRT-AGGR-OPTION
AGGR_OPTION		Alpha 1—HC02.6, HC10.1
TRT-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)Occurs 9 TimesHC02.5, HC10.1

Indexes (3)

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

IndexKeysFlagsConditionUsed in
TRTSET1MEAS-OBJ-ID, TURNOVER-TYPE, GROUP-NAMEPrimaryHC02.2, HC02.5, HC02.6, HCHM.1, HCHP.1
TRTSET2MEAS-OBJ-ID, GROUP-NAMEHC02.6
TRTSET3MEAS-OBJ-ID, GROUP-DATE, GROUP-NAME—

Programs

Updated by (4)

Referenced by (2)