GLACCTVLD FILE
GL Account Validation
This file is used to validate accounting unit, account, and subsystem
information.
REFERENCED BY
AC191 FB121 FB165 FB20.1 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB230 FB231 FB30.1
FB31.1 FB65.1 GL170 GL230 GL270 GL288
IC222 IFAC.1 RQ10.1
UPDATED BY
GL00.9 GL03.4 GL03.5 GL03.6 GL121 GL20.4
GL20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VLD-RECORD-TYPE Alpha 1 GL03.4 GL03.5
Record Type This field identifies the type of GL03.6
record defined.
Valid values are:
S=Summary
D=Detail
S = Summary Acct
D = Detail Acct
M = Master Acct
VLD-CHART-NAME Alpha 12 GL00.9 GL03.4
Chart Name This is the name you assigned to the GL03.5 GL03.6
chart of accounts when you defined your
company structure in the General Ledger
system.
VLD-SUMRY-ACCT-ID Numeric 6 GL03.4 GL03.5
Summary Account The summary account identifier. GL03.6
VLD-ACCOUNT Numeric 6 GL03.4 GL03.5
Account This field along with the accounting GL03.6
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
VLD-SUB-ACCOUNT Numeric 4 GL03.4 GL03.5
Subaccount This field along with the accounting GL03.6
unit and subaccount make up the location
(account) where amounts and other
account information are stored.
VLD-COMPANY Numeric 4 GL03.4 GL03.5
Company The company number as defined in GL10.1 GL03.6
(Company).
VLD-ACCT-UNIT Alpha 15 GL03.4 GL03.5
Accounting Unit The accounting unit is a shorthand GL03.6 GL121
notation representing the variable level GL20.4
number.
VLD-SYSTEM Alpha 2 GL03.4 GL03.5
System Code A two-character code representing an GL03.6
application used within the Lawson
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
GLACCTVLD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VLDSET1 RECORD-TYPE AC191 FB121
CHART-NAME FB165 FB20.1
SUMRY-ACCT-ID FB20.3 FB20.4
ACCOUNT FB20.6 FB20.7
SUB-ACCOUNT FB21.1 FB230
COMPANY FB231 FB30.1
ACCT-UNIT FB31.1 FB65.1
SYSTEM GL170 GL230
GL270 GL288
IC222 GL00.1
GL00.9 GL03.4
GL03.5 IFAC.1
RQ10.1
VLDSET2 CHART-NAME Subset AC191 FB121
ACCOUNT Where RECORD-TYPE = "D" FB165 FB20.1
SUB-ACCOUNT FB20.3 FB20.4
SYSTEM FB20.6 FB20.7
FB21.1 FB230
FB231 FB30.1
FB31.1 FB65.1
GL170 GL230
GL270 GL288
IC222 GL00.3
GL00.9 GL03.5
IFAC.1 RQ10.1
VLDSET3 COMPANY Subset AC191 FB121
ACCT-UNIT Where RECORD-TYPE = "M" FB165 FB20.1
ACCOUNT FB20.3 FB20.4
SUB-ACCOUNT FB20.6 FB20.7
SYSTEM FB21.1 FB230
FB231 FB30.1
FB31.1 FB65.1
GL170 GL230
GL270 IC222
GL03.6 GL121
GL20.2 GL20.4
IFAC.1 RQ10.1
GLACCTVLD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glcodes GLCODES Required
When VLD-RECORD-TYPE = "M"
VLD-COMPANY -> GCD-COMPANY
VLD-SYSTEM -> GCD-SYSTEM
Systemcode SYSTEMCODE Required
VLD-SYSTEM -> SYS-SYSTEM
|