Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ADCFBAL


                              ADCFBAL FILE

UPDATED BY

GL120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

ADL-EFFECT-DATE        Numeric 8  (yyyymmdd)
Element: Date

ADL-ACCT-UNIT          Alpha 15
Element: Accounting UniThe 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
Element: 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
Element: Subaccount

ADL-VAR-LEVELS         Alpha 30                                  GL120
Element: New Levels

ADL-FISCAL-YEAR        Numeric 4
Element: Last Closed YeThis is the current fiscal year.  This
                       field is updated by Period Closing
                       (GL199).

ADL-ACCT-PERIOD        Numeric 2
Element: Current Period

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

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

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

ADL-MAINT-TIME         Numeric 6  (hhmmss)
Element: Sys Time

ADL-MAINT-DATE         Numeric 8  (yyyymmdd)
Element: Date

                         ADCFBAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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