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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
VLDSET1
  1. RECORD-TYPE
  2. CHART-NAME
  3. SUMRY-ACCT-ID
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. COMPANY
  7. ACCT-UNIT
  8. SYSTEM
PrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
VLDSET2
  1. CHART-NAME
  2. ACCOUNT
  3. SUB-ACCOUNT
  4. SYSTEM
SubsetWhere RECORD-TYPE = "D"AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
VLDSET3
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. SYSTEM
SubsetWhere RECORD-TYPE = "M"AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLCODESSYSTEMCODEGLACCTVLD

One to one (2) — lookups and parents

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

Programs

Updated by (14)

Referenced by (46)