MXTMPDTLAU – Attribute Template Dtl Audit

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

MXTMPDTLAU is the Attribute Template Dtl Audit table in Lawson General Ledger Setup (prefix TDA). It is indexed by OBJ-TYPE, TEMPLATE-NAME, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D (TDASET1); alternate indexes: TDASET2, TDASET3, TDASET4, TDASET5 and TDAUID. It is related 1:1 to MXTMPLDTL. 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 13 fields, 6 indexes and 1 documented relation.

About MXTMPDTLAU

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
TDA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
TDA-OBJ-TYPE PK
OBJ_TYPE		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
TDA-TEMPLATE-NAME PK
TEMPLATE_NAME		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
TDA-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
TDA-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
TDA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
TDA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
TDA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
TDA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
TDA-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
TDA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
TDA-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
TDA-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
TDASET1OBJ-TYPE, TEMPLATE-NAME, 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)
TDASET2TEMPLATE-NAME, OBJ-TYPE, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D—
TDASET3OPERATOR, ACTION, DATE, TEMPLATE-NAME, OBJ-TYPE, MATRIX-CAT, UNIQUE-I-D—
TDASET4ACTION, DATE, TEMPLATE-NAME, OBJ-TYPE, MATRIX-CAT, UNIQUE-I-D—
TDASET5DATE, OBJ-TYPE, TEMPLATE-NAME, ACTION, MATRIX-CAT, UNIQUE-I-DMX278, MX305
TDAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxtmpldtlMXTMPLDTLRequiredTDA-OBJ-TYPE → MTD-OBJ-TYPE (MTDSET1), TDA-TEMPLATE-NAME → MTD-TEMPLATE-NAME, TDA-MATRIX-CAT → MTD-MATRIX-CAT

Programs

Updated by (40)

Referenced by (103)