GLACCTREL FILE
GL Account Relationships
This file contains the information needed to create the Lawson accounts when
converting from non-Lawson systems.
REFERENCED BY
CA160 CA60.1 FB165 FB195 FB265 FB65.1
GL165 GL167 GL195 GL65.1 GL67.1 GL162
GL209 GL62.1
UPDATED BY
GL09.1 GL09.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAR-OLD-ACCT-NBR Alpha 25 GL09.1 GL09.2
Element: Old Account NbThis is the old account structure to be
associated with the new
account/subaccount within the Lawson
system.
GAR-ACCOUNT Numeric 6 GL09.1 GL09.2
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
GAR-SUB-ACCOUNT Numeric 4 GL09.1 GL09.2
Element: Subaccount This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
GAR-OLD-ACCT-SHORT Derived
Element: Old Acct ShortThe short description.
GLACCTREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GARSET1 OLD-ACCT-NBR CA160 CA60.1
FB165 FB195
FB265 FB65.1
GL165 GL167
GL195 GL65.1
GL67.1 GL09.1
GL09.2 GL162
GL209 GL62.1
GLACCTREL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glchartdtl GLCHARTDTL
GAR-ACCOUNT -> GDT-ACCOUNT
GAR-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
GDT-CHART-NAME
GDT-SUMRY-ACCT-ID
Glmaster GLMASTER
GAR-ACCOUNT -> GLM-ACCOUNT
GAR-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
GLM-VAR-LEVELS
GLM-COMPANY
GLM-ACCT-UNIT
|