Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ADAMOUNTSX


                            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
Element: 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
Element: Date                                                    GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

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

BAD-ACCT-UNIT          Alpha 15                                  GL146   GL190
Element: Accounting UniThe 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
Element: 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
Element: Subaccount                                              GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

BAD-VAR-LEVELS         Alpha 30                                  GL120   GL146
Element: New Levels                                              GL190   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

BAD-CHART-NAME         Alpha 12                                  GL146   GL190
Element: Name User     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
Element: Last Closed YeThis 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
Element: Current Period                                          GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

BAD-BASE-AMOUNT        Signed 15.2                               GL146   GL190
Element: Adj Amt                                                 GL197   GL40.1
                                                                 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       KeyChange
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          ACCT-PERIOD
          EFFECT-DATE
          POST-DATE