Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ADAVGBAL


                             ADAVGBAL FILE

                     Average Daily Balance by Date

the Average Daily Balance file contains the period, quarter and year balances
by company and effective date for each accounting unit and account.  This file
is updated by AD190 if the ADCOMPANY.UPDATE-DAILY=Yes

UPDATED BY

GL120     GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADV-COMPANY            Numeric 4
Element: Company       The Average Daily Balance Company
                       established in AD10. The company must
                       exist  as a  General Ledger Company.

ADV-EFFECT-DATE        Numeric 8  (yyyymmdd)
Element: Effect Date   This is the effective date that the
                       AD190 was run for.  The amounts for a
                       particular effective date represent the
                       average daily balance for that date.

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

ADV-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.

ADV-SUB-ACCOUNT        Numeric 4
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.

ADV-VAR-LEVELS         Alpha 30                                  GL120
Element: Var Levels    A level that represents the location of
                       an accounting unit in an organization's
                       level structure.


ADV-FISCAL-YEAR        Numeric 4                                 GL500
Element: Year          This is the current fiscal year.

ADV-ACCT-PERIOD        Numeric 2                                 GL500
Element: Acct Period   This is the current accounting period.

ADV-AVG-PER-AMOUNT     Signed 18.2
Element: Intl Amt      This is the average period amount.

ADV-AVG-QTR-AMOUNT     Signed 18.2
Element: Intl Amt      The average quarter amount.

ADV-AVG-YER-AMOUNT     Signed 18.2
Element: Intl Amt      The average year amount.

ADV-MAINT-DATE         Numeric 8  (yyyymmdd)                     GL500
Element: Maint Date    The date last changed.

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

                         ADAVGBAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADVSET1   COMPANY                                                GL120   GL500
          EFFECT-DATE
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT

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

                         ADAVGBAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Adcfbal        ADCFBAL      Required

                            ADV-COMPANY        -> ADL-COMPANY
                            ADV-EFFECT-DATE    -> ADL-EFFECT-DATE
                            ADV-ACCT-UNIT      -> ADL-ACCT-UNIT
                            ADV-ACCOUNT        -> ADL-ACCOUNT
                            ADV-SUB-ACCOUNT    -> ADL-SUB-ACCOUNT

Glamounts      GLAMOUNTS    Required

                            ADV-COMPANY        -> GAM-COMPANY
                            ADV-FISCAL-YEAR    -> GAM-FISCAL-YEAR
                            ADV-ACCT-UNIT      -> GAM-ACCT-UNIT
                            ADV-ACCOUNT        -> GAM-ACCOUNT
                            ADV-SUB-ACCOUNT    -> GAM-SUB-ACCOUNT

Glmaster       GLMASTER     Required

                            ADV-COMPANY        -> GLM-COMPANY
                            ADV-ACCOUNT        -> GLM-ACCOUNT
                            ADV-SUB-ACCOUNT    -> GLM-SUB-ACCOUNT
                            ADV-VAR-LEVELS     -> GLM-VAR-LEVELS
                            ADV-ACCT-UNIT      -> GLM-ACCT-UNIT

Glnames        GLNAMES      Required

                            ADV-COMPANY        -> GLN-COMPANY
                            ADV-ACCT-UNIT      -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Required

                            ADV-COMPANY        -> GLS-COMPANY