Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ADAMOUNTSX


                            ADAMOUNTSX FILE

                        Daily GL Amounts for ADB

The Average Daily Amount file contains the the base amount balance for the
ADB Company by Effective date for the accounting unit and account.  This file
is updated during the General Ledger Posting process.

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    GL500


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BAD-COMPANY            Numeric 4                                 GL146   GL190
Element: Company       The Average Daily Balance Company         GL197   GL40.1
                       established in AD10.  The company must    GL40.2  GL40.3
                       exist as a  General Ledger Company.       GL40.7  GL40.8
                                                                 GL44.1  GL45.1

BAD-EFFECT-DATE        Numeric 8  (yyyymmdd)                     GL146   GL190
Element: Effect Date   The Effective Date is the effective date  GL197   GL40.1
                       of the GL transaction.  This file stores  GL40.2  GL40.3
                       GL transations summarized by their        GL40.7  GL40.8
                       effective date for the ADB Company,       GL44.1  GL45.1
                       accounting unit and account.

BAD-POST-DATE          Numeric 8  (yyyymmdd)                     GL146   GL190
Element: Post Date     The date general ledger entries for the   GL197   GL40.1
                       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
Element: Acct 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
                       Master file, the accounting unit must     GL44.1  GL45.1
                       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: Sub Acct      This field contains the subaccount from   GL197   GL40.1
                       your general ledger chart of accounts     GL40.2  GL40.3
                       that was charged with the amount carried  GL40.7  GL40.8
                       on this record.                           GL44.1  GL45.1

BAD-VAR-LEVELS         Alpha 30                                  GL120   GL146
Element: Var 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
Element: 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
Element: Year          This is the current fiscal year.          GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

BAD-ACCT-PERIOD        Numeric 2                                 GL146   GL190
Element: Acct Period   This is the current accounting period.    GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

BAD-BASE-AMOUNT        Signed 18.2                               GL146   GL190
Element: Intl Amt      The company base amount.                  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                                                GL120   GL146
          EFFECT-DATE                                            GL190   GL197
          POST-DATE                                              GL40.1  GL40.2
          ACCT-UNIT                                              GL40.3  GL40.7
          ACCOUNT                                                GL40.8  GL44.1
          SUB-ACCOUNT                                            GL45.1  GL500

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

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