Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ADCFBAL FILE

UPDATED BY

GL120

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ADL-COMPANY          Numeric 4
Company              The company number represents an
                     established company and is entered on
                     all function codes.


ADL-EFFECT-DATE      Numeric 8  (yyyymmdd)
Effective Date

ADL-ACCT-UNIT        Alpha 15
Accounting 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.


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

ADL-SUB-ACCOUNT      Numeric 4
Subaccount           This field along with the accounting
                     unit and subaccount make up the location
                     (account) where amounts and other
                     account information is stored.

ADL-VAR-LEVELS       Alpha 30                                    GL120
Variable Levels      A level that represents the location of
                     an accounting unit in an organization's
                     level structure.


ADL-FISCAL-YEAR      Numeric 4
Fiscal Year          This is the current fiscal year.  This
                     field is updated by Period Closing
                     (GL199).

ADL-ACCT-PERIOD      Numeric 2
Account Period       This is the current accounting period.
                     This field is updated by GL199 (Period
                     Closing).

ADL-CF-PER-AMOUNT    Currency 15.2
Cf Per Amount

ADL-CF-QTR-AMOUNT    Currency 15.2
Cf Qtr Amount

ADL-CF-YER-AMOUNT    Currency 15.2
Cf Yer Amount

ADL-MAINT-TIME       Numeric 6  (hhmmss)
Maintenance Time     The time last changed.

ADL-MAINT-DATE       Numeric 8  (yyyymmdd)
Maintenance Date     The date last changed.

                         ADCFBAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADLSET1   COMPANY                                                GL120
          EFFECT-DATE
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT

ADLSET2   COMPANY
          EFFECT-DATE
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT