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     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
Old Account Nbr      This 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
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
Subaccount           This field along with the accounting
                     unit and subaccount make up the location
                     (account) where amounts and other
                     account information is stored.

GAR-OLD-ACCT-SHORT   Derived
Old Acct Short       The short description.

                         GLACCTREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GARSET1   OLD-ACCT-NBR                                           FB165   FB195
                                                                 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