MXTMPLDTL – Attribute Template Detail

System
General Ledger Setup (IF)
Prefix
MTD
Primary key
OBJ-TYPE, TEMPLATE-NAME, MATRIX-CAT
Fields
4
Updated by
2 programs
Referenced by
53 programs

MXTMPLDTL is the Attribute Template Detail table in Lawson General Ledger Setup (prefix MTD). It is indexed by OBJ-TYPE, TEMPLATE-NAME, MATRIX-CAT (MTDSET1); alternate indexes: MTDSET2. It is related 1:1 to MXOBJCAT, MXTMPLHDR and OBJID and 1:M to MXTMPDTLAU. It is updated by MX05.1 and MX05.2 and referenced by AC13.1, AC14.1, AC16.1, AC16.2, AC560, AM23.1, AP03.1, AR23.1 and 45 more. The table has 4 fields, 2 indexes and 4 documented relations.

About MXTMPLDTL

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

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
MTD-OBJ-TYPE PK
OBJ_TYPE		Alpha 5This field determines the type of object used by the Attribute. These values are not user maintainable.MX05.1
MTD-TEMPLATE-NAME PK
TEMPLATE_NAME		Alpha 12The name associated with the attribute template.MX05.1
MTD-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like an accounting unit) to track additional information. Attribute values are used in selection and sorting for reporting and analysis.MX05.1
MTD-MX-VALUE
MX_VALUE		Alpha 32The category value assigned to the object.MX05.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
MTDSET1OBJ-TYPE, TEMPLATE-NAME, MATRIX-CATPrimaryAC13.1, AC14.1, AC16.1, AC16.2, AC560, AM23.1, AP03.1, AR23.1 +22 more (list truncated in source)
MTDSET2OBJ-TYPE, MATRIX-CAT, TEMPLATE-NAME—

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Matrix CatMXOBJCATRequiredMTD-OBJ-TYPE → MOC-OBJ-TYPE (MOCSET1), MTD-MATRIX-CAT → MOC-MATRIX-CAT
MxtmplhdrMXTMPLHDRRequiredMTD-OBJ-TYPE → MTH-OBJ-TYPE, MTD-TEMPLATE-NAME → MTH-TEMPLATE-NAME
ObjidOBJIDNot RequiredMTD-OBJ-TYPE → OBI-OBJ-TYPE

One to many (1) — child tables

RelationTableRulesConditionField map
MxtmpdtlauMXTMPDTLAUMTD-OBJ-TYPE → TDA-OBJ-TYPE, MTD-TEMPLATE-NAME → TDA-TEMPLATE-NAME, MTD-MATRIX-CAT → TDA-MATRIX-CAT, → TDA-ACTION, → TDA-DATE, → TDA-TIME, → TDA-UNIQUE-I-D

Programs

Updated by (2)

Referenced by (53)