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
|