|
|
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: Effective DateThe 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
General Ledger The date general ledger entries for the GL197 GL40.1
Posting Date 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: Accounting UniThe 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: Subaccount 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-VAR-LEVELS Alpha 30 GL120 GL146
Element: Variable LevelA 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: Last Closed YeThis 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: Account PeriodThis 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 GL146 GL190
EFFECT-DATE GL197 GL40.1
POST-DATE GL40.2 GL40.3
ACCT-UNIT GL40.7 GL40.8
ACCOUNT GL44.1 GL45.1
SUB-ACCOUNT 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
BADSET4 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-PERIOD
EFFECT-DATE
POST-DATE
|
