GLACCMXVAL – GL Account Attribute Value
- System
- General Ledger Setup (IF)
- Prefix
GAC- Primary key
OBJ-ID,MATRIX-CAT- Fields
- 3
- Updated by
- 7 programs
- Referenced by
- 47 programs
GLACCMXVAL is the GL Account Attribute Value table in Lawson General Ledger Setup (prefix GAC). It is indexed by OBJ-ID, MATRIX-CAT (GACSET1); alternate indexes: GACSET2. It is related 1:M to GLACMXVLAU. It is updated by GL00.1, GL00.3, GL16.1, GL16.2, GL16.3, GL16.4 and MX500 and referenced by ACVW.1, ATVW.1, GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL197 and 39 more. The table has 3 fields, 2 indexes and 1 documented relation.
About GLACCMXVAL
This file defines the fields for the ACCNT attributes.
Fields (3)
Column = COBOL field name without the GAC- 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 |
|---|---|---|---|
#GAC-OBJ-ID PKOBJ_ID | Numeric 12 | This is the unique object identifier. | GL16.1, GL16.2, GL16.3, GL16.4, MX500 |
#GAC-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | This is the attribute name assigned to an account object. | GL16.1, GL16.2, GL16.3, GL16.4, MX500 |
#GAC-MX-VALUE SET2MX_VALUE | Alpha 32 | This the value of the attribute. | GL16.1, GL16.2, GL16.3, GL16.4, MX500 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GACSET1 |
| Primary | ACVW.1, ATVW.1, GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +22 more (list truncated in source) | |
GACSET2 |
| KeyChange | GLAC.1, MX123, MX202 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Glacmxvlau | GLACMXVLAU |
|
Programs
Updated by (7)
- GL00.1 Chart of Accounts
- GL00.3 Detail Accounts
- GL16.1 Summary Account Attributes
- GL16.2 Detail Account Attributes
- GL16.3 Summary Account Values by attribute
- GL16.4 Detail Account Values by Attributes
- MX500 Attribute Value Population
Referenced by (47)
- ACVW.1 Build GL Accounting Unit View
- ATVW.1 Build Account Category View
- GL14.1 Accounting Unit Template Definition
- GL14.5 Values By Attribute
- GL14.7 Attributes
- GL14.8 Copy Accounting Unit Template
- GL146 Batch Journal Control
- 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
- GLAC.1 Build GL Accounting Unit Matrix List
- GLAV.1 Build GL Accounting Unit View
- GLCV.1 General Ledger Chart View Build
- GLVW.1 Build GL Accounting Unit View
- IFBA.1 Olap Dimension Retrieval Format
- 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
- MX123 List Member Build
- 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
- MX202 Attribute Value Listing
- PA495 IPEDS Report
- RW100 Report Generation
- SL40.1 Error Transaction Edit
- SLVW.1 Build SL Accounting Unit View