|
|
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: Effective DateThis 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: Accounting UniThe 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: Subaccount This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ADL-VAR-LEVELS Alpha 30 GL120
Element: Variable LevelA level that represents the location of
an accounting unit in an organization's
level structure.
ADL-FISCAL-YEAR Numeric 4 GL500
Element: Last Closed YeThis is the current fiscal year.
ADL-ACCT-PERIOD Numeric 2 GL500
Element: Account PeriodThis 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 The time last changed.
ADL-MAINT-DATE Numeric 8 (yyyymmdd) GL500
Element: Maintenance DaThe 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
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 (ADVSET1)
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
|
