Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLACCTVLD


                             GLACCTVLD FILE

                         GL Account Validation

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


REFERENCED BY

AC191     BR44.1    GL288     IC222     IFAC.1    GL14.8

UPDATED BY

GL100     GL110     GL122     GL00.9    GL00.2    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
Element: 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
Element: 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
Element: Summary AccounThe summary account identifier.           GL03.5  GL03.6
                                                                 GL100   GL124
                                                                 GL160

VLD-ACCOUNT            Numeric 6                                 GL02.3  GL03.4
Element: 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
Element: 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
Element: 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
Element: Accounting UniThe 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
Element: 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   BR44.1
          CHART-NAME                                             GL100   GL288
          SUMRY-ACCT-ID                                          IC222   GL00.1
          ACCOUNT                                                GL00.2  GL00.9
          SUB-ACCOUNT                                            GL03.4  GL03.5
          COMPANY                                                IFAC.1
          ACCT-UNIT
          SYSTEM

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

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