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 |
AD190 | AD191 | AD300 | AD320 | GL110 |
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 |
|
||||
ADO-LEVEL-DEPTH Element: Level Depth | Numeric 1 The variable levels depth number pertaining to this record. |
|
||||
ADO-COMPANY Element: Company | Numeric 4 The Average Daily Balance Company established in AD10. The company must exist in General Ledger. |
|
||||
ADO-FISCAL-YEAR Element: Year | Numeric 4 This is the current fiscal year. |
|
||||
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. |
|
||||
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. |
|
||||
ADO-VAR-LEVELS Element: Var Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||
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. |
|
||||
ADO-AVG-PER-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times The average period amount. |
|
||||
ADO-AVG-QTR-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times The average quarter amount. |
|
||||
ADO-AVG-YER-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times The average year amount. |
|
||||
ADO-MAINT-DATE Element: Maint Date | Numeric 8 (yyyymmdd) The date last changed. |
|
||||
ADO-MAINT-TIME Element: Sys Time | Numeric 6 (hhmmss) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ADOSET1 |
FISCAL-YEAR 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 LEVEL-DEPTH RECORD-TYPE COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS |
|
| ||||||||||
ADOSET4 |
FISCAL-YEAR LEVEL-DEPTH RECORD-TYPE VAR-LEVELS ACCOUNT SUB-ACCOUNT COMPANY |
|
| ||||||||||
ADOSET5 |
COMPANY VAR-LEVELS ACCOUNT SUB-ACCOUNT FISCAL-YEAR RECORD-TYPE LEVEL-DEPTH |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Glchart | GLCHART |
Required
| |||
Glsystem | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Glconsol | GLCONSOL |
| |||||||||||||||||||||||||||
Glmaster | GLMASTER |
| |||||||||||||||||||||||||||
Glnames | GLNAMES |
|
All trademarks and registered trademarks are the property of their
respective owners.