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
AD290 | AD98.3 | AD98.1 | AD97.1 | AD97.3 | RW80.1 |
GLRV.1 |
AD190 | AD191 | AD300 | AD320 | GL110 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
ADE-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 |
|
||||
ADE-COMPANY Element: Company | Numeric 4 The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company. |
|
||||
ADE-FISCAL-YEAR Element: Year | Numeric 4 This is the current fiscal year. |
|
||||
ADE-ACCT-UNIT Element: Acct Unit | Alpha 15 The 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 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. |
|
||||
ADE-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. |
|
||||
ADE-VAR-LEVELS Element: Var Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||
ADE-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. |
|
||||
ADE-AVG-PER-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times The average period balance. |
|
||||
ADE-AVG-QTR-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times The average quarter balance. |
|
||||
ADE-AVG-YER-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times The average year balance. |
|
||||
ADE-MAINT-DATE Element: Maint Date | Numeric 8 (yyyymmdd) The date last changed. |
|
||||
ADE-MAINT-TIME Element: Sys Time | Numeric 6 (hhmmss) |
|
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 FISCAL-YEAR COMPANY VAR-LEVELS ACCOUNT SUB-ACCOUNT ACCT-UNIT |
|
| ||||||||||||
ADESET5 |
RECORD-TYPE FISCAL-YEAR COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS ACCT-UNIT |
|
| ||||||||||||
ADESET6 |
RECORD-TYPE FISCAL-YEAR VAR-LEVELS ACCOUNT SUB-ACCOUNT COMPANY ACCT-UNIT |
|
| ||||||||||||
ADESET7 |
COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT FISCAL-YEAR RECORD-TYPE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Glamounts | GLAMOUNTS |
Required
| |||||||||||||||
Glchart | GLCHART |
Required
| |||||||||||||||
Glmaster | GLMASTER |
Required
| |||||||||||||||
Glnames | GLNAMES |
Required
| |||||||||||||||
Glsystem | GLSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.