MXVEWDTLAU – Attribute View Detail Audit

System
General Ledger Setup (IF)
Prefix
VDA
Primary key
OBJ-TYPE, MATRIX-VIEW, SEQ-NUMBER, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-D
Fields
14
Updated by
40 programs
Referenced by
103 programs

MXVEWDTLAU is the Attribute View Detail Audit table in Lawson General Ledger Setup (prefix VDA). It is indexed by OBJ-TYPE, MATRIX-VIEW, SEQ-NUMBER, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-D (VDASET1); alternate indexes: VDASET2, VDASET3, VDASET4, VDASET5 and VDAUID. It is related 1:1 to MXVIEWDTL. 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 14 fields, 6 indexes and 1 documented relation.

About MXVEWDTLAU

No description in the Lawson data dictionary.

Fields (14)

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

Field / columnTypeDescription & valuesUpdated by
VDA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
VDA-OBJ-TYPE PK
OBJ_TYPE		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-MATRIX-VIEW PK
MATRIX_VIEW		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-OBJ-ID PK
OBJ_ID		Numeric 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-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
VDA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-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
VDA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
VDA-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
VDA-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
VDASET1OBJ-TYPE, MATRIX-VIEW, SEQ-NUMBER, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
VDASET2MATRIX-VIEW, OBJ-TYPE, SEQ-NUMBER, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-D—
VDASET3OPERATOR, ACTION, DATE, MATRIX-VIEW, OBJ-TYPE, SEQ-NUMBER, OBJ-ID, UNIQUE-I-D—
VDASET4ACTION, DATE, MATRIX-VIEW, OBJ-TYPE, SEQ-NUMBER, OBJ-ID, UNIQUE-I-D—
VDASET5DATE, OBJ-TYPE, MATRIX-VIEW, ACTION, SEQ-NUMBER, OBJ-ID, UNIQUE-I-DMX278, MX305
VDAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxviewdtlMXVIEWDTLRequiredVDA-OBJ-TYPE → MVD-OBJ-TYPE (MVDSET1), VDA-MATRIX-VIEW → MVD-MATRIX-VIEW, VDA-SEQ-NUMBER → MVD-SEQ-NUMBER, VDA-OBJ-ID → MVD-OBJ-ID

Programs

Updated by (40)

Referenced by (103)