MXTMPHDRAU – Attribute Template Hdr Audit

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

MXTMPHDRAU is the Attribute Template Hdr Audit table in Lawson General Ledger Setup (prefix THA). It is indexed by OBJ-TYPE, TEMPLATE-NAME, ACTION, DATE, TIME, UNIQUE-I-D (THASET1); alternate indexes: THASET2, THASET3, THASET4, THASET5 and THAUID. It is related 1:1 to MXTMPLHDR. 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 MXTMPHDRAU

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the THA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#THA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#THA-OBJ-TYPE PK
OBJ_TYPE		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#THA-TEMPLATE-NAME PK
TEMPLATE_NAME		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#THA-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
#THA-OPERATOR SET3
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#THA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#THA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#THA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#THA-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
#THA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
#THA-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
#THA-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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
THASET1
  1. OBJ-TYPE
  2. TEMPLATE-NAME
  3. ACTION
  4. DATE
  5. TIME
  6. UNIQUE-I-D
PrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
THASET2
  1. TEMPLATE-NAME
  2. OBJ-TYPE
  3. ACTION
  4. DATE
  5. TIME
  6. UNIQUE-I-D
—
THASET3
  1. OPERATOR
  2. ACTION
  3. DATE
  4. TEMPLATE-NAME
  5. OBJ-TYPE
  6. UNIQUE-I-D
—
THASET4
  1. ACTION
  2. DATE
  3. TEMPLATE-NAME
  4. OBJ-TYPE
  5. UNIQUE-I-D
MX278
THASET5
  1. DATE
  2. OBJ-TYPE
  3. TEMPLATE-NAME
  4. ACTION
  5. UNIQUE-I-D
MX305
THAUID
  1. UNIQUE-I-D
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
MXTMPLHDRMXTMPHDRAU

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxtmplhdrMXTMPLHDRRequired
THA-OBJ-TYPE→MTH-OBJ-TYPE (MTHSET1)
THA-TEMPLATE-NAME→MTH-TEMPLATE-NAME

Programs

Updated by (40)

Referenced by (103)