MXLSTDTLAU – Attribute List Detail Audit

System
General Ledger Setup (IF)
Prefix
LDA
Primary key
OBJ-TYPE, MATRIX-LIST, OR-GROUP, MATRIX-CAT, SEQ-NUMBER, ACTION, DATE, TIME, UNIQUE-I-D
Fields
15
Updated by
40 programs
Referenced by
103 programs

MXLSTDTLAU is the Attribute List Detail Audit table in Lawson General Ledger Setup (prefix LDA). It is indexed by OBJ-TYPE, MATRIX-LIST, OR-GROUP, MATRIX-CAT, SEQ-NUMBER, ACTION, DATE, TIME, UNIQUE-I-D (LDASET1); alternate indexes: LDASET2, LDASET3, LDASET4, LDASET5 and LDAUID. It is related 1:1 to MXLISTDTL. 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 15 fields, 6 indexes and 1 documented relation.

About MXLSTDTLAU

No description in the Lawson data dictionary.

Fields (15)

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

Field / columnTypeDescription & valuesUpdated by
LDA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
LDA-OBJ-TYPE PK
OBJ_TYPE		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-MATRIX-LIST PK
MATRIX_LIST		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-OR-GROUP PK
OR_GROUP		Alpha 1—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-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
LDA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-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
LDA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
LDA-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
LDA-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
LDASET1OBJ-TYPE, MATRIX-LIST, OR-GROUP, MATRIX-CAT, SEQ-NUMBER, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
LDASET2MATRIX-LIST, OBJ-TYPE, MATRIX-CAT, OR-GROUP, SEQ-NUMBER, ACTION, DATE, TIME, UNIQUE-I-D—
LDASET3OPERATOR, ACTION, DATE, MATRIX-LIST, OBJ-TYPE, MATRIX-CAT, OR-GROUP, SEQ-NUMBER, UNIQUE-I-D—
LDASET4ACTION, DATE, MATRIX-LIST, OBJ-TYPE, MATRIX-CAT, OR-GROUP, SEQ-NUMBER, UNIQUE-I-DMX278
LDASET5DATE, OBJ-TYPE, MATRIX-LIST, ACTION, MATRIX-CAT, OR-GROUP, SEQ-NUMBER, UNIQUE-I-DMX278, MX305
LDAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxlistdtlMXLISTDTLRequiredLDA-OBJ-TYPE → MLD-OBJ-TYPE (MLDSET1), LDA-MATRIX-LIST → MLD-MATRIX-LIST, LDA-OR-GROUP → MLD-OR-GROUP, LDA-MATRIX-CAT → MLD-MATRIX-CAT, LDA-SEQ-NUMBER → MLD-SEQ-NUMBER

Programs

Updated by (40)

Referenced by (103)