MXOBJCATAU – Attribute Object Audit

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

MXOBJCATAU is the Attribute Object Audit table in Lawson General Ledger Setup (prefix MOA). It is indexed by OBJ-TYPE, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D (MOASET1); alternate indexes: MOASET2, MOASET3, MOASET4, MOASET5 and MOAUID. It is related 1:1 to MXOBJCAT. 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 12 fields, 6 indexes and 1 documented relation.

About MXOBJCATAU

No description in the Lawson data dictionary.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
MOA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
MOA-OBJ-TYPE PK
OBJ_TYPE		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MOA-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MOA-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
MOA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MOA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MOA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MOA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MOA-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
MOA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
MOA-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
MOA-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
MOASET1OBJ-TYPE, MATRIX-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)
MOASET2MATRIX-CAT, OBJ-TYPE, ACTION, DATE, TIME, UNIQUE-I-DMX278, MX91.4
MOASET3OPERATOR, ACTION, DATE, OBJ-TYPE, MATRIX-CAT, UNIQUE-I-D—
MOASET4ACTION, DATE, OBJ-TYPE, MATRIX-CAT, UNIQUE-I-DMX305
MOASET5DATE, MATRIX-CAT, OBJ-TYPE, ACTION, UNIQUE-I-DMX278, MX305
MOAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxobjcatMXOBJCATRequiredMOA-OBJ-TYPE → MOC-OBJ-TYPE (MOCSET1), MOA-MATRIX-CAT → MOC-MATRIX-CAT

Programs

Updated by (40)

Referenced by (103)