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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GMVSET1OBJ-ID, MATRIX-CATPrimaryGL110, GL146, GL147, GL170, GL190, GL197, GL199, GL240 +22 more (list truncated in source)
GMVSET2MATRIX-CAT, MX-VALUE, OBJ-IDKeyChangeGL256

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GltransGLTRANSRequiredGMV-OBJ-ID → GLT-OBJ-ID
MxcatdefMXCATDEFRequiredGMV-MATRIX-CAT → MXC-MATRIX-CAT

One to many (1) — child tables

RelationTableRulesConditionField map
GtmxvaluauGTMXVALUAUGMV-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)