FBDTLHIST

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
Element: Company
Numeric 4
The company number you are defining budgets for.
FB122 GL110
GL500
FDH-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
This is the fiscal year budgets are defined in.
FB122 GL500
FDH-BUDGET-NBR
Element: Budget
Numeric 3
This identifies the budget.
FB122 GL500
FDH-ACCT-UNIT
Element: Accounting Unit
Alpha 15
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.
FB122 GL500
FDH-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
FB122 GL500
FDH-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
FB122 GL500
FDH-VERSION
Element: Version
Numeric 2
This field displays the budget version number.
FB122 GL500
FDH-VAR-LEVELS
Element: Variable Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
FB122 GL120
GL500
FDH-DB-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
FB122 GL500
FDH-CR-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
FB122 GL500
FDH-DB-UNITS
Element: Auto Debits
Signed 15.2 Occurs 13 Times
The total positive detail auto reversing amounts.
FB122 GL500
FDH-CR-UNITS
Element: Auto Credits
Signed 15.2 Occurs 13 Times
The total negative detail auto reversing amounts.
FB122 GL500
FDH-COMPUTE-NAME
Compute Statement
Name
Alpha 12
The name assigned to an arithmetic equation created in Compute Statement (RW50.1). A compute statement consists of data dictionary items and operation symbols.
FB122 GL500
FDH-CHART-NAME
Element: Chart Name
Alpha 12
This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.
FB122 GL500
FDH-SPREAD-CODE
Element: Spread Code
Alpha 3
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.
FB122 GL500
FDH-DB-BEG-BAL
Element: Intl Amt
Signed 18.2
FB122 GL500
FDH-CR-BEG-BAL
Element: Intl Amt
Signed 18.2
FB122 GL500
FDH-DB-BEG-BAL-UNT
Element: Intl Amt
Signed 18.2
FB122 GL500
FDH-CR-BEG-BAL-UNT
Element: Intl Amt
Signed 18.2
FB122 GL500
FDH-BEG-BAL-FACTOR
Element: Factor
Alpha 15
The element that affects the budget change.
FB122
FDH-BEG-BAL-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
FB122
FDH-FACTOR
Element: Factor
Alpha 15 Occurs 13 Times
The element that affects the budget change.
FB122 GL500
FDH-FACTOR-RATE
Element: Curr Rate
Signed 14.7 Occurs 13 Times
The currency rate.
FB122 GL500


FBDTLHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FDHSET1 COMPANY*
FISCAL-YEAR
BUDGET-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
VERSION
FB122 FB215
FB220 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL110 GL120
GL300 GL500
FDHSET2 COMPANY
FISCAL-YEAR
BUDGET-NBR
VERSION
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FB295 FB296
GL120 GL500
FDHSET3 FISCAL-YEAR
BUDGET-NBR
COMPANY
VERSION
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
KeyChange
FB295


File created: Thu Jun 09 02:13:46 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.