Lawson Insight Technical Documentation

                             GLACCTVLD FILE

                         GL Account Validation

This file is used to validate accounting unit, account, and subsystem
information.


REFERENCED BY

AC191     GL288     IC222     IFAC.1    GL14.8

UPDATED BY

GL100     GL110     GL122     GL00.9    GL02.3    GL03.4
GL03.5    GL03.6    GL121     GL124     GL160     GL20.4
GL20.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

VLD-RECORD-TYPE      Alpha 1                                     GL02.3  GL03.4
Record Type          This field identifies the type of           GL03.5  GL03.6
                     record defined.                             GL100   GL122
                                                                 GL124   GL160
                     Valid values are:
                     S = Summary
                     D = Detail
                     M = Master Acct

VLD-CHART-NAME       Alpha 12                                    GL00.9  GL02.3
Chart Name           This is the name you assigned to the        GL03.4  GL03.5
                     chart of accounts when you defined your     GL03.6  GL100
                     company structure in the General Ledger     GL124   GL160
                     system.


VLD-SUMRY-ACCT-ID    Numeric 6                                   GL02.3  GL03.4
Summary Account      The summary account identifier.             GL03.5  GL03.6
                                                                 GL100   GL124
                                                                 GL160

VLD-ACCOUNT          Numeric 6                                   GL02.3  GL03.4
Account              This field along with the accounting        GL03.5  GL03.6
                     unit and subaccount make up the location    GL100   GL122
                     (account) where amounts and other           GL124   GL160
                     account information is stored.

VLD-SUB-ACCOUNT      Numeric 4                                   GL02.3  GL03.4
Subaccount           This field along with the accounting        GL03.5  GL03.6
                     unit and subaccount make up the location    GL100   GL122
                     (account) where amounts and other           GL124   GL160
                     account information are stored.


VLD-COMPANY          Numeric 4                                   GL02.3  GL03.4
Company              The company number as defined in GL10.1     GL03.5  GL03.6
                     (Company).                                  GL110   GL122
                                                                 GL124   GL160

VLD-ACCT-UNIT        Alpha 15                                    GL02.3  GL03.4
Accounting Unit      The accounting unit is a shorthand          GL03.5  GL03.6
                     notation representing the variable level    GL100   GL121
                     number.                                     GL122   GL124
                                                                 GL160   GL20.4

VLD-SYSTEM           Alpha 2                                     GL02.3  GL03.4
System Code          A two-character code representing an        GL03.5  GL03.6
                     application used within the Lawson          GL100   GL122
                     system. (i.e.: GL = General Ledger, AP =    GL124   GL160
                     Accounts Payable, etc.)

                         GLACCTVLD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VLDSET1   RECORD-TYPE                                            AC191   GL100
          CHART-NAME                                             GL288   IC222
          SUMRY-ACCT-ID                                          GL00.1  GL00.9
          ACCOUNT                                                GL03.4  GL03.5
          SUB-ACCOUNT                                            IFAC.1
          COMPANY
          ACCT-UNIT
          SYSTEM

VLDSET2   CHART-NAME    Subset                                   AC191   GL100
          ACCOUNT       Where RECORD-TYPE = "D"                  GL288   IC222
          SUB-ACCOUNT                                            GL00.3  GL00.9
          SYSTEM                                                 GL02.1  GL02.2
                                                                 GL02.3  GL03.5
                                                                 GL160   IFAC.1

VLDSET3   COMPANY       Subset                                   AC191   GL110
          ACCT-UNIT     Where RECORD-TYPE = "M"                  GL122   IC222
          ACCOUNT                                                GL03.6  GL121
          SUB-ACCOUNT                                            GL124   GL14.8
          SYSTEM                                                 GL20.2  GL20.4
                                                                 IFAC.1

                         GLACCTVLD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcodes        GLCODES      Required
                            When VLD-RECORD-TYPE = "M"

                            VLD-COMPANY    -> GCD-COMPANY
                            VLD-SYSTEM     -> GCD-SYSTEM

Systemcode     SYSTEMCODE   Required

                            VLD-SYSTEM     -> SYS-SYSTEM