GTMXVALUE – Attribute Template Value

System
General Ledger Setup (IF)
Prefix
GMV
Primary key
OBJ-ID, MATRIX-CAT
Fields
3
Updated by
15 programs
Referenced by
38 programs

GTMXVALUE is the Attribute Template Value table in Lawson General Ledger Setup (prefix GMV). It is indexed by OBJ-ID, MATRIX-CAT (GMVSET1); alternate indexes: GMVSET2. It is related 1:1 to GLTRANS and MXCATDEF and 1:M to GTMXVALUAU. It is updated by GL110, GL146, GL197, GL199, GL300, GL40.1, GL40.2, GL40.3 and 7 more and referenced by GL14.1, GL14.5, GL14.7, GL14.8, GL147, GL16.1, GL16.2, GL16.3 and 30 more. The table has 3 fields, 2 indexes and 3 documented relations.

About GTMXVALUE

This file checks transactions for valid attribute values.

Fields (3)

Column = COBOL field name without the GMV- 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
#GMV-OBJ-ID PK
OBJ_ID		Numeric 12The ID of the object being used by the attribute.GL110, GL146, GL197, GL199, GL40.1, GL40.2, GL40.3, GL40.6 +6 more
#GMV-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like an accounting unit) to track additional information. Attribute values may then be used in selection and sorting for reporting and analysis.GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL44.1 +3 more
#GMV-MX-VALUE SET2
MX_VALUE		Alpha 32The attribute value.GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL44.1 +3 more

Indexes (2)

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
GMVSET1
  1. OBJ-ID
  2. MATRIX-CAT
PrimaryGL110, GL146, GL147, GL170, GL190, GL197, GL199, GL240 +22 more (list truncated in source)
GMVSET2
  1. MATRIX-CAT
  2. MX-VALUE
  3. OBJ-ID
KeyChangeGL256

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GltransGLTRANSRequired
GMV-OBJ-ID→GLT-OBJ-ID
MxcatdefMXCATDEFRequired
GMV-MATRIX-CAT→MXC-MATRIX-CAT

One to many (1) — child tables

RelationTableRulesConditionField map
GtmxvaluauGTMXVALUAU
GMV-OBJ-ID→GVA-OBJ-ID
GMV-MATRIX-CAT→GVA-MATRIX-CAT
—→GVA-ACTION
—→GVA-DATE
—→GVA-TIME
—→GVA-UNIQUE-I-D

Programs

Updated by (15)

Referenced by (38)