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.

Field / columnTypeDescription & valuesUpdated by
GAC-OBJ-ID PK
OBJ_ID		Numeric 12This is the unique object identifier.GL16.1, GL16.2, GL16.3, GL16.4, MX500
GAC-MATRIX-CAT PK
MATRIX_CAT		Alpha 12This is the attribute name assigned to an account object.GL16.1, GL16.2, GL16.3, GL16.4, MX500
GAC-MX-VALUE
MX_VALUE		Alpha 32This the value of the attribute.GL16.1, GL16.2, GL16.3, GL16.4, MX500

Indexes (2)

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

IndexKeysFlagsConditionUsed in
GACSET1OBJ-ID, MATRIX-CATPrimaryACVW.1, ATVW.1, GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7 +22 more (list truncated in source)
GACSET2MATRIX-CAT, MX-VALUE, OBJ-IDKeyChangeGLAC.1, MX123, MX202

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
GlacmxvlauGLACMXVLAUGAC-OBJ-ID → GAA-OBJ-ID, GAC-MATRIX-CAT → GAA-MATRIX-CAT, → GAA-ACTION, → GAA-DATE, → GAA-TIME, → GAA-UNIQUE-I-D

Programs

Updated by (7)

Referenced by (47)