ADBALANCE

ADB and COF by Period

The Average Daily Balance file contains the average daily balances for the period, quarter and year by Record Type B (Avg Daily Balance) or C (Cost of Funds) for the company, fiscal year, accounting unit and account. This file is updated by AD190 and AD191. This file will contain only one record for each calendar period and is used for Report Writer reporting. The ADAVGBAL file and ADCFBAL will contain records by date.

REFERENCED BY
AD290 AD98.3 AD98.1 AD97.1 AD97.3 RW80.1


UPDATED BY
AD190 AD191 AD300 AD320 GL110 GLRV.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADE-RECORD-TYPE
Element: Record Type
Alpha 1
This field identifies the type of record defined. Valid values are: B = Average Daily Balance C = Cost of Funds
AD190 AD191
ADE-COMPANY
Element: Company
Numeric 4
The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company.
AD190 AD191
ADE-FISCAL-YEAR
Element: Year
Numeric 4
This is the current fiscal year.
AD190 AD191
ADE-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 AD191
ADE-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 AD191
ADE-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 AD191
ADE-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
AD190 AD191
AD320
ADE-CHART-NAME
Element: Chart Name
Alpha 12
This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.
AD190 AD191
ADE-AVG-PER-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The average period balance.
AD190 AD191
ADE-AVG-QTR-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The average quarter balance.
AD190 AD191
ADE-AVG-YER-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The average year balance.
AD190 AD191
ADE-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
AD190 AD191
ADE-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
AD190 AD191


ADBALANCE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADESET1 COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
RECORD-TYPE
AD190 AD191
AD290 AD98.3
GL110
ADESET2 RECORD-TYPE
COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
AD300 AD98.1
ADESET3 RECORD-TYPE
FISCAL-YEAR
COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
AD97.1 AD97.3
ADESET4 RECORD-TYPE
FISCAL-YEAR
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
KeyChange
RW80.1 GLRV.1
ADESET5 RECORD-TYPE
FISCAL-YEAR
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
KeyChange
GLRV.1
ADESET6 RECORD-TYPE
FISCAL-YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
KeyChange
GLRV.1
ADESET7 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
RECORD-TYPE
AD320


ADBALANCE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glamounts GLAMOUNTS Required
ADE-COMPANY->GAM-COMPANY
ADE-FISCAL-YEAR->GAM-FISCAL-YEAR
ADE-ACCT-UNIT->GAM-ACCT-UNIT
ADE-ACCOUNT->GAM-ACCOUNT
ADE-SUB-ACCOUNT->GAM-SUB-ACCOUNT
Glchart GLCHART Required
ADE-CHART-NAME->GCH-CHART-NAME
Glmaster GLMASTER Required
ADE-COMPANY->GLM-COMPANY
ADE-ACCOUNT->GLM-ACCOUNT
ADE-SUB-ACCOUNT->GLM-SUB-ACCOUNT
ADE-VAR-LEVELS->GLM-VAR-LEVELS
ADE-ACCT-UNIT->GLM-ACCT-UNIT
Glnames GLNAMES Required
ADE-COMPANY->GLN-COMPANY
ADE-ACCT-UNIT->GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
ADE-COMPANY->GLS-COMPANY


File created: Thu Jun 09 11:05:10 2016

Home
Contact Us



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