ADAVGBAL

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

REFERENCED BY
AD191 AD290 AD96.1 AD98.1 AD97.1


UPDATED BY
AD190 AD300 GL120 GL500 GL110

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADV-COMPANY
Element: Company
Numeric 4
The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company.
AD190
ADV-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
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.
AD190
ADV-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.
AD190
ADV-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.
AD190
ADV-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.
AD190
ADV-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
AD190 GL120
ADV-FISCAL-YEAR
Element: Year
Numeric 4
This is the current fiscal year.
AD190 GL500
ADV-ACCT-PERIOD
Element: Acct Period
Numeric 2
This is the current accounting period.
AD190 GL500
ADV-AVG-PER-AMOUNT
Element: Intl Amt
Signed 18.2
This is the average period amount.
AD190
ADV-AVG-QTR-AMOUNT
Element: Intl Amt
Signed 18.2
The average quarter amount.
AD190
ADV-AVG-YER-AMOUNT
Element: Intl Amt
Signed 18.2
The average year amount.
AD190
ADV-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
GL500
ADV-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
GL500


ADAVGBAL FILE INDEX

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


ADAVGBAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:04:23 2016

Home
Contact Us



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