GLAUTMPVLD – GL AU Attribute Value Template

System
General Ledger (GL)
Prefix
GAV
Primary key
TEMPLATE-NAME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM
Fields
5
Updated by
5 programs
Referenced by
2 programs

GLAUTMPVLD is the GL AU Attribute Value Template table in Lawson General Ledger (prefix GAV). It is indexed by TEMPLATE-NAME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM (GAVSET1). It is updated by GL14.1, GL14.2, GL14.4, GL14.6 and GL14.8 and referenced by GL123 and GL124. The table has 5 fields, 1 index and 0 documented relations.

About GLAUTMPVLD

This file maintains the restricted systems for accounting unit template accounts. Accounts can be used only by the applications listed.

Fields (5)

Column = COBOL field name without the GAV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GAV-TEMPLATE-NAME PK
TEMPLATE_NAME		Alpha 12This field contains the name of the accounting unit template for which systems are restricted.GL14.2, GL14.8
GAV-ACCT-UNIT PK
ACCT_UNIT		Alpha 15This field contains the name of the accounting unit for which systems are restricted.GL14.2, GL14.4, GL14.8
GAV-ACCOUNT PK
ACCOUNT		Numeric 6This field contains the account for which systems are restricted.GL14.2, GL14.8
GAV-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4This field contains the subaccount for which systems are restricted.GL14.2, GL14.8
GAV-SYSTEM PK
SYSTEM		Alpha 2This field contains the system code for which the template, accounting unit, account, and subaccount are valid.GL14.2, 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
GAVSET1TEMPLATE-NAME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEMPrimaryGL123, GL124, GL14.1, GL14.2, GL14.4, GL14.6, GL14.8

Programs

Updated by (5)

Referenced by (2)