GMGRTMXVDT – No description in the Lawson data dictionary

System
GM (GM)
Prefix
GAE
Primary key
OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE
Fields
4
Updated by
0 programs
Referenced by
0 programs

GMGRTMXVDT is a Lawson GM table (prefix GAE); no description in the lawson data dictionary. It is indexed by OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE (GAESET1); alternate indexes: GAESET2 and GAESET3. It is related 1:1 to GMGRANT, GMGRTMXVAL, MXCATDEF and MXOBJCAT. The table has 4 fields, 3 indexes and 4 documented relations.

About GMGRTMXVDT

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the GAE- 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
#GAE-OBJ-ID PK
OBJ_ID		Numeric 12——
#GAE-MATRIX-CAT PK
MATRIX_CAT		Alpha 12——
#GAE-MX-VALUE
MX_VALUE		Alpha 32——
#GAE-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)——

Indexes (3)

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
GAESET1
  1. OBJ-ID
  2. MATRIX-CAT
  3. EFFECTIVE-DATE
PrimaryMX202
GAESET2
  1. MATRIX-CAT
  2. EFFECTIVE-DATE
  3. OBJ-ID
MX202
GAESET3
  1. OBJ-ID
  2. MATRIX-CAT
  3. EFFECTIVE-DATE ↓
AC135

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GMGRANTGMGRTMXVALMXCATDEFMXOBJCATGMGRTMXVDT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
GmgrantGMGRANTRequired
GAE-OBJ-ID→GRN-OBJ-ID
GmgrtmxvalGMGRTMXVALRequired
GAE-OBJ-ID→GAB-OBJ-ID
GAE-MATRIX-CAT→GAB-MATRIX-CAT
MxcatdefMXCATDEFRequired
GAE-MATRIX-CAT→MXC-MATRIX-CAT
MxobjcatMXOBJCATRequired
"GMGRT"→MOC-OBJ-TYPE
GAE-MATRIX-CAT→MOC-MATRIX-CAT

Programs

No Lawson programs are documented as updating or referencing this table.