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     IF720     IFAC.1    GL14.8

UPDATED BY

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.                             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  GL124
                     company structure in the General Ledger     GL160
                     system.


VLD-SUMRY-ACCT-ID    Numeric 6                                   GL02.3  GL03.4
Summary Account      The summary account identifier.             GL03.5  GL03.6
                                                                 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    GL122   GL124
                     (account) where amounts and other           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    GL122   GL124
                     (account) where amounts and other           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).                                  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    GL121   GL122
                     number.                                     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          GL122   GL124
                     system. (i.e.: GL = General Ledger, AP =    GL160
                     Accounts Payable, etc.)

                         GLACCTVLD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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

VLDSET3   COMPANY       Subset                                   AC191   GL122
          ACCT-UNIT     Where RECORD-TYPE = "M"                  IC222   GL03.6
          ACCOUNT                                                GL121   GL124
          SUB-ACCOUNT                                            GL14.8  GL20.2
          SYSTEM                                                 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