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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GAE-OBJ-ID PKOBJ_ID | Numeric 12 | — | — |
GAE-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | — | — |
GAE-MX-VALUEMX_VALUE | Alpha 32 | — | — |
GAE-EFFECTIVE-DATE PKEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | — | — |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GAESET1 | OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE | Primary | MX202 | |
GAESET2 | MATRIX-CAT, EFFECTIVE-DATE, OBJ-ID | MX202 | ||
GAESET3 | OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE* | AC135 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Gmgrant | GMGRANT | Required | GAE-OBJ-ID → GRN-OBJ-ID | |
| Gmgrtmxval | GMGRTMXVAL | Required | GAE-OBJ-ID → GAB-OBJ-ID, GAE-MATRIX-CAT → GAB-MATRIX-CAT | |
| Mxcatdef | MXCATDEF | Required | GAE-MATRIX-CAT → MXC-MATRIX-CAT | |
| Mxobjcat | MXOBJCAT | Required | "GMGRT" → MOC-OBJ-TYPE, GAE-MATRIX-CAT → MOC-MATRIX-CAT |
Programs
No Lawson programs are documented as updating or referencing this table.