|
|
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
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
FDH-VERSION Numeric 2 FB122 GL500
Element: Version This field displays the budget version
number.
FDH-VAR-LEVELS Alpha 30 FB122 GL120
Element: Variable Levels GL500
FDH-DB-AMOUNT Currency 15.2 Occurs 13 Times FB122 GL500
Element: Amount
FDH-CR-AMOUNT Currency 15.2 Occurs 13 Times FB122 GL500
Element: Amount
FDH-DB-UNITS Signed 15.2 Occurs 13 Times FB122 GL500
Element: Auto Debits
FDH-CR-UNITS Signed 15.2 Occurs 13 Times FB122 GL500
Element: Auto Credits
FDH-COMPUTE-NAME Alpha 12 FB122 GL500
Compute Statement
Name
FDH-CHART-NAME Alpha 12 FB122 GL500
Element: Name User 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
FDH-DB-BEG-BAL Currency 15.2 FB122 GL500
Element: Amount
FDH-CR-BEG-BAL Currency 15.2 FB122 GL500
Element: Amount
FDH-DB-BEG-BAL-UNT Signed 15.2 FB122 GL500
Element: Auto Debits
FDH-CR-BEG-BAL-UNT Signed 15.2 FB122 GL500
Element: Auto Debits
FDH-BEG-BAL-FACTOR Alpha 15 FB122
Element: Factor
FDH-BEG-BAL-RATE Signed 12.6 FB122
Element: Account Rate
FDH-FACTOR Alpha 15 Occurs 13 Times FB122 GL500
Element: Factor The element that affects the budget
change.
FDH-FACTOR-RATE Signed 12.6 Occurs 13 Times FB122 GL500
Element: Account Rate
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 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
|
