FBDTLHIST FILE
Budget Detail History
The Budgeting Detail History file stores detail budget records for a version
number.
REFERENCED BY
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
Company The company number you are defining GL500
budgets for.
FDH-FISCAL-YEAR Numeric 4 FB122 GL500
Fiscal Year This is the fiscal year budgets are
defined in.
FDH-BUDGET-NBR Numeric 3 FB122 GL500
Budget This identifies the budget.
FDH-ACCT-UNIT Alpha 15 FB122 GL500
Accounting Unit The 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
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
Subaccount This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
FDH-VERSION Numeric 2 FB122 GL500
Version This field displays the budget version
number.
FDH-VAR-LEVELS Alpha 30 FB122 GL120
Variable Levels A level that represents the location of GL500
an accounting unit in an organization's
level structure.
FDH-DB-AMOUNT Currency 15.2 Occurs 13 Times FB122 GL500
Debit Amount The budget debit amount.
FDH-CR-AMOUNT Currency 15.2 Occurs 13 Times FB122 GL500
Credit Amount The budget credit amount.
FDH-DB-UNITS Signed 15.2 Occurs 13 Times FB122 GL500
Debit Units Select the unit for the activity you
performed. For example, a unit would be
the number of computers purchased.
FDH-CR-UNITS Signed 15.2 Occurs 13 Times FB122 GL500
Credit Unit Select the unit for the activity you
performed. For example, a unit would be
the number of computers purchased.
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
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
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 Currency 15.2 FB122 GL500
Debit Beginning The debit beginning balance.
Balance
FDH-CR-BEG-BAL Currency 15.2 FB122 GL500
Credit Beginning The credit beginning balance.
Balance
FDH-DB-BEG-BAL-UNT Signed 15.2 FB122 GL500
Unit Debit You can enter the units beginning
Beginning Balance balance. For example, a unit would be
the number of computers purchased.
FDH-CR-BEG-BAL-UNT Signed 15.2 FB122 GL500
Unit Credit You can enter the units beginning
Beginning Balance balance in this field. For example, a
unit would be the number of computers
purchased.
FDH-BEG-BAL-FACTOR Alpha 15 FB122
Factor Beginning You can type or select the global
Balance factor that is used to help calculate
the budget amount.
You define global factors in FB00.1
(Global Factors).
FDH-BEG-BAL-RATE Signed 12.6 FB122
Rate Beginning You can type or select the rate that
Balance affects the factor. For example, you
could type the inflation rate or an
employees hourly contract salary.
FDH-FACTOR Alpha 15 Occurs 13 Times FB122 GL500
Factor The element that affects the budget
change.
FDH-FACTOR-RATE Signed 12.6 Occurs 13 Times FB122 GL500
Rate You can type or select the rate that
affects the factor. For example, you
could type the inflation rate.
If you select units and amounts, the
rate is calculated.
FBDTLHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FDHSET1 COMPANY* FB122 FB220
FISCAL-YEAR FB95.2 FB95.3
BUDGET-NBR FB95.4 FB95.5
ACCT-UNIT FB95.6 GL110
ACCOUNT GL120 GL300
SUB-ACCOUNT GL500
VERSION
FDHSET2 COMPANY FB295 FB296
FISCAL-YEAR GL500
BUDGET-NBR
VERSION
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FDHSET3 FISCAL-YEAR FB295
BUDGET-NBR
COMPANY
VERSION
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
|
