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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 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
MTDSET1
  1. OBJ-TYPE
  2. TEMPLATE-NAME
  3. MATRIX-CAT
PrimaryAC13.1, AC14.1, AC16.1, AC16.2, AC560, AM23.1, AP03.1, AR23.1 +22 more (list truncated in source)
MTDSET2
  1. OBJ-TYPE
  2. MATRIX-CAT
  3. TEMPLATE-NAME
—

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Matrix CatMXOBJCATRequired
MTD-OBJ-TYPE→MOC-OBJ-TYPE (MOCSET1)
MTD-MATRIX-CAT→MOC-MATRIX-CAT
MxtmplhdrMXTMPLHDRRequired
MTD-OBJ-TYPE→MTH-OBJ-TYPE
MTD-TEMPLATE-NAME→MTH-TEMPLATE-NAME
ObjidOBJIDNot Required
MTD-OBJ-TYPE→OBI-OBJ-TYPE

One to many (1) — child tables

RelationTableRulesConditionField map
MxtmpdtlauMXTMPDTLAU
MTD-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)