Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ADCONSOL


                             ADCONSOL FILE

                       ADB and COF Consolidation

This file contains consolidated account balances for the ADBALANCE file.
Consolidated balances are kept for summary level accounting units.  The
purpose of this file is for reporting summary balances.

REFERENCED BY

GLRV.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ADO-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

ADO-LEVEL-DEPTH        Numeric 1
Element: Level Depth   The variable levels depth number
                       pertaining to this record.

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

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

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

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

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


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


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

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

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

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

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

                         ADCONSOL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ADOSET1   FISCAL-YEAR                                            GLRV.1
          LEVEL-DEPTH
          RECORD-TYPE
          COMPANY
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT

ADOSET2   RECORD-TYPE
          COMPANY
          FISCAL-YEAR
          LEVEL-DEPTH
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT

ADOSET3   FISCAL-YEAR                                            GLRV.1
          LEVEL-DEPTH
          RECORD-TYPE
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS

ADOSET4   FISCAL-YEAR                                            GLRV.1
          LEVEL-DEPTH
          RECORD-TYPE
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          COMPANY

ADOSET5   COMPANY
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          RECORD-TYPE
          LEVEL-DEPTH

                         ADCONSOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glchart        GLCHART      Required

                            ADO-CHART-NAME     -> GCH-CHART-NAME  (GCHSET1)

Glsystem       GLSYSTEM     Required

                            ADO-COMPANY        -> GLS-COMPANY

                         ADCONSOL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glconsol       GLCONSOL

                            ADO-FISCAL-YEAR    -> GCN-FISCAL-YEAR
                            ADO-LEVEL-DEPTH    -> GCN-LEVEL-DEPTH
                            Zeroes             -> GCN-BUDGET-NBR
                            "A"                -> GCN-TRANS-TYPE
                            ADO-COMPANY        -> GCN-COMPANY
                            ADO-VAR-LEVELS     -> GCN-VAR-LEVELS
                            ADO-ACCOUNT        -> GCN-ACCOUNT
                            ADO-SUB-ACCOUNT    -> GCN-SUB-ACCOUNT
                                                  GCN-CURRENCY-CODE

Glmaster       GLMASTER

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

Glnames        GLNAMES

                            ADO-COMPANY        -> GLN-COMPANY
                            ADO-VAR-LEVELS     -> GLN-VAR-LEVELS
                                                  GLN-ACCT-UNIT