GTMXVALUAU – JE Attribute Value Audit

System
General Ledger Setup (IF)
Prefix
GVA
Primary key
OBJ-ID, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D
Fields
18
Updated by
40 programs
Referenced by
103 programs

GTMXVALUAU is the JE Attribute Value Audit table in Lawson General Ledger Setup (prefix GVA). It is indexed by OBJ-ID, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D (GVASET1); alternate indexes: GVASET2, GVASET3, GVASET4, GVASET5, GVASET6 and GVAUID. It is related 1:1 to GTMXVALUE. It is updated by GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 and 32 more and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 95 more. The table has 18 fields, 7 indexes and 1 documented relation.

About GTMXVALUAU

No description in the Lawson data dictionary.

Fields (18)

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

Field / columnTypeDescription & valuesUpdated by
GVA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
GVA-OBJ-ID PK
OBJ_ID		Numeric 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-COMPANY
COMPANY		Numeric 4—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-FISCAL-YEAR
FISCAL_YEAR		Numeric 4—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-ACCT-PERIOD
ACCT_PERIOD		Numeric 2—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-SYSTEM
SYSTEM		Alpha 2—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-JE-TYPE
JE_TYPE		Alpha 1—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-CONTROL-GROUP
CONTROL_GROUP		Numeric 8—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GVA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more

Indexes (7)

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

IndexKeysFlagsConditionUsed in
GVASET1OBJ-ID, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
GVASET2MATRIX-CAT, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-DMX278
GVASET3COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, MATRIX-CAT, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-DMX278, MX93.8
GVASET4OPERATOR, ACTION, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, MATRIX-CAT, DATE, OBJ-ID, UNIQUE-I-D—
GVASET5ACTION, DATE, MATRIX-CAT, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, OBJ-ID, UNIQUE-I-D—
GVASET6DATE, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, MATRIX-CAT, ACTION, OBJ-ID, UNIQUE-I-DMX278, MX305
GVAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GtmxvalueGTMXVALUERequiredGVA-OBJ-ID → GMV-OBJ-ID (GMVSET1), GVA-MATRIX-CAT → GMV-MATRIX-CAT

Programs

Updated by (40)

Referenced by (103)