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

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.
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.
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.
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.
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.
ADV-VAR-LEVELS Element: Var Levels	Alpha 30 A level that represents the location of an accounting unit in an organization's level structure.	GL120
ADV-FISCAL-YEAR Element: Year	Numeric 4 This is the current fiscal year.	GL500
ADV-ACCT-PERIOD Element: Acct Period	Numeric 2 This is the current accounting period.	GL500
ADV-AVG-PER-AMOUNT Element: Intl Amt	Signed 18.2 This is the average period amount.
ADV-AVG-QTR-AMOUNT Element: Intl Amt	Signed 18.2 The average quarter amount.
ADV-AVG-YER-AMOUNT Element: Intl Amt	Signed 18.2 The average year amount.
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

ADAVGBAL FILE RELATIONS

ONE TO ONE RELATIONS

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