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     AP125     AP126     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    API1.1    API2.1    BR44.1
GL288     IFAC.1    MA41.1    MA41.2    MA41.4    MA41.7
MA43.2    MA61.1    MAI1.1    RQ10.1    RQ10.3    RQ11.1
RQ13.2    RQ35.1    RQ500     RQIB.1    RQIF.1    RQIJ.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   AP125
          CHART-NAME                                             AP126   AP20.1
          SUMRY-ACCT-ID                                          AP20.2  AP20.3
          ACCOUNT                                                AP20.4  AP20.5
          SUB-ACCOUNT                                            AP20.7  AP21.1
          COMPANY                                                AP23.1  AP25.1
          ACCT-UNIT                                              AP25.2  AP26.1
          SYSTEM                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 GL100   GL288
                                                                 GL00.1  GL00.2
                                                                 GL00.9  GL03.4
                                                                 GL03.5  IFAC.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 ...

VLDSET2   CHART-NAME    Subset                                   AC191   AP125
          ACCOUNT       Where RECORD-TYPE = "D"                  AP126   AP20.1
          SUB-ACCOUNT                                            AP20.2  AP20.3
          SYSTEM                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 GL100   GL288
                                                                 GL00.3  GL00.9
                                                                 GL02.1  GL02.2
                                                                 GL02.3  GL03.5
                                                                 GL160   IFAC.1
                                                                 MA41.1  MA41.2
                                                                 ...

VLDSET3   COMPANY       Subset                                   AC191   AP125
          ACCT-UNIT     Where RECORD-TYPE = "M"                  AP126   AP20.1
          ACCOUNT                                                AP20.2  AP20.3
          SUB-ACCOUNT                                            AP20.4  AP20.5
          SYSTEM                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR44.1
                                                                 GL110   GL122
                                                                 GL03.6  GL121
                                                                 GL124   GL14.8
                                                                 GL20.2  GL20.4
                                                                 IFAC.1  MA41.1
                                                                 MA41.2  MA41.4
                                                                 ...

                         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