GLAUTMXVAU – GL AU Attribute Template Audit

System
General Ledger (GL)
Prefix
GXA
Primary key
TEMPLATE-NAME, ACCT-UNIT, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D
Fields
13
Updated by
40 programs
Referenced by
103 programs

GLAUTMXVAU is the GL AU Attribute Template Audit table in Lawson General Ledger (prefix GXA). It is indexed by TEMPLATE-NAME, ACCT-UNIT, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D (GXASET1); alternate indexes: GXASET2, GXASET3, GXASET4, GXASET5 and GXAUID. It is related 1:1 to GLAUTMPMXV. 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 13 fields, 6 indexes and 1 documented relation.

About GLAUTMXVAU

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
GXA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
GXA-TEMPLATE-NAME PK
TEMPLATE_NAME		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GXA-ACCT-UNIT PK
ACCT_UNIT		Alpha 15—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GXA-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GXA-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
GXA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GXA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GXA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GXA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GXA-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
GXA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
GXA-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
GXA-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 (6)

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

IndexKeysFlagsConditionUsed in
GXASET1TEMPLATE-NAME, ACCT-UNIT, 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)
GXASET2ACCT-UNIT, MATRIX-CAT, TEMPLATE-NAME, ACTION, DATE, TIME, UNIQUE-I-D—
GXASET3OPERATOR, ACTION, DATE, TEMPLATE-NAME, ACCT-UNIT, MATRIX-CAT, UNIQUE-I-D—
GXASET4ACTION, DATE, TEMPLATE-NAME, ACCT-UNIT, MATRIX-CAT, UNIQUE-I-D—
GXASET5DATE, TEMPLATE-NAME, ACCT-UNIT, ACTION, MATRIX-CAT, UNIQUE-I-DMX278, MX305
GXAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlautmpmxvGLAUTMPMXVRequiredGXA-TEMPLATE-NAME → GXV-TEMPLATE-NAME (GXVSET1), GXA-ACCT-UNIT → GXV-ACCT-UNIT, GXA-MATRIX-CAT → GXV-MATRIX-CAT

Programs

Updated by (40)

Referenced by (103)