GLACCTVLD

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 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 BR44.1
CB222 GL288 DR100 IC141 IC142 IC222
IC83.1 IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA44.1 MA44.2 MA61.1 MAI1.1
RQ10.1 RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ500
RQIB.1 RQIF.1 RQIJ.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
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
...
AC191 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 BR44.1
CB222 GL100
GL288 DR100
IC141 IC142
IC222 IC83.1
GL00.1 GL00.2
GL00.9 GL03.4
VLDSET2 CHART-NAME
ACCOUNT
SUB-ACCOUNT
SYSTEM
Subset
WhereRECORD-TYPE ="D"
...
AC191 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 BR44.1
CB222 GL100
GL288 DR100
IC141 IC142
IC222 IC83.1
GL00.3 GL00.9
GL02.1 GL02.2
VLDSET3 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SYSTEM
Subset
WhereRECORD-TYPE ="M"
...
AC191 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 BR44.1
CB222 GL110
GL122 DR100
IC141 IC142
IC222 IC83.1
GL03.6 GL121
GL124 GL14.8


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: Thu Jun 09 02:20:30 2016

Home
Contact Us



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