GLACCTREL

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 GL265 GL65.1 GL67.1
GL162 GL62.1


UPDATED BY
GL09.1 GL09.2 GL209

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAR-OLD-ACCT-NBR
Element: Old Account Nbr		Alpha 25
This is the old account structure to be associated with the new account/subaccount within the Lawson system.
GL09.1 GL09.2
GAR-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.
GL09.1 GL09.2
GAR-SUB-ACCOUNT
Element: Subaccount		Numeric 4
This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.
GL09.1 GL09.2
GAR-OLD-ACCT-SHORT
Element: Old Acct Short		Derived
The 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 GL265
GL65.1 GL67.1
GL09.1 GL09.2
GL162 GL209
GL62.1


GLACCTREL FILE RELATIONS


ONE TO MANY RELATIONS

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

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

Home
Contact Us



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