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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2 SET3 SET4 SET5 SET6
COMPANY		Numeric 4—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#GVA-FISCAL-YEAR SET2 SET3 SET4 SET5 SET6
FISCAL_YEAR		Numeric 4—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#GVA-ACCT-PERIOD SET2 SET3 SET4 SET5 SET6
ACCT_PERIOD		Numeric 2—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#GVA-SYSTEM SET2 SET3 SET4 SET5 SET6
SYSTEM		Alpha 2—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#GVA-JE-TYPE SET2 SET3 SET4 SET5 SET6
JE_TYPE		Alpha 1—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#GVA-CONTROL-GROUP SET2 SET3 SET4 SET5 SET6
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 SET4
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 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
GVASET1
  1. OBJ-ID
  2. MATRIX-CAT
  3. ACTION
  4. DATE
  5. TIME
  6. UNIQUE-I-D
PrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
GVASET2
  1. MATRIX-CAT
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. SYSTEM
  6. JE-TYPE
  7. CONTROL-GROUP
  8. OBJ-ID
  9. ACTION
  10. DATE
  11. TIME
  12. UNIQUE-I-D
MX278
GVASET3
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. SYSTEM
  5. JE-TYPE
  6. CONTROL-GROUP
  7. MATRIX-CAT
  8. OBJ-ID
  9. ACTION
  10. DATE
  11. TIME
  12. UNIQUE-I-D
MX278, MX93.8
GVASET4
  1. OPERATOR
  2. ACTION
  3. COMPANY
  4. FISCAL-YEAR
  5. ACCT-PERIOD
  6. SYSTEM
  7. JE-TYPE
  8. CONTROL-GROUP
  9. MATRIX-CAT
  10. DATE
  11. OBJ-ID
  12. UNIQUE-I-D
—
GVASET5
  1. ACTION
  2. DATE
  3. MATRIX-CAT
  4. COMPANY
  5. FISCAL-YEAR
  6. ACCT-PERIOD
  7. SYSTEM
  8. JE-TYPE
  9. CONTROL-GROUP
  10. OBJ-ID
  11. UNIQUE-I-D
—
GVASET6
  1. DATE
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. SYSTEM
  6. JE-TYPE
  7. CONTROL-GROUP
  8. MATRIX-CAT
  9. ACTION
  10. OBJ-ID
  11. UNIQUE-I-D
MX278, MX305
GVAUID
  1. UNIQUE-I-D
—

Relations

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

One to one (1) — lookups and parents

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

Programs

Updated by (40)

Referenced by (103)