GLAUTMPMXV – GL AU Attribute Template
- System
- General Ledger (GL)
- Prefix
GXV- Primary key
TEMPLATE-NAME,ACCT-UNIT,MATRIX-CAT- Fields
- 4
- Updated by
- 5 programs
- Referenced by
- 38 programs
GLAUTMPMXV is the GL AU Attribute Template table in Lawson General Ledger (prefix GXV). It is indexed by TEMPLATE-NAME, ACCT-UNIT, MATRIX-CAT (GXVSET1). It is related 1:M to GLAUTMXVAU. It is updated by GL14.1, GL14.5, GL14.6, GL14.7 and GL14.8 and referenced by GL123, GL124, GL146, GL16.1, GL16.2, GL16.3, GL16.4, GL197 and 30 more. The table has 4 fields, 1 index and 1 documented relation.
About GLAUTMPMXV
This file maintains the Matrix attributes and attribute values for accounting units associated with a template.
Fields (4)
Column = COBOL field name without the GXV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GXV-TEMPLATE-NAME PKTEMPLATE_NAME | Alpha 12 | This field contains the accounting unit template name. | GL14.1, GL14.5, GL14.7, GL14.8 |
GXV-ACCT-UNIT PKACCT_UNIT | Alpha 15 | This field contains the name of the accounting unit for which attribute values are defined. | GL14.1, GL14.5, GL14.7, GL14.8 |
GXV-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | This field contains the name of the accounting unit attribute to which you are assigning a value. | GL14.1, GL14.5, GL14.7, GL14.8 |
GXV-MX-VALUEMX_VALUE | Alpha 32 | This field contains the value for the accounting unit attribute. | GL14.1, GL14.5, GL14.7, GL14.8 |
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 |
|---|---|---|---|---|
GXVSET1 | TEMPLATE-NAME, ACCT-UNIT, MATRIX-CAT | Primary | GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL44.1 +22 more (list truncated in source) |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Glautmxvau | GLAUTMXVAU | GXV-TEMPLATE-NAME → GXA-TEMPLATE-NAME, GXV-ACCT-UNIT → GXA-ACCT-UNIT, GXV-MATRIX-CAT → GXA-MATRIX-CAT, → GXA-ACTION, → GXA-DATE, → GXA-TIME, → GXA-UNIQUE-I-D |
Programs
Updated by (5)
- GL14.1 Accounting Unit Template Definition
- GL14.5 Values By Attribute
- GL14.6 Define Accounting Unit Template
- GL14.7 Attributes
- GL14.8 Copy Accounting Unit Template
Referenced by (38)
- GL123 Accounting Unit Template Conversion Load
- GL124 Mass Accounting Unit Addition
- 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
- GL214 Accounting Unit Template Listing
- 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
- MX06.1 Attribute Value Effective Date Template
- MX06.2 Define Attibute Value Effective Date 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
- SL40.1 Error Transaction Edit