MXTMPLHDR – Attribute Template Header

System
General Ledger Setup (IF)
Prefix
MTH
Primary key
OBJ-TYPE, TEMPLATE-NAME
Fields
4
Updated by
1 program
Referenced by
51 programs

MXTMPLHDR is the Attribute Template Header table in Lawson General Ledger Setup (prefix MTH). It is indexed by OBJ-TYPE, TEMPLATE-NAME (MTHSET1). It is related 1:1 to OBJID and 1:M to MXTMPHDRAU and MXTMPLDTL. It is updated by MX05.2 and referenced by AC13.1, AC14.1, AC16.1, AC16.2, AC56.1, AM23.1, AP03.1, AR23.1 and 43 more. The table has 4 fields, 1 index and 3 documented relations.

About MXTMPLHDR

This file contains attribute template header records, including the object type, template name, and description defined in MX05.1 (Attribute Template). Templates are used to group several attribute categories together.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
MTH-OBJ-TYPE PK
OBJ_TYPE
Alpha 5This field determines the type of object used by the Attribute. These values are not user maintainable.MX05.2
MTH-TEMPLATE-NAME PK
TEMPLATE_NAME
Alpha 12The name associated with the attribute template.MX05.2
MTH-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)The attribute template description.MX05.2
MTH-SHORT-DESC
SHORT_DESC
DerivedShort description for the attribute template.

Indexes (1)

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

IndexKeysFlagsConditionUsed in
MTHSET1OBJ-TYPE, TEMPLATE-NAMEPrimaryAC13.1, AC14.1, AC16.1, AC16.2, AC56.1, AM23.1, AP03.1, AR23.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
Object IdOBJIDRequiredMTH-OBJ-TYPEOBI-OBJ-TYPE

One to many (2) — child tables

RelationTableRulesConditionField map
MxtmphdrauMXTMPHDRAUMTH-OBJ-TYPETHA-OBJ-TYPE, MTH-TEMPLATE-NAMETHA-TEMPLATE-NAME, THA-ACTION, THA-DATE, THA-TIME, THA-UNIQUE-I-D
MxtmpldtlMXTMPLDTLDelete CascadesMTH-OBJ-TYPEMTD-OBJ-TYPE, MTH-TEMPLATE-NAMEMTD-TEMPLATE-NAME, MTD-MATRIX-CAT

Programs

Updated by (1)

Referenced by (51)