MXCATDEFAU – Attribute Definition Audit

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

MXCATDEFAU is the Attribute Definition Audit table in Lawson General Ledger Setup (prefix MCU). It is indexed by MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D (MCUSET1); alternate indexes: MCUSET2, MCUSET3, MCUSET4 and MCUUID. It is related 1:1 to MXCATDEF. 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 11 fields, 5 indexes and 1 documented relation.

About MXCATDEFAU

No description in the Lawson data dictionary.

Fields (11)

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

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

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

IndexKeysFlagsConditionUsed in
MCUSET1MATRIX-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)
MCUSET2OPERATOR, ACTION, DATE, MATRIX-CAT, UNIQUE-I-D—
MCUSET3ACTION, DATE, MATRIX-CAT, UNIQUE-I-DMX278
MCUSET4DATE, MATRIX-CAT, ACTION, UNIQUE-I-DMX278, MX305
MCUUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxcatdefMXCATDEFRequiredMCU-MATRIX-CAT → MXC-MATRIX-CAT (MXCSET1)

Programs

Updated by (40)

Referenced by (103)