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 / columnTypeDescription & valuesUpdated by
GXV-TEMPLATE-NAME PK
TEMPLATE_NAME
Alpha 12This field contains the accounting unit template name.GL14.1, GL14.5, GL14.7, GL14.8
GXV-ACCT-UNIT PK
ACCT_UNIT
Alpha 15This 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 PK
MATRIX_CAT
Alpha 12This 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-VALUE
MX_VALUE
Alpha 32This 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.

IndexKeysFlagsConditionUsed in
GXVSET1TEMPLATE-NAME, ACCT-UNIT, MATRIX-CATPrimaryGL146, 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

RelationTableRulesConditionField map
GlautmxvauGLAUTMXVAUGXV-TEMPLATE-NAMEGXA-TEMPLATE-NAME, GXV-ACCT-UNITGXA-ACCT-UNIT, GXV-MATRIX-CATGXA-MATRIX-CAT, GXA-ACTION, GXA-DATE, GXA-TIME, GXA-UNIQUE-I-D

Programs

Updated by (5)

Referenced by (38)