Lawson Insight Technical Documentation |
|
GLACCTVLD
GLACCTVLD FILE
GL Account Validation
This file is used to validate accounting unit, account, and subsystem
information.
REFERENCED BY
AC191 BR44.1 GL288 IC222 IFAC.1 GL14.8
UPDATED BY
GL100 GL110 GL122 GL00.9 GL00.2 GL02.3
GL03.4 GL03.5 GL03.6 GL121 GL124 GL160
GL20.4 GL20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VLD-RECORD-TYPE Alpha 1 GL02.3 GL03.4
Element: Record Type This field identifies the type of GL03.5 GL03.6
record defined. GL100 GL122
GL124 GL160
Valid values are:
S = Summary
D = Detail
M = Master Acct
VLD-CHART-NAME Alpha 12 GL00.9 GL02.3
Element: Chart Name This is the name you assigned to the GL03.4 GL03.5
chart of accounts when you defined your GL03.6 GL100
company structure in the General Ledger GL124 GL160
system.
VLD-SUMRY-ACCT-ID Numeric 6 GL02.3 GL03.4
Element: Summary AccounThe summary account identifier. GL03.5 GL03.6
GL100 GL124
GL160
VLD-ACCOUNT Numeric 6 GL02.3 GL03.4
Element: Account This field along with the accounting GL03.5 GL03.6
unit and subaccount make up the location GL100 GL122
(account) where amounts and other GL124 GL160
account information is stored.
VLD-SUB-ACCOUNT Numeric 4 GL02.3 GL03.4
Element: Subaccount This field along with the accounting GL03.5 GL03.6
unit and subaccount make up the location GL100 GL122
(account) where amounts and other GL124 GL160
account information are stored.
VLD-COMPANY Numeric 4 GL02.3 GL03.4
Element: Company The company number as defined in GL10.1 GL03.5 GL03.6
(Company). GL110 GL122
GL124 GL160
VLD-ACCT-UNIT Alpha 15 GL02.3 GL03.4
Element: Accounting UniThe accounting unit is a shorthand GL03.5 GL03.6
notation representing the variable level GL100 GL121
number. GL122 GL124
GL160 GL20.4
VLD-SYSTEM Alpha 2 GL02.3 GL03.4
Element: System Code A two-character code representing an GL03.5 GL03.6
application used within the Lawson GL100 GL122
system. (i.e.: GL = General Ledger, AP = GL124 GL160
Accounts Payable, etc.)
GLACCTVLD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VLDSET1 RECORD-TYPE AC191 BR44.1
CHART-NAME GL100 GL288
SUMRY-ACCT-ID IC222 GL00.1
ACCOUNT GL00.2 GL00.9
SUB-ACCOUNT GL03.4 GL03.5
COMPANY IFAC.1
ACCT-UNIT
SYSTEM
VLDSET2 CHART-NAME Subset AC191 BR44.1
ACCOUNT Where RECORD-TYPE = "D" GL100 GL288
SUB-ACCOUNT IC222 GL00.3
SYSTEM GL00.9 GL02.1
GL02.2 GL02.3
GL03.5 GL160
IFAC.1
VLDSET3 COMPANY Subset AC191 BR44.1
ACCT-UNIT Where RECORD-TYPE = "M" GL110 GL122
ACCOUNT IC222 GL03.6
SUB-ACCOUNT GL121 GL124
SYSTEM GL14.8 GL20.2
GL20.4 IFAC.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
|