GLACCTVLD – GL Account Validation

System
General Ledger Setup (IF)
Prefix
VLD
Primary key
RECORD-TYPE, CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNT, COMPANY, ACCT-UNIT, SYSTEM
Fields
8
Updated by
14 programs
Referenced by
46 programs

GLACCTVLD is the GL Account Validation table in Lawson General Ledger Setup (prefix VLD). It is indexed by RECORD-TYPE, CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNT, COMPANY, ACCT-UNIT, SYSTEM (VLDSET1); alternate indexes: VLDSET2 and VLDSET3. It is related 1:1 to GLCODES and SYSTEMCODE. It is updated by GL00.2, GL00.9, GL02.3, GL03.4, GL03.5, GL03.6, GL100, GL110 and 6 more and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 38 more. The table has 8 fields, 3 indexes and 2 documented relations.

About GLACCTVLD

This file is used to validate accounting unit, account, and subsystem information.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
VLD-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
  • M Master Acct
GL02.3, GL03.4, GL03.5, GL03.6, GL100, GL122, GL124, GL160
VLD-CHART-NAME PK
CHART_NAME		Alpha 12This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.GL00.9, GL02.3, GL03.4, GL03.5, GL03.6, GL100, GL124, GL160
VLD-SUMRY-ACCT-ID PK
SUMRY_ACCT_ID		Numeric 6The summary account identifier.GL02.3, GL03.4, GL03.5, GL03.6, GL100, GL124, GL160
VLD-ACCOUNT PK
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.GL02.3, GL03.4, GL03.5, GL03.6, GL100, GL122, GL124, GL160
VLD-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information are stored.GL02.3, GL03.4, GL03.5, GL03.6, GL100, GL122, GL124, GL160
VLD-COMPANY PK
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).GL02.3, GL03.4, GL03.5, GL03.6, GL110, GL122, GL124, GL160
VLD-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number.GL02.3, GL03.4, GL03.5, GL03.6, GL100, GL121, GL122, GL124 +2 more
VLD-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)GL02.3, GL03.4, GL03.5, GL03.6, GL100, GL122, GL124, GL160

Indexes (3)

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

IndexKeysFlagsConditionUsed in
VLDSET1RECORD-TYPE, CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNT, COMPANY, ACCT-UNIT, SYSTEMPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
VLDSET2CHART-NAME, ACCOUNT, SUB-ACCOUNT, SYSTEMSubsetWhere RECORD-TYPE = "D"AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
VLDSET3COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEMSubsetWhere RECORD-TYPE = "M"AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GlcodesGLCODESRequiredWhen VLD-RECORD-TYPE = "M"VLD-COMPANY → GCD-COMPANY, VLD-SYSTEM → GCD-SYSTEM
SystemcodeSYSTEMCODERequiredVLD-SYSTEM → SYS-SYSTEM

Programs

Updated by (14)

Referenced by (46)