GLACMXVLAU – GL Acct Attribute Value Audit

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

GLACMXVLAU is the GL Acct Attribute Value Audit table in Lawson General Ledger Setup (prefix GAA). It is indexed by OBJ-ID, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D (GAASET1); alternate indexes: GAASET2, GAASET3, GAASET4, GAASET5, GAASET6 and GAAUID. It is related 1:1 to GLACCMXVAL. 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 16 fields, 7 indexes and 1 documented relation.

About GLACMXVLAU

No description in the Lawson data dictionary.

Fields (16)

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

Field / columnTypeDescription & valuesUpdated by
GAA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
GAA-OBJ-ID PK
OBJ_ID		Numeric 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-CHART-NAME
CHART_NAME		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-SUMMARY-ACCT
SUMMARY_ACCT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-ACCOUNT
ACCOUNT		Numeric 6—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-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
GAA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-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
GAA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GAA-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
GAA-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
GAASET1OBJ-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)
GAASET2MATRIX-CAT, CHART-NAME, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-DMX278
GAASET3CHART-NAME, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT, MATRIX-CAT, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-DMX278, MX93.7
GAASET4OPERATOR, ACTION, CHART-NAME, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT, MATRIX-CAT, DATE, OBJ-ID, UNIQUE-I-D—
GAASET5ACTION, DATE, MATRIX-CAT, CHART-NAME, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT, OBJ-ID, UNIQUE-I-D—
GAASET6DATE, CHART-NAME, SUMMARY-ACCT, ACCOUNT, SUB-ACCOUNT, MATRIX-CAT, ACTION, OBJ-ID, UNIQUE-I-DMX278, MX305
GAAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlaccmxvalGLACCMXVALRequiredGAA-OBJ-ID → GAC-OBJ-ID (GACSET1), GAA-MATRIX-CAT → GAC-MATRIX-CAT

Programs

Updated by (40)

Referenced by (103)