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 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 API1.1 API2.1 GL288 IC222
IFAC.1 MA41.2 MA41.7 MA43.2 MA61.1 MAI1.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 AP125
CHART-NAME AP126 AP20.1
SUMRY-ACCT-ID AP20.2 AP20.3
ACCOUNT AP20.4 AP20.5
SUB-ACCOUNT AP20.7 AP23.1
COMPANY AP25.1 AP25.2
ACCT-UNIT AP26.1 AP27.1
SYSTEM API1.1 API2.1
GL100 GL288
IC222 GL00.1
GL00.2 GL00.9
GL03.4 GL03.5
IFAC.1 MA41.2
MA41.7 MA43.2
MA61.1 MAI1.1
VLDSET2 CHART-NAME Subset AC191 AP125
ACCOUNT Where RECORD-TYPE = "D" AP126 AP20.1
SUB-ACCOUNT AP20.2 AP20.3
SYSTEM AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
GL100 GL288
IC222 GL00.3
GL00.9 GL02.1
GL02.2 GL02.3
GL03.5 GL160
IFAC.1 MA41.2
MA41.7 MA43.2
...
VLDSET3 COMPANY Subset AC191 AP125
ACCT-UNIT Where RECORD-TYPE = "M" AP126 AP20.1
ACCOUNT AP20.2 AP20.3
SUB-ACCOUNT AP20.4 AP20.5
SYSTEM AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
GL110 GL122
IC222 GL03.6
GL121 GL124
GL14.8 GL20.2
GL20.4 IFAC.1
MA41.2 MA41.7
MA43.2 MA61.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
|