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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#MTI-OBJ-TYPE PKOBJ_TYPE | Alpha 5 | This field determines the object type associated with the tempalte. The object type is always ACCTU. | MX06.2 |
#MTI-TEMPLATE-NAME PKTEMPLATE_NAME | Alpha 12 | This field contains the name of the template. | MX06.2 |
#MTI-MATRIX-CATMATRIX_CAT | Alpha 12 | This field contains the attribute name. | — |
#MTI-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field contains the attribute description. | MX06.2 |
Indexes (1)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MTISET1 |
| 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 |
|
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mxtmplefdt | MXTMPLEFDT | Delete Cascades |
| |||||||||||||||||||
| Mxtphedtau | MXTPHEDTAU |
|
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