MXTMPLHEDT – Attr Template Header Detail

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

MXTMPLHEDT is the Attr Template Header Detail table in Lawson General Ledger Setup (prefix MTI). It is indexed by OBJ-TYPE, TEMPLATE-NAME (MTISET1). It is related 1:1 to OBJID and 1:M to MXTMPLEFDT and MXTPHEDTAU. It is updated by MX06.2 and referenced by AC13.1, AC13.7, AC14.1, AC14.6, AC16.1, AC16.2, AC16.7, GL14.1 and 37 more. The table has 4 fields, 1 index and 3 documented relations.

About MXTMPLHEDT

This file contain the header records for the attribute value effective date templates. It is updated by Define Attibute Value Effective Date Template (MX06.2).

Fields (4)

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

Field / column	Type	Description & values	Updated by
`MTI-OBJ-TYPE` PK OBJ_TYPE	Alpha 5	This field determines the object type associated with the tempalte. The object type is always ACCTU.	MX06.2
`MTI-TEMPLATE-NAME` PK TEMPLATE_NAME	Alpha 12	This field contains the name of the template.	MX06.2
`MTI-MATRIX-CAT` MATRIX_CAT	Alpha 12	This field contains the attribute name.	—
`MTI-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field contains the attribute description.	MX06.2

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`MTISET1`	`OBJ-TYPE`, `TEMPLATE-NAME`	Primary		AC13.1, AC13.7, AC14.1, AC14.6, AC16.1, AC16.2, AC16.7, GL146 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Object Id	OBJID	Required		`MTI-OBJ-TYPE` → `OBI-OBJ-TYPE`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Mxtmplefdt	MXTMPLEFDT	Delete Cascades		`MTI-OBJ-TYPE` → `MTE-OBJ-TYPE`, `MTI-TEMPLATE-NAME` → `MTE-TEMPLATE-NAME`, → `MTE-MATRIX-CAT`, → `MTE-EFFECTIVE-DATE`
Mxtphedtau	MXTPHEDTAU			`MTI-OBJ-TYPE` → `TIA-OBJ-TYPE`, `MTI-TEMPLATE-NAME` → `TIA-TEMPLATE-NAME`, → `TIA-ACTION`, → `TIA-DATE`, → `TIA-TIME`, → `TIA-UNIQUE-I-D`

Programs

Updated by (1)

MX06.2 Define Attibute Value Effective Date Template

Referenced by (45)

AC13.1 Activity Attributes
AC13.7 Attribute Value Effective Date
AC14.1 Activity Group Attributes
AC14.6 Attribute Value Effective Date
AC16.1 Summary Account Category Attributes
AC16.2 Detail Account Category Attributes
AC16.7 Attribute Value Effective Date
GL14.1 Accounting Unit Template Definition
GL14.5 Values By Attribute
GL14.7 Attributes
GL14.8 Copy Accounting Unit Template
GL146 Batch Journal Control
GL16.1 Summary Account Attributes
GL16.2 Detail Account Attributes
GL16.3 Summary Account Values by attribute
GL16.4 Detail Account Values by Attributes
GL197 Period, Year End GL Commitments Processing
GL20.7 Attributes
GL20.8 Attribute Value Effective Date
GL20.9 Values By Attribute Effective Date
GL40.1 Journal Entry
GL40.2 Define Journal
GL40.3 Speed Entry
GL40.7 Totals
GL40.8 Journal Entry
GL44.1 Report Currency Entry
GL45.1 Journal Control
GL70.1 Recurring Journal
GL70.2 Define Recurring Journal
GL70.3 Amounts Only
GL70.6 Recurring Copy
MX00.1 Attribute
MX00.2 Element
MX00.3 Associate Attribute to Objects
MX05.1 Attribute Template
MX05.2 Define Template
MX10.1 List
MX10.2 Define List
MX135 Acct Unit Attribute Value Update For Effective Date
MX20.1 View
MX20.2 Define View
MX20.4 Rename Summary Level
MX20.5 View Copy
MX205 Template Listing
SL40.1 Error Transaction Edit