GMGRTMXVAL – No description in the Lawson data dictionary

System
GM (GM)
Prefix
GAB
Primary key
OBJ-ID, MATRIX-CAT
Fields
4
Updated by
2 programs
Referenced by
2 programs

GMGRTMXVAL is a Lawson GM table (prefix GAB); no description in the lawson data dictionary. It is indexed by OBJ-ID, MATRIX-CAT (GABSET1); alternate indexes: GABSET2. It is related 1:1 to GMGRANT, MXCATDEF and MXOBJCAT and 1:M to GMGRTMXVDT and GMGRTMXVAL. It is updated by AC135 and MX500 and referenced by MX123 and MX202. The table has 4 fields, 2 indexes and 5 documented relations.

About GMGRTMXVAL

No description in the Lawson data dictionary.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
GAB-OBJ-ID PK
OBJ_ID		Numeric 12—AC135, MX500
GAB-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—AC135, MX500
GAB-MX-VALUE
MX_VALUE		Alpha 32—AC135, MX500
GAB-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)——

Indexes (2)

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

IndexKeysFlagsConditionUsed in
GABSET1OBJ-ID, MATRIX-CATPrimaryAC135, MX123, MX202, MX500
GABSET2MATRIX-CAT, MX-VALUE, OBJ-IDKeyChangeAC135, MX123, MX202, MX500

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
GmgrantGMGRANTRequiredGAB-OBJ-ID → GRN-OBJ-ID
MxcatdefMXCATDEFRequiredGAB-MATRIX-CAT → MXC-MATRIX-CAT
MxobjcatMXOBJCATRequired"GMGRT" → MOC-OBJ-TYPE, GAB-MATRIX-CAT → MOC-MATRIX-CAT

One to many (2) — child tables

RelationTableRulesConditionField map
GmgrtmxvdtGMGRTMXVDTGAB-OBJ-ID → GAE-OBJ-ID, GAB-MATRIX-CAT → GAE-MATRIX-CAT, → GAE-EFFECTIVE-DATE
Same ValueGMGRTMXVALGAB-MATRIX-CAT → GAB-MATRIX-CAT, GAB-MX-VALUE → GAB-MX-VALUE, → GAB-OBJ-ID

Programs

Updated by (2)

Referenced by (2)