Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ADAMOUNTSX FILE

REFERENCED BY

GL122     GL20.2

UPDATED BY

GL120     GL146     GL190     GL197     GL40.1    GL40.2
GL40.3    GL40.7    GL40.8    GL44.1    GL45.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BAD-COMPANY          Numeric 4                                   GL146   GL190
Company              The company number represents an            GL197   GL40.1
                     established company and is entered on       GL40.2  GL40.3
                     all function codes.                         GL40.7  GL40.8
                                                                 GL44.1  GL45.1

BAD-EFFECT-DATE      Numeric 8  (yyyymmdd)                       GL146   GL190
Effective Date                                                   GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

BAD-POST-DATE        Numeric 8  (yyyymmdd)                       GL146   GL190
General Ledger       The date general ledger entries for the     GL197   GL40.1
Posting Date         transaction will be posted to the           GL40.2  GL40.3
                     general ledger.                             GL40.7  GL40.8
                                                                 GL44.1  GL45.1

BAD-ACCT-UNIT        Alpha 15                                    GL146   GL190
Accounting Unit      The accounting unit is a shorthand          GL197   GL40.1
                     notation representing the variable level    GL40.2  GL40.3
                     number. When used in the General Ledger     GL40.7  GL40.8
                     Account Master file, the accounting unit    GL44.1  GL45.1
                     must be defined in the General Ledger
                     Names file as a posting accounting unit.


BAD-ACCOUNT          Numeric 6                                   GL146   GL190
Account              This field along with the accounting        GL197   GL40.1
                     unit and subaccount make up the location    GL40.2  GL40.3
                     (account) where amounts and other           GL40.7  GL40.8
                     account information is stored.              GL44.1  GL45.1

BAD-SUB-ACCOUNT      Numeric 4                                   GL146   GL190
Subaccount           This field along with the accounting        GL197   GL40.1
                     unit and subaccount make up the location    GL40.2  GL40.3
                     (account) where amounts and other           GL40.7  GL40.8
                     account information is stored.              GL44.1  GL45.1

BAD-VAR-LEVELS       Alpha 30                                    GL120   GL146
Variable Levels      A level that represents the location of     GL190   GL197
                     an accounting unit in an organization's     GL40.1  GL40.2
                     level structure.                            GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

BAD-CHART-NAME       Alpha 12                                    GL146   GL190
Chart Name           This is the name you assigned to the        GL197   GL40.1
                     chart of accounts when you defined your     GL40.2  GL40.3
                     company structure in the General Ledger     GL40.7  GL40.8
                     system.                                     GL44.1  GL45.1


BAD-FISCAL-YEAR      Numeric 4                                   GL146   GL190
Fiscal Year          This is the current fiscal year.  This      GL197   GL40.1
                     field is updated by Period Closing          GL40.2  GL40.3
                     (GL199).                                    GL40.7  GL40.8
                                                                 GL44.1  GL45.1

BAD-ACCT-PERIOD      Numeric 2                                   GL146   GL190
Account Period       This is the current accounting period.      GL197   GL40.1
                     This field is updated by GL199 (Period      GL40.2  GL40.3
                     Closing).                                   GL40.7  GL40.8
                                                                 GL44.1  GL45.1

BAD-BASE-AMOUNT      Signed 15.2                                 GL146   GL190
Base Amount          The base amount to be posted to the         GL197   GL40.1
                     General Ledger Account Master file.         GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

                         ADAMOUNTSX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BADSET1   COMPANY                                                GL146   GL190
          EFFECT-DATE                                            GL197   GL40.1
          POST-DATE                                              GL40.2  GL40.3
          ACCT-UNIT                                              GL40.7  GL40.8
          ACCOUNT                                                GL44.1  GL45.1
          SUB-ACCOUNT

BADSET2   COMPANY                                                GL120   GL122
          ACCT-UNIT                                              GL20.2
          ACCOUNT
          SUB-ACCOUNT
          EFFECT-DATE
          POST-DATE

BADSET3   COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          ACCT-PERIOD
          EFFECT-DATE
          POST-DATE