GLACCTREL

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 GL194 GL195 GL265
GL65.1 GL65.4 GL67.1 GL162 GL209 GL62.1
ML165 ML167 ML195 ML65.1 ML67.1


UPDATED BY
GL09.1 GL09.2

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
AC527 CA160
CA60.1 FB165
FB195 FB265
FB65.1 GL165
GL167 GL194
GL195 GL265
GL65.1 GL65.4
GL67.1 GL09.1
GL09.2 GL162
GL209 GL62.1
ML165 ML167
ML195 ML65.1
ML67.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: Thu Jun 09 02:20:30 2016

Home
Contact Us



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