Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ADBALANCE


                             ADBALANCE FILE

                         ADB and COF by Period

The Average Daily Balance file contains the average daily balances for the
period, quarter and year by Record Type B (Avg Daily Balance) or C (Cost of
Funds) for the company, fiscal year, accounting unit and account.  This file
is updated by AD190 and AD191.  This file will contain only one record for
each calendar period and is used for Report Writer reporting.  The ADAVGBAL
file and ADCFBAL will contain records by date.

REFERENCED BY

RW80.1    GLRV.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADE-RECORD-TYPE        Alpha 1
Element: Record Type   This field identifies the type of record
                       defined.
                       Valid values are:
                       B = Average Daily Balance
                       C = Cost of Funds

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

ADE-FISCAL-YEAR        Numeric 4
Element: Last Closed YeThis is the current fiscal year.

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

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

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

ADE-VAR-LEVELS         Alpha 30
Element: Variable LevelA level that represents the location of
                       an accounting unit in an organization's
                       level structure.


ADE-CHART-NAME         Alpha 12
Element: Chart Name    This is the name you assigned to the
                       chart of accounts when you defined your
                       company structure in the General Ledger
                       system.


ADE-AVG-PER-AMOUNT     Signed 18.2 Occurs 13 Times
Element: Intl Amt      The average period balance.

ADE-AVG-QTR-AMOUNT     Signed 18.2 Occurs 13 Times
Element: Intl Amt      The average quarter balance.

ADE-AVG-YER-AMOUNT     Signed 18.2 Occurs 13 Times
Element: Intl Amt      The average year balance.

ADE-MAINT-DATE         Numeric 8  (yyyymmdd)
Element: Maintenance DaThe date last changed.

ADE-MAINT-TIME         Numeric 6  (hhmmss)
Element: Sys Time      The time last changed.

                         ADBALANCE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADESET1   COMPANY
          FISCAL-YEAR
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          RECORD-TYPE

ADESET2   RECORD-TYPE
          COMPANY
          FISCAL-YEAR
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT

ADESET3   RECORD-TYPE
          FISCAL-YEAR
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT

ADESET4   RECORD-TYPE   KeyChange                                RW80.1  GLRV.1
          FISCAL-YEAR
          COMPANY
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT

ADESET5   RECORD-TYPE   KeyChange                                GLRV.1
          FISCAL-YEAR
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT

ADESET6   RECORD-TYPE   KeyChange                                GLRV.1
          FISCAL-YEAR
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          COMPANY
          ACCT-UNIT

ADESET7   COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          RECORD-TYPE

                         ADBALANCE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glamounts      GLAMOUNTS    Required

                            ADE-COMPANY        -> GAM-COMPANY  (GAMSET1)
                            ADE-FISCAL-YEAR    -> GAM-FISCAL-YEAR
                            ADE-ACCT-UNIT      -> GAM-ACCT-UNIT
                            ADE-ACCOUNT        -> GAM-ACCOUNT
                            ADE-SUB-ACCOUNT    -> GAM-SUB-ACCOUNT

Glchart        GLCHART      Required

                            ADE-CHART-NAME     -> GCH-CHART-NAME

Glmaster       GLMASTER     Required

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

Glnames        GLNAMES      Required

                            ADE-COMPANY        -> GLN-COMPANY
                            ADE-ACCT-UNIT      -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Required

                            ADE-COMPANY        -> GLS-COMPANY