Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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

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

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                                           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