|
|
ADCFBAL FILE
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
UPDATED BY
GL120 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADL-COMPANY Numeric 4
Element: Company The Average Daily Balance Company
established in AD10. The company must
exist as a General Ledger Company.
ADL-EFFECT-DATE Numeric 8 (yyyymmdd)
Element: Effect Date 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 Alpha 15
Element: Acct Unit 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 Numeric 6
Element: Account 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 Numeric 4
Element: Sub Acct 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 Alpha 30 GL120
Element: Var Levels A level that represents the location of
an accounting unit in an organization's
level structure.
ADL-FISCAL-YEAR Numeric 4 GL500
Element: Year This is the current fiscal year.
ADL-ACCT-PERIOD Numeric 2 GL500
Element: Acct Period This is the current accounting period.
ADL-CF-PER-AMOUNT Signed 18.2
Element: Intl Amt The cost of funds period amount.
ADL-CF-QTR-AMOUNT Signed 18.2
Element: Intl Amt The cost of funds quarter amount.
ADL-CF-YER-AMOUNT Signed 18.2
Element: Intl Amt The cost of funds year amount.
ADL-MAINT-TIME Numeric 6 (hhmmss) GL500
Element: Sys Time
ADL-MAINT-DATE Numeric 8 (yyyymmdd) GL500
Element: Maint Date The date last changed.
ADCFBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADLSET1 COMPANY GL120 GL500
EFFECT-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
ADLSET2 COMPANY GL120
EFFECT-DATE
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
ADCFBAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
