|
|
ADAVGBAL FILE
Average Daily Balance by Date
the Average Daily Balance file contains the period, quarter and year balances
by company and effective date for each accounting unit and account. This file
is updated by AD190 if the ADCOMPANY.UPDATE-DAILY=Yes
UPDATED BY
GL120 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADV-COMPANY Numeric 4
Element: Company The Average Daily Balance Company
established in AD10. The company must
exist as a General Ledger Company.
ADV-EFFECT-DATE Numeric 8 (yyyymmdd)
Element: Effect Date This is the effective date that the
AD190 was run for. The amounts for a
particular effective date represent the
average daily balance for that date.
ADV-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.
ADV-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.
ADV-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.
ADV-VAR-LEVELS Alpha 30 GL120
Element: Var Levels A level that represents the location of
an accounting unit in an organization's
level structure.
ADV-FISCAL-YEAR Numeric 4 GL500
Element: Year This is the current fiscal year.
ADV-ACCT-PERIOD Numeric 2 GL500
Element: Acct Period This is the current accounting period.
ADV-AVG-PER-AMOUNT Signed 18.2
Element: Intl Amt This is the average period amount.
ADV-AVG-QTR-AMOUNT Signed 18.2
Element: Intl Amt The average quarter amount.
ADV-AVG-YER-AMOUNT Signed 18.2
Element: Intl Amt The average year amount.
ADV-MAINT-DATE Numeric 8 (yyyymmdd) GL500
Element: Maint Date The date last changed.
ADV-MAINT-TIME Numeric 6 (hhmmss) GL500
Element: Sys Time
ADAVGBAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADVSET1 COMPANY GL120 GL500
EFFECT-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
ADVSET2 COMPANY GL120
EFFECT-DATE
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
ADAVGBAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Adcfbal ADCFBAL Required
ADV-COMPANY -> ADL-COMPANY
ADV-EFFECT-DATE -> ADL-EFFECT-DATE
ADV-ACCT-UNIT -> ADL-ACCT-UNIT
ADV-ACCOUNT -> ADL-ACCOUNT
ADV-SUB-ACCOUNT -> ADL-SUB-ACCOUNT
Glamounts GLAMOUNTS Required
ADV-COMPANY -> GAM-COMPANY
ADV-FISCAL-YEAR -> GAM-FISCAL-YEAR
ADV-ACCT-UNIT -> GAM-ACCT-UNIT
ADV-ACCOUNT -> GAM-ACCOUNT
ADV-SUB-ACCOUNT -> GAM-SUB-ACCOUNT
Glmaster GLMASTER Required
ADV-COMPANY -> GLM-COMPANY
ADV-ACCOUNT -> GLM-ACCOUNT
ADV-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
ADV-VAR-LEVELS -> GLM-VAR-LEVELS
ADV-ACCT-UNIT -> GLM-ACCT-UNIT
Glnames GLNAMES Required
ADV-COMPANY -> GLN-COMPANY
ADV-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
ADV-COMPANY -> GLS-COMPANY
|
