Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARDISTBAL


                             ARDISTBAL FILE

UPDATED BY

AR197     AR99.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RBL-GL-COMPANY         Numeric 4                                 AR197   AR99.6
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

RBL-ACCT-UNIT          Alpha 15                                  AR197   AR99.6
Element: Acct Unit     The accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


RBL-ACCOUNT            Numeric 6                                 AR197   AR99.6
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

RBL-SUB-ACCT           Numeric 4                                 AR197   AR99.6
Element: Sub Acct      This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

RBL-BAL-DATE           Numeric 8  (yyyymmdd)                     AR197   AR99.6
Element: Date          This field displays the system date
                       when this was created.

RBL-BASE-AMOUNT        Signed 18.2                               AR197   AR99.6
Element: Intl Amt

RBL-USER               Alpha 10  (Lower Case)                    AR197   AR99.6
Element: User

RBL-DATE               Numeric 8  (yyyymmdd)                     AR197   AR99.6
Element: Date          This field displays the system date
                       when this was created.

RBL-TIME               Numeric 8                                 AR197   AR99.6
Element: Time          This field is updated automatically to
                       indicate the time that the GL entry was
                       created. It is system-maintained.

RBL-DISTRIB-UPDTED     Alpha 1                                   AR197   AR99.6
Element: Flag          This flag indicates the source of its
                       creation and is useful for delete logic.
                       N = AR99 created, Y = AR197 updated.

                         ARDISTBAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RBLSET1   GL-COMPANY                                             AR197   AR99.6
          ACCT-UNIT
          ACCOUNT
          SUB-ACCT
          BAL-DATE

RBLSET2   GL-COMPANY                                             AR197
          ACCT-UNIT
          ACCOUNT
          SUB-ACCT
          BAL-DATE*

RBLSET3   GL-COMPANY                                             AR197   AR99.6
          BAL-DATE
          ACCT-UNIT
          ACCOUNT
          SUB-ACCT