Cost of Funds by Date
The Average Daily Balance Cost of Funds file contains the cost of funds balances for the period, quarter and year by company and effective date for each accounting unit and account. This file is updated by AD191 if the ADCOMPANY.UPDATE-DAILY = Yes
REFERENCED BY
| AD290 | AD96.1 | AD98.1 | AD97.1 |
| AD191 | AD300 | GL120 | GL500 | GL110 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
|---|---|---|---|---|
| ADL-COMPANY Element: Company | Numeric 4 The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company. |
|
||
| ADL-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) This is the effective date that the AD191 was run for. The amounts for a particular effective date represent the cost of funds for that date. |
|
||
| ADL-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. |
|
||
| ADL-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. |
|
||
| ADL-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. |
|
||
| ADL-VAR-LEVELS Element: Var Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||
| ADL-FISCAL-YEAR Element: Year | Numeric 4 This is the current fiscal year. |
|
||
| ADL-ACCT-PERIOD Element: Acct Period | Numeric 2 This is the current accounting period. |
|
||
| ADL-CF-PER-AMOUNT Element: Intl Amt | Signed 18.2 The cost of funds period amount. |
|
||
| ADL-CF-QTR-AMOUNT Element: Intl Amt | Signed 18.2 The cost of funds quarter amount. |
|
||
| ADL-CF-YER-AMOUNT Element: Intl Amt | Signed 18.2 The cost of funds year amount. |
|
||
| ADL-MAINT-TIME Element: Sys Time | Numeric 6 (hhmmss) |
|
||
| ADL-MAINT-DATE Element: Maint Date | Numeric 8 (yyyymmdd) The date last changed. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ADLSET1 |
COMPANY EFFECT-DATE ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||
| ADLSET2 |
COMPANY EFFECT-DATE ACCOUNT SUB-ACCOUNT ACCT-UNIT |
|
| ||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Adavgbal | ADAVGBAL |
Required
| |||||||||||||||
| Glamounts | GLAMOUNTS |
Required
| |||||||||||||||
| Glmaster | GLMASTER |
Required
| |||||||||||||||
| Glnames | GLNAMES |
Required
| |||||||||||||||
| Glsystem | GLSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.