GLACCTVLD

GL Account Validation

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

REFERENCED BY
AP125 AP126 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 API1.1 API2.1 IFAC.1 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MAI1.1


UPDATED BY
GL100 GL110 GL122 GL00.9 GL00.1 GL00.2
GL00.3 GL02.3 GL02.1 GL02.2 GL03.4 GL03.5
GL03.6 GL121 GL124 GL160 GL20.4 GL20.2
GL288 GL14.8

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VLD-RECORD-TYPE
Element: Record Type		Alpha 1
This 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
Element: Chart Name		Alpha 12
This 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
Element: Summary Account		Numeric 6
The summary account identifier.
GL02.3 GL03.4
GL03.5 GL03.6
GL100 GL124
GL160
VLD-ACCOUNT
Element: Account		Numeric 6
This 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
Element: Subaccount		Numeric 4
This 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
Element: Company		Numeric 4
The company number as defined in GL10.1 (Company).
GL02.3 GL03.4
GL03.5 GL03.6
GL110 GL122
GL124 GL160
VLD-ACCT-UNIT
Element: Accounting Unit		Alpha 15
The accounting unit is a shorthand notation representing the variable level number.
GL02.3 GL03.4
GL03.5 GL03.6
GL100 GL121
GL122 GL124
GL160 GL20.4
VLD-SYSTEM
Element: System Code		Alpha 2
A 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


GLACCTVLD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VLDSET1 RECORD-TYPE
CHART-NAME
SUMRY-ACCT-ID
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
SYSTEM
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
GL100 GL288
GL00.1 GL00.2
GL00.9 GL03.4
GL03.5 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
VLDSET2 CHART-NAME
ACCOUNT
SUB-ACCOUNT
SYSTEM
Subset
WhereRECORD-TYPE ="D"
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
GL100 GL288
GL00.3 GL00.9
GL02.1 GL02.2
GL02.3 GL03.5
GL160 IFAC.1
MA41.1 MA41.2
MA41.4 MA41.7
VLDSET3 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SYSTEM
Subset
WhereRECORD-TYPE ="M"
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
API1.1 API2.1
GL110 GL122
GL03.6 GL121
GL124 GL14.8
GL20.2 GL20.4
IFAC.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1


GLACCTVLD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:49:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.