|
|
FBDTLHIST FILE
Budget Detail History
The Budgeting Detail History file stores detail budget records for a version
number.
REFERENCED BY
FB215 FB220 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 FB295 FB296
UPDATED BY
FB122 GL110 GL120 GL300 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FDH-COMPANY Numeric 4 FB122 GL110
Element: Company The company number you are defining GL500
budgets for.
FDH-FISCAL-YEAR Numeric 4 FB122 GL500
Element: Fiscal Year This is the fiscal year budgets are
defined in.
FDH-BUDGET-NBR Numeric 3 FB122 GL500
Element: Budget This identifies the budget.
FDH-ACCT-UNIT Alpha 15 FB122 GL500
Element: Accounting UniThe accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
FDH-ACCOUNT Numeric 6 FB122 GL500
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
FDH-SUB-ACCOUNT Numeric 4 FB122 GL500
Element: Subaccount This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
FDH-VERSION Numeric 2 FB122 GL500
Element: Version This field displays the budget version
number.
FDH-VAR-LEVELS Alpha 30 FB122 GL120
Element: Variable LevelA level that represents the location of GL500
an accounting unit in an organization's
level structure.
FDH-DB-AMOUNT Signed 18.2 Occurs 13 Times FB122 GL500
Element: Intl Amt
FDH-CR-AMOUNT Signed 18.2 Occurs 13 Times FB122 GL500
Element: Intl Amt
FDH-DB-UNITS Signed 15.2 Occurs 13 Times FB122 GL500
Element: Auto Debits The total positive detail auto
reversing amounts.
FDH-CR-UNITS Signed 15.2 Occurs 13 Times FB122 GL500
Element: Auto Credits The total negative detail auto
reversing amounts.
FDH-COMPUTE-NAME Alpha 12 FB122 GL500
Compute Statement The name assigned to an arithmetic
Name equation created in Compute Statement
(RW50.1). A compute statement consists
of data dictionary items and operation
symbols.
FDH-CHART-NAME Alpha 12 FB122 GL500
Element: Chart Name This is the name you assigned to the
chart of accounts when you defined your
company structure in the General Ledger
system.
FDH-SPREAD-CODE Alpha 3 FB122 GL500
Element: Spread Code A spread code is a formula for
budgeting spending activity that can be
set up in AC23.1 (Spread Codes) for each
account category. You can use a spread
code to schedule spending over the life
of the activity or activity group.
Spread codes can be used to represent
the characteristic spending pattern of
each account category.
FDH-DB-BEG-BAL Signed 18.2 FB122 GL500
Element: Intl Amt
FDH-CR-BEG-BAL Signed 18.2 FB122 GL500
Element: Intl Amt
FDH-DB-BEG-BAL-UNT Signed 18.2 FB122 GL500
Element: Intl Amt
FDH-CR-BEG-BAL-UNT Signed 18.2 FB122 GL500
Element: Intl Amt
FDH-BEG-BAL-FACTOR Alpha 15 FB122
Element: Factor The element that affects the budget
change.
FDH-BEG-BAL-RATE Signed 14.7 FB122
Element: Curr Rate The currency rate.
FDH-FACTOR Alpha 15 Occurs 13 Times FB122 GL500
Element: Factor The element that affects the budget
change.
FDH-FACTOR-RATE Signed 14.7 Occurs 13 Times FB122 GL500
Element: Curr Rate The currency rate.
FBDTLHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FDHSET1 COMPANY* FB122 FB215
FISCAL-YEAR FB220 FB95.2
BUDGET-NBR FB95.3 FB95.4
ACCT-UNIT FB95.5 FB95.6
ACCOUNT GL110 GL120
SUB-ACCOUNT GL300 GL500
VERSION
FDHSET2 COMPANY FB295 FB296
FISCAL-YEAR GL120 GL500
BUDGET-NBR
VERSION
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FDHSET3 FISCAL-YEAR KeyChange FB295
BUDGET-NBR
COMPANY
VERSION
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
|
