Lawson Insight Technical Documentation

                             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