ADAMOUNTSX

Daily GL Amounts for ADB

The Average Daily Amount file contains the the base amount balance for the ADB Company by Effective date for the accounting unit and account. This file is updated during the General Ledger Posting process.

REFERENCED BY
AD90.1 AD190


UPDATED BY
AD300 AD325 GL110 GL120 GL122 GL146
GL190 GL197 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL500 GL20.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BAD-COMPANY
Element: Company
Numeric 4
The Average Daily Balance Company established in AD10. The company must exist as a General Ledger Company.
AD325 GL110
GL146 GL190
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
BAD-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
The Effective Date is the effective date of the GL transaction. This file stores GL transations summarized by their effective date for the ADB Company, accounting unit and account.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
BAD-POST-DATE
Element: Post Date
Numeric 8 (yyyymmdd)
The date general ledger entries for the transaction will be posted to the general ledger.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
BAD-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.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
BAD-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.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
BAD-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.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
BAD-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
AD325 GL120
GL146 GL190
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
BAD-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.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
BAD-FISCAL-YEAR
Element: Year
Numeric 4
This is the current fiscal year.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
BAD-ACCT-PERIOD
Element: Acct Period
Numeric 2
This is the current accounting period.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
BAD-BASE-AMOUNT
Element: Intl Amt
Signed 18.2
The company base amount.
AD325 GL146
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1


ADAMOUNTSX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BADSET1 COMPANY
EFFECT-DATE
POST-DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
AD300 AD325
GL110 GL120
GL146 GL190
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
BADSET2 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
EFFECT-DATE
POST-DATE
AD325 AD90.1
GL110 GL120
GL122 GL20.2
BADSET3 COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FISCAL-YEAR
ACCT-PERIOD
EFFECT-DATE
POST-DATE
AD190


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

Home
Contact Us



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