|
|
ADAMOUNTSX FILE
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
GL122 GL20.2
UPDATED BY
GL120 GL146 GL190 GL197 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BAD-COMPANY Numeric 4 GL146 GL190
Element: Company The Average Daily Balance Company GL197 GL40.1
established in AD10. The company must GL40.2 GL40.3
exist as a General Ledger Company. GL40.7 GL40.8
GL44.1 GL45.1
BAD-EFFECT-DATE Numeric 8 (yyyymmdd) GL146 GL190
Element: Effect Date The Effective Date is the effective date GL197 GL40.1
of the GL transaction. This file stores GL40.2 GL40.3
GL transations summarized by their GL40.7 GL40.8
effective date for the ADB Company, GL44.1 GL45.1
accounting unit and account.
BAD-POST-DATE Numeric 8 (yyyymmdd) GL146 GL190
Element: Post Date The date general ledger entries for the GL197 GL40.1
transaction will be posted to the GL40.2 GL40.3
general ledger. GL40.7 GL40.8
GL44.1 GL45.1
BAD-ACCT-UNIT Alpha 15 GL146 GL190
Element: Acct Unit The accounting unit is a shorthand GL197 GL40.1
notation representing the variable level GL40.2 GL40.3
number. When used in the General Ledger GL40.7 GL40.8
Master file, the accounting unit must GL44.1 GL45.1
be defined in the General Ledger Names
file as a posting accounting unit.
BAD-ACCOUNT Numeric 6 GL146 GL190
Element: Account This field along with the accounting GL197 GL40.1
unit and subaccount make up the location GL40.2 GL40.3
(account) where amounts and other GL40.7 GL40.8
account information is stored. GL44.1 GL45.1
BAD-SUB-ACCOUNT Numeric 4 GL146 GL190
Element: Sub Acct This field contains the subaccount from GL197 GL40.1
your general ledger chart of accounts GL40.2 GL40.3
that was charged with the amount carried GL40.7 GL40.8
on this record. GL44.1 GL45.1
BAD-VAR-LEVELS Alpha 30 GL120 GL146
Element: Var Levels A level that represents the location of GL190 GL197
an accounting unit in an organization's GL40.1 GL40.2
level structure. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
BAD-CHART-NAME Alpha 12 GL146 GL190
Element: Chart Name This is the name you assigned to the GL197 GL40.1
chart of accounts when you defined your GL40.2 GL40.3
company structure in the General Ledger GL40.7 GL40.8
system. GL44.1 GL45.1
BAD-FISCAL-YEAR Numeric 4 GL146 GL190
Element: Year This is the current fiscal year. GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
BAD-ACCT-PERIOD Numeric 2 GL146 GL190
Element: Acct Period This is the current accounting period. GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
BAD-BASE-AMOUNT Signed 18.2 GL146 GL190
Element: Intl Amt The company base amount. 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 GL120 GL146
EFFECT-DATE GL190 GL197
POST-DATE GL40.1 GL40.2
ACCT-UNIT GL40.3 GL40.7
ACCOUNT GL40.8 GL44.1
SUB-ACCOUNT GL45.1 GL500
BADSET2 COMPANY GL120 GL122
ACCT-UNIT GL20.2
ACCOUNT
SUB-ACCOUNT
EFFECT-DATE
POST-DATE
BADSET3 COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FISCAL-YEAR
ACCT-PERIOD
EFFECT-DATE
POST-DATE
|
