ADCONSOL

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.
UPDATED BY
AD190 AD191 AD300 AD320 GL110 GLRV.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADO-RECORD-TYPE
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: B = Average Daily Balance C = Cost of Funds
AD190 AD191
ADO-LEVEL-DEPTH
Element: Level Depth
Numeric 1
The variable levels depth number pertaining to this record.
AD190 AD191
ADO-COMPANY
Element: Company
Numeric 4
The Average Daily Balance Company established in AD10. The company must exist in General Ledger.
AD190 AD191
ADO-FISCAL-YEAR
Element: Year
Numeric 4
This is the current fiscal year.
AD190 AD191
ADO-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AD190 AD191
ADO-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AD190 AD191
ADO-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
AD190 AD191
AD320
ADO-CHART-NAME
Element: Chart Name
Alpha 12
This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.
AD190 AD191
ADO-AVG-PER-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The average period amount.
AD190 AD191
ADO-AVG-QTR-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The average quarter amount.
AD190 AD191
ADO-AVG-YER-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The average year amount.
AD190 AD191
ADO-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
AD190 AD191
ADO-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
AD190 AD191


ADCONSOL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADOSET1 FISCAL-YEAR
LEVEL-DEPTH
RECORD-TYPE
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
AD190 AD191
GLRV.1
ADOSET2 RECORD-TYPE
COMPANY
FISCAL-YEAR
LEVEL-DEPTH
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
AD300
ADOSET3 FISCAL-YEAR
LEVEL-DEPTH
RECORD-TYPE
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
GLRV.1
ADOSET4 FISCAL-YEAR
LEVEL-DEPTH
RECORD-TYPE
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
GLRV.1
ADOSET5 COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
RECORD-TYPE
LEVEL-DEPTH
AD320 GL110


ADCONSOL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glchart GLCHART Required
ADO-CHART-NAME->GCH-CHART-NAME
Glsystem GLSYSTEM Required
ADO-COMPANY->GLS-COMPANY


ADCONSOL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:05:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.