ADCFBAL

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


UPDATED BY
AD191 AD300 GL110 GL120 GL500

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.
AD191
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.
AD191
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.
AD191
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.
AD191
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.
AD191
ADL-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
AD191 GL120
ADL-FISCAL-YEAR
Element: Year
Numeric 4
This is the current fiscal year.
AD191 GL500
ADL-ACCT-PERIOD
Element: Acct Period
Numeric 2
This is the current accounting period.
AD191 GL500
ADL-CF-PER-AMOUNT
Element: Intl Amt
Signed 18.2
The cost of funds period amount.
AD191
ADL-CF-QTR-AMOUNT
Element: Intl Amt
Signed 18.2
The cost of funds quarter amount.
AD191
ADL-CF-YER-AMOUNT
Element: Intl Amt
Signed 18.2
The cost of funds year amount.
AD191
ADL-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
GL500
ADL-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
GL500


ADCFBAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADLSET1 COMPANY
EFFECT-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
AD191 AD290
AD300 AD96.1
AD98.1 GL110
GL120 GL500
ADLSET2 COMPANY
EFFECT-DATE
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
AD97.1 GL120


ADCFBAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Adavgbal ADAVGBAL Required
ADL-COMPANY->ADV-COMPANY
ADL-EFFECT-DATE->ADV-EFFECT-DATE
ADL-ACCT-UNIT->ADV-ACCT-UNIT
ADL-ACCOUNT->ADV-ACCOUNT
ADL-SUB-ACCOUNT->ADV-SUB-ACCOUNT
Glamounts GLAMOUNTS Required
ADL-COMPANY->GAM-COMPANY
ADL-FISCAL-YEAR->GAM-FISCAL-YEAR
ADL-ACCT-UNIT->GAM-ACCT-UNIT
ADL-ACCOUNT->GAM-ACCOUNT
ADL-SUB-ACCOUNT->GAM-SUB-ACCOUNT
Glmaster GLMASTER Required
ADL-COMPANY->GLM-COMPANY
ADL-ACCOUNT->GLM-ACCOUNT
ADL-SUB-ACCOUNT->GLM-SUB-ACCOUNT
ADL-VAR-LEVELS->GLM-VAR-LEVELS
ADL-ACCT-UNIT->GLM-ACCT-UNIT
Glnames GLNAMES Required
ADL-COMPANY->GLN-COMPANY
ADL-ACCT-UNIT->GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
ADL-COMPANY->GLS-COMPANY


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

Home
Contact Us



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