Budget Detail
The Budgeting detail file contains the budget information for each budget number, fiscal year and account. Thirteen amount fields are maintained on each detail record.
REFERENCED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FBD-COMPANY Element: Company | Numeric 4 The company number you are defining budgets for. |
|
||||||||||||||||||||||||||||||
FBD-FISCAL-YEAR Element: Fiscal Year | Numeric 4 This is the fiscal year you are defining budgets in. |
|
||||||||||||||||||||||||||||||
FBD-BUDGET-NBR Element: Budget | Numeric 3 The number that identifies the budget. |
|
||||||||||||||||||||||||||||||
FBD-ACCT-UNIT Element: Accounting Unit | Alpha 15 The accounting unit you are defining budget values for. This field, along with the account and subaccount, make up the location (account) where amounts and other account information is stored. |
|
||||||||||||||||||||||||||||||
FBD-ACCOUNT Element: Account | Numeric 6 The account number you are defining budget values for. This field, along with the accounting unit and subaccount, make up the location (account) where amounts and other account information are stored. |
|
||||||||||||||||||||||||||||||
FBD-SUB-ACCOUNT Element: Subaccount | Numeric 4 The subaccount number you are defining budget values for. This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored. |
|
||||||||||||||||||||||||||||||
FBD-VAR-LEVELS Element: Variable Level | Alpha 30 A variable level represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||||||||||||||||||||
FBD-DB-AMOUNT Element: Debit Amount | Signed 18.2 Occurs 13 Times This is the budget debit amount. |
|
||||||||||||||||||||||||||||||
FBD-CR-AMOUNT Element: Credit Amount | Signed 18.2 Occurs 13 Times This is the budget credit amount. |
|
||||||||||||||||||||||||||||||
FBD-DB-UNITS Element: Auto Debits | Signed 15.2 Occurs 13 Times The total positive detail auto reversing amounts. |
|
||||||||||||||||||||||||||||||
FBD-CR-UNITS Element: Auto Credits | Signed 15.2 Occurs 13 Times The total negative detail auto reversing amounts. |
|
||||||||||||||||||||||||||||||
FBD-COMPUTE-NAME Element: Compute | 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. |
|
||||||||||||||||||||||||||||||
FBD-MAINT-DATE Element: Maintenance Date | Numeric 8 (yyyymmdd) The last date the budget was maintained. |
|
||||||||||||||||||||||||||||||
FBD-MAINT-TIME Element: Maintenance Time | Numeric 6 (hhmmss) The last time the budget was maintained. |
|
||||||||||||||||||||||||||||||
FBD-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. |
|
||||||||||||||||||||||||||||||
FBD-SPREAD-CODE Element: Spread Code | Alpha 3 A spread code is a budget spending activity formula set up in FB10.1 (Spread Codes) for each budget period. |
|
||||||||||||||||||||||||||||||
FBD-DB-BEG-BAL Debit Beginning Balance | Signed 18.2 This is the debit beginning balance. |
|
||||||||||||||||||||||||||||||
FBD-CR-BEG-BAL Credit Beginning Balance | Signed 18.2 This is the credit beginning balance. |
|
||||||||||||||||||||||||||||||
FBD-DB-BEG-BAL-UNT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||||
FBD-CR-BEG-BAL-UNT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||||||||||||
FBD-BEG-BAL-FACTOR Element: Factor | Alpha 15 The element that affects the budget change. |
|
||||||||||||||||||||||||||||||
FBD-BEG-BAL-RATE Element: Curr Rate | Signed 14.7 The currency rate. |
|
||||||||||||||||||||||||||||||
FBD-FACTOR Element: Factor | Alpha 15 Occurs 13 Times The global factor defined in FB00.1 (Global Factors). |
|
||||||||||||||||||||||||||||||
FBD-FACTOR-RATE Element: Curr Rate | Signed 14.7 Occurs 13 Times The rate that affects the factor. For example, you could type the inflation rate. If you select units and amounts, the rate is calculated. |
|
||||||||||||||||||||||||||||||
FBD-PARENT-VAR-LEV Element: Parent Var Lev | Alpha 30 The variable level address of the parent accounting unit. |
|
||||||||||||||||||||||||||||||
FBD-CYBBUD Current Year Beginning Budget | Derived This is the current year beginning budget. |
|
||||||||||||||||||||||||||||||
FBD-CPBUD-DR Current Period Debit Amount | Derived This is the current period debit amount. |
|
||||||||||||||||||||||||||||||
FBD-CPBUD-CR Current Period Credit Amount | Derived This is the current period credit amount. |
|
||||||||||||||||||||||||||||||
FBD-CPBUD Current Net Debit and Credit | Derived This is the current period net debit and credit amount. |
|
||||||||||||||||||||||||||||||
FBD-CUR-PD-SUM-B-D Current YTD Debit Amount | Derived This is the current year-to-date debit amount. |
|
||||||||||||||||||||||||||||||
FBD-CUR-PD-SUM-B-C Current YTD Credit Amount | Derived This is the current year-to-date credit amount. |
|
||||||||||||||||||||||||||||||
FBD-CYDBUD Element: Current YTD Budget | Derived This is the current year-to-date budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD1-DR Period 1 Debit Budget | Derived This is the period 1 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD1-CR Period 1 Credit Budget | Derived This is the period 1 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD1 Element: Cypbud1 | Derived Current year period year to date period 1. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD2-DR Period 2 Debit Budget | Derived This is the period 2 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD2-CR Period 2 Credit Budget | Derived This is the period 2 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD2 Element: Cypbud2 | Derived Current year period year to date period 2. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD3-DR Period 3 Debit Budget | Derived This is the period 3 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD3-CR Period 3 Credit Budget | Derived This is the period 3 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD3 Element: Cypbud3 | Derived Current year period year to date period 3. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD4-DR Period 4 Debit Budget | Derived This is the period 4 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD4-CR Period 4 Credit Budget | Derived This is the period 4 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD4 Element: Cypbud4 | Derived Current year period year to date period 4. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD5-DR Period 5 Debit Budget | Derived This is the period 5 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD5-CR Period 5 Credit Budget | Derived This is the period 5 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD5 Element: Cypbud5 | Derived Current year period year to date period 5. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD6-DR Period 6 Debit Budget | Derived This is the period 6 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD6-CR Period 6 Credit Budget | Derived This is the period 6 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD6 Element: Cypbud6 | Derived Current year period year to date period 6. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD7-DR Period 7 Debit Budget | Derived This is the period 7 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD7-CR Period 7 Credit Budget | Derived This is the period 7 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD7 Element: Cypbud7 | Derived Current year period year to date period 7. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD8-DR Period 8 Debit Budget | Derived This is the period 8 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD8-CR Period 8 Credit Budget | Derived This is the period 8 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD8 Element: Cypbud8 | Derived Current year period year to date period 8. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD9-DR Period 9 Debit Budget | Derived This is the period 9 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD9-CR Period 9 Credit Budget | Derived This is the period 9 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD9 Element: Cypbud9 | Derived Current year period year to date period 9. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD10-DR Period 10 Debit Budget | Derived This is the period 10 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD10-CR Period 10 Credit Budget | Derived This is the period 10 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD10 Element: Cypbud10 | Derived Current year period year to date period 10. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD11-DR Period 11 Debit Budget | Derived This is the period 11 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD11-CR Period 11 Credit Budget | Derived This is the period 11 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD11 Element: Cypbud11 | Derived Current year period year to date period 11. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD12-DR Period 12 Debit Budget | Derived This is the period 12 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD12-CR Period 12 Credit Budget | Derived This is the period 12 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD12 Element: Cypbud12 | Derived Current year period year to date period 12. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD13-DR Period 13 Debit Budget | Derived This is the period 13 debit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPBUD13-CR Period 13 Credit Budget | Derived This is the period 13 credit budget. |
|
||||||||||||||||||||||||||||||
FBD-CYPYTD13 Element: Cypbud13 | Derived Current year period year to date period 13. |
|
||||||||||||||||||||||||||||||
FBD-BLANK Element: Blank | Derived This derived field is always blank. It is used in drill around to allow column headings. |
|
||||||||||||||||||||||||||||||
FBD-UNT-BEG-BAL Element: Unt Beg Bal | Derived This is the unit beginning balance. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD1-DR Element: Untbud1 Dr | Derived This is the period 1 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD1-CR Element: Untbud1 Cr | Derived This is the period 1 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD1 Element: Untbud1 | Derived Units current year period year to date period 1. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD2-DR Element: Untbud2 Dr | Derived This is the period 2 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD2-CR Element: Untbud2 Cr | Derived This is the period 2 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD2 Element: Untbud2 | Derived Units current year period year to date period 2. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD3-DR Element: Untbud3 Dr | Derived This is the period 3 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD3-CR Element: Untbud3 Cr | Derived This is the period 3 credit budget unit |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD3 Element: Untbud3 | Derived Units current year period year to date period 3. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD4-DR Element: Untbud4 Dr | Derived This is the period 4 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD4-CR Element: Untbud4 Cr | Derived This is the period 4 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD4 Element: Untbud4 | Derived Units current year period year to date period 4. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD5-DR Element: Untbud5 Dr | Derived This is the period 5 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD5-CR Element: Untbud5 Cr | Derived This is the period 5 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD5 Element: Untbud5 | Derived Units current year period year to date period 5. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD6-DR Element: Untbud6 Dr | Derived This is the period 6 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD6-CR Element: Untbud6 Cr | Derived This is the period 6 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD6 Element: Untbud6 | Derived Units current year period year to date period 6. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD7-DR Element: Untbud7 Dr | Derived This is the period 7 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD7-CR Element: Untbud7 Cr | Derived This is the period 7 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD7 Element: Untbud7 | Derived Units current year period year to date period 7. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD8-DR Element: Untbud8 Dr | Derived This is the period 8 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD8-CR Element: Untbud8 Cr | Derived This is the period 8 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD8 Element: Untbud8 | Derived Units current year period year to date period 8. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD9-DR Element: Untbud9 Dr | Derived This is the period 9 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD9-CR Element: Untbud9 Cr | Derived This is the period 9 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD9 Element: Untbud9 | Derived Units current year period year to date period 9. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD10-DR Element: Untbud10 Dr | Derived This is the period 10 debut budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD10-CR Element: Untbud10 Cr | Derived This is the period 10 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD10 Element: Untbud10 | Derived Units current year period year to date period 10. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD11-DR Element: Untbud11 Dr | Derived This is the period 11 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD11-CR Element: Untbud11 Cr | Derived This is the period 11 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD11 Element: Untbud11 | Derived Units current year period year to date period 11. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD12-DR Element: Untbud12 Dr | Derived This is the period 12 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD12-CR Element: Untbud12 Cr | Derived This is the period 12 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD12 Element: Untbud12 | Derived Units current year period year to date period 12. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD13-DR Element: Untbud13 Dr | Derived This is the period 13 debit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD13-CR Element: Untbud13 Cr | Derived This is the period 13 credit budget unit. |
|
||||||||||||||||||||||||||||||
FBD-UNTBUD13 Element: Untbud13 | Derived Units current year period year to date period 13. |
|
||||||||||||||||||||||||||||||
FBD-ROLLOVER-AMT Element: Intl Amt | Signed 18.2 |
|||||||||||||||||||||||||||||||
FBD-ROLLOVER-BAL Element: Intl Amt | Signed 18.2 |
|||||||||||||||||||||||||||||||
FBD-BUD-ACT-AMT Element: Intl Amt | Signed 18.2 Occurs 13 Times |
|
||||||||||||||||||||||||||||||
FBD-FUTURE-BUD-ACT Element: Intl Amt | Signed 18.2 Occurs 13 Times |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FBDSET1 |
COMPANY FISCAL-YEAR BUDGET-NBR ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
|||||||||||||||||
FBDSET2 |
FISCAL-YEAR BUDGET-NBR COMPANY VAR-LEVELS ACCOUNT SUB-ACCOUNT ACCT-UNIT |
|
|||||||||||||||||
FBDSET3 |
COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT BUDGET-NBR FISCAL-YEAR |
|
|||||||||||||||||
FBDSET4 |
COMPANY FISCAL-YEAR BUDGET-NBR ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||
FBDSET5 |
FISCAL-YEAR BUDGET-NBR COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS ACCT-UNIT |
|
| ||||||||||||||||
FBDSET6 |
FISCAL-YEAR BUDGET-NBR VAR-LEVELS ACCOUNT SUB-ACCOUNT COMPANY ACCT-UNIT |
|
| ||||||||||||||||
FBDSET7 |
FISCAL-YEAR BUDGET-NBR ACCOUNT SUB-ACCOUNT VAR-LEVELS COMPANY ACCT-UNIT |
|
| ||||||||||||||||
FBDSET8 |
COMPANY FISCAL-YEAR BUDGET-NBR ACCOUNT SUB-ACCOUNT ACCT-UNIT |
|
| ||||||||||||||||
FBDSET9 |
PARENT-VAR-LEV FISCAL-YEAR BUDGET-NBR COMPANY ACCOUNT SUB-ACCOUNT ACCT-UNIT |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Account | GLMASTER |
Required
| ||||||||||||||||||
Acct Unit | GLNAMES |
Required
| ||||||||||||||||||
Budget | FBHEADER |
Required
| ||||||||||||||||||
Chart Detail | GLCHARTDTL |
Required
| ||||||||||||||||||
Company | GLSYSTEM |
Required
| ||||||||||||||||||
Compute | CMPUTE |
Not Required
| ||||||||||||||||||
Fbdtlbod | FBDTLBOD |
Not Required, Delete Cascades
| ||||||||||||||||||
Fbspread | FBSPREAD |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Bud Unt Parent | GLCONSOL |
| ||||||||||||||||||||||||||||||||||||
Budget Parent | GLCONSOL |
| ||||||||||||||||||||||||||||||||||||
Fbbatrans | FBBATRANS |
| ||||||||||||||||||||||||||||||||||||
Fbdetailau | FBDETAILAU |
| ||||||||||||||||||||||||||||||||||||
Fbtrans | FBTRANS |
| ||||||||||||||||||||||||||||||||||||
Glcommitx | GLCOMMITX |
| ||||||||||||||||||||||||||||||||||||
Gltrans | GLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.