AUMXVLDTAU – AU Attribute Value Edate Audit

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

AUMXVLDTAU is the AU Attribute Value Edate Audit table in Lawson General Ledger Setup (prefix UDU). It is indexed by OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE, ACTION, DATE, TIME, UNIQUE-I-D (UDUSET1); alternate indexes: UDUSET2, UDUSET3, UDUSET4, UDUSET5, UDUSET6 and UDUUID. It is related 1:1 to AUMXVALDT. 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, 7 indexes and 1 documented relation.

About AUMXVLDTAU

No description in the Lawson data dictionary.

Fields (15)

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

Field / columnTypeDescription & valuesUpdated by
UDU-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
UDU-OBJ-ID PK
OBJ_ID		Numeric 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-COMPANY
COMPANY		Numeric 4—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-ACCT-UNIT
ACCT_UNIT		Alpha 15—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-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
UDU-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-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
UDU-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
UDU-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
UDU-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
UDUSET1OBJ-ID, MATRIX-CAT, EFFECTIVE-DATE, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
UDUSET2MATRIX-CAT, EFFECTIVE-DATE, COMPANY, ACCT-UNIT, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-DMX278
UDUSET3COMPANY, ACCT-UNIT, MATRIX-CAT, EFFECTIVE-DATE, OBJ-ID, ACTION, DATE, TIME, UNIQUE-I-DMX278, MX93.5
UDUSET4OPERATOR, ACTION, COMPANY, ACCT-UNIT, MATRIX-CAT, EFFECTIVE-DATE, DATE, OBJ-ID, UNIQUE-I-D—
UDUSET5ACTION, DATE, MATRIX-CAT, EFFECTIVE-DATE, COMPANY, ACCT-UNIT, OBJ-ID, UNIQUE-I-D—
UDUSET6DATE, COMPANY, ACCT-UNIT, MATRIX-CAT, EFFECTIVE-DATE, ACTION, OBJ-ID, UNIQUE-I-DMX278, MX305
UDUUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AumxvaldtAUMXVALDTRequiredUDU-OBJ-ID → AVD-OBJ-ID (AVDSET1), UDU-MATRIX-CAT → AVD-MATRIX-CAT, UDU-EFFECTIVE-DATE → AVD-EFFECTIVE-DATE

Programs

Updated by (40)

Referenced by (103)