MXELEMNTAU – Attribute Element Audit

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

MXELEMNTAU is the Attribute Element Audit table in Lawson General Ledger Setup (prefix MEA). It is indexed by ELEMENT-NAME, ACTION, DATE, TIME, UNIQUE-I-D (MEASET1); alternate indexes: MEASET2, MEASET3, MEASET4 and MEAUID. It is related 1:1 to MXELEMENT. 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 MXELEMNTAU

No description in the Lawson data dictionary.

Fields (11)

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

Field / columnTypeDescription & valuesUpdated by
MEA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
MEA-ELEMENT-NAME PK
ELEMENT_NAME		Alpha 20—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MEA-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
MEA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MEA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MEA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MEA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MEA-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
MEA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MEA-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
MEA-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
MEASET1ELEMENT-NAME, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
MEASET2OPERATOR, ACTION, DATE, ELEMENT-NAME, UNIQUE-I-D—
MEASET3ACTION, DATE, ELEMENT-NAME, UNIQUE-I-D—
MEASET4DATE, ELEMENT-NAME, ACTION, UNIQUE-I-DMX278, MX305
MEAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxelementMXELEMENTRequiredMEA-ELEMENT-NAME → MXE-ELEMENT-NAME (MXESET1)

Programs

Updated by (40)

Referenced by (103)