Lawson Insight Technical Documentation |
|
GLACCTREL
GLACCTREL FILE
GL Account Relationships
This file contains the information needed to create the Lawson accounts when
converting from non-Lawson systems.
REFERENCED BY
AC527 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 account 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 AC527 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
|