|
|
FBDETAIL FILE
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
FB141 FB195 FB220 FB295 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 FB95.1 GL295 GLOP.1
GL95.1 GL95.2 GL95.3 GL95.4 GL95.5 GL95.6
GL95.7 GL95.8 GL95.9 GL96.1 GL96.2 GL96.3
GL96.4 GL96.5 GL97.1 GL97.2 GL97.3 GL97.4
GL97.5 GL97.6 GL97.7 GL97.8 GL97.9 GL98.1
GL98.2 GL98.3 GL98.4 GL98.5 GL99.1 GL99.2
GL99.3 GL99.4 GL99.5 GL99.6 GLSV.1 RW80.1
GLRV.1 GL122 GL20.2 FB230 FB231 RW298
GL320
UPDATED BY
CA110 CA195 FB100 FB101 FB120 FB121
FB122 FB165 FB20.1 FB20.2 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 FB700
GL110 GL120 GL300 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBD-COMPANY Numeric 4 CA110 CA195
Company The company number you are defining FB120 FB121
budgets for. FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 GL110
GL500 GLSV.1
RW298 RW80.1
FBD-FISCAL-YEAR Numeric 4 CA110 CA195
Fiscal Year This is the fiscal year you are FB120 FB121
defining budgets in. FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 GL500
GLSV.1 RW298
FBD-BUDGET-NBR Numeric 3 CA110 CA195
Budget The number that identifies the budget. FB100 FB101
FB120 FB121
FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 GL500
GLSV.1 RW298
FBD-ACCT-UNIT Alpha 15 CA110 CA195
Accounting Unit The accounting unit you are defining FB120 FB121
budget values for. FB165 FB20.1
FB20.3 FB20.4
This field, along with the account and FB20.6 FB20.7
subaccount, make up the location FB21.1 FB30.1
(account) where amounts and other FB31.1 GL500
account information is stored. GLSV.1 RW298
FBD-ACCOUNT Numeric 6 CA110 CA195
Account The account number you are defining FB120 FB121
budget values for. FB165 FB20.1
FB20.3 FB20.4
This field, along with the accounting FB20.6 FB20.7
unit and subaccount, make up the FB21.1 FB30.1
location (account) where amounts and FB31.1 GL500
other account information are stored. GLSV.1 RW298
RW80.1
FBD-SUB-ACCOUNT Numeric 4 CA110 CA195
Subaccount The subaccount number you are defining FB120 FB121
budget values for. FB165 FB20.1
FB20.3 FB20.4
This field along with the accounting FB20.6 FB20.7
unit and account make up the location FB21.1 FB30.1
(account) where amounts and other FB31.1 GL500
account information is stored. GLSV.1 RW298
RW80.1
FBD-VAR-LEVELS Alpha 30 CA110 CA195
Variable Level A variable level represents the FB120 FB121
location of an accounting unit in an FB165 FB20.1
organization's level structure. FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 GL120
GL500 GLSV.1
FBD-DB-AMOUNT Currency 15.2 Occurs 13 Times CA195 FB100
Debit Amount This is the budget debit amount. FB101 FB120
FB121 FB165
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB700 GL500
GLSV.1
FBD-CR-AMOUNT Currency 15.2 Occurs 13 Times CA195 FB100
Credit Amount This is the budget credit amount. FB101 FB120
FB121 FB165
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB700 GL500
GLSV.1
FBD-DB-UNITS Signed 15.2 Occurs 13 Times CA195 FB100
Debit Units Select the unit for the activity you FB101 FB120
performed. For example, a unit would be FB121 FB165
the number of computers purchased. FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB700 GL500
GLSV.1
FBD-CR-UNITS Signed 15.2 Occurs 13 Times CA195 FB100
Credit Units Select the unit for the activity you FB101 FB120
performed. For example, a unit would be FB121 FB165
the number of computers purchased. FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB700 GL500
GLSV.1
FBD-COMPUTE-NAME Alpha 12 CA195 FB100
Compute The name assigned to an arithmetic FB120 FB121
equation created in RW50 (Compute FB165 FB20.1
Statement). A compute statement FB20.3 FB20.4
consists of data dictionary items and FB20.6 FB20.7
operation symbols. FB21.1 FB30.1
FB31.1 GL500
GLSV.1
FBD-MAINT-DATE Numeric 8 (yyyymmdd) CA195 FB100
Maintenance Date The last date the budget was FB120 FB121
maintained. FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 GL500
GLSV.1
FBD-MAINT-TIME Numeric 6 (hhmmss) CA195 FB100
Maintenance Time The last time the budget was FB120 FB121
maintained. FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 GL500
GLSV.1
FBD-CHART-NAME Alpha 12 CA110 CA195
Chart Name This is the name you assigned to the FB120 FB165
chart of accounts when you defined your FB20.1 FB20.3
company structure in the General Ledger FB20.4 FB20.6
system. FB20.7 FB21.1
GL500 GLSV.1
FBD-SPREAD-CODE Alpha 3 CA195 FB120
Spread Code A spread code is a budget spending FB121 FB165
activity formula set up in FB10.1 FB20.1 FB20.3
(Spread Codes) for each budget period. FB20.4 FB20.6
FB20.7 FB21.1
GL500 GLSV.1
FBD-DB-BEG-BAL Currency 15.2 CA195 FB101
Debit Beginning This is the debit beginning balance. FB120 FB121
Balance FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB700
GL500 GLSV.1
FBD-CR-BEG-BAL Currency 15.2 CA195 FB101
Credit Beginning This is the credit beginning balance. FB120 FB121
Balance FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB700
GL500 GLSV.1
FBD-DB-BEG-BAL-UNT Signed 15.2 FB101 FB120
Debit Units You can enter the units beginning FB121 FB165
Beginning Balance balance. For example, a unit would be FB20.1 FB20.3
the number of computers purchased. FB20.4 FB20.6
FB20.7 FB21.1
FB700 GL500
GLSV.1
FBD-CR-BEG-BAL-UNT Signed 15.2 FB101 FB120
Credit Units You can enter the units beginning FB121 FB165
Beginning Balance balance in this field. For example, a FB20.1 FB20.3
unit would be the number of computers FB20.4 FB20.6
purchased. FB20.7 FB21.1
FB700 GL500
GLSV.1
FBD-BEG-BAL-FACTOR Alpha 15 CA195 FB120
Factor Beginning You can type or select the global FB121 FB165
Balance factor that is used to help calculate FB20.1 FB20.3
the budget amount. FB20.4 FB20.6
FB20.7 FB21.1
You define global factors in FB00.1
(Global Factors).
FBD-BEG-BAL-RATE Signed 12.6 CA195 FB101
Rate Beginning You can type or select the rate that FB120 FB121
Balance affects the factor. For example, you FB165 FB20.1
could type the inflation rate or an FB20.3 FB20.4
employees hourly contract salary. FB20.6 FB20.7
FB21.1
FBD-FACTOR Alpha 15 Occurs 13 Times CA195 FB100
Factor The global factor defined in FB00.1 FB120 FB121
(Global Factors). FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 GL500
FBD-FACTOR-RATE Signed 12.6 Occurs 13 Times CA195 FB101
Rate The rate that affects the factor. For FB120 FB121
example, you could type the inflation FB165 FB20.1
rate. FB20.3 FB20.4
FB20.6 FB20.7
If you select units and amounts, the FB21.1 GL500
rate is calculated.
FBD-CYBBUD Derived
Current Year This is the current year beginning
Beginning Budget budget.
FBD-CPBUD-DR Derived
Current Period This is the current period debit amount.
Debit Amount
FBD-CPBUD-CR Derived
Current Period This is the current period credit
Credit Amount amount.
FBD-CPBUD Derived
Current Net Debit This is the current period net debit
and Credit and credit amount.
FBD-CUR-PD-SUM-B-D Derived
Current YTD Debit This is the current year-to-date debit
Amount amount.
FBD-CUR-PD-SUM-B-C Derived
Current YTD Credit This is the current year-to-date credit
Amount amount.
FBD-CYDBUD Derived
Current YTD Budget This is the current year-to-date budget.
FBD-CYPBUD1-DR Derived
Period 1 Debit This is the period 1 debit budget.
Budget
FBD-CYPBUD1-CR Derived
Period 1 Credit This is the period 1 credit budget.
Budget
FBD-CYPBUD1 Derived
Period 1 Budget This is the period 1 budget.
FBD-CYPBUD2-DR Derived
Period 2 Debit This is the period 2 debit budget.
Budget
FBD-CYPBUD2-CR Derived
Period 2 Credit This is the period 2 credit budget.
Budget
FBD-CYPBUD2 Derived
Period 2 Budget This is the period 2 budget.
FBD-CYPBUD3-DR Derived
Period 3 Debit This is the period 3 debit budget.
Budget
FBD-CYPBUD3-CR Derived
Period 3 Credit This is the period 3 credit budget.
Budget
FBD-CYPBUD3 Derived
Period 3 Budget This is the period 3 budget.
FBD-CYPBUD4-DR Derived
Period 4 Debit This is the period 4 debit budget.
Budget
FBD-CYPBUD4-CR Derived
Period 4 Credit This is the period 4 credit budget.
Budget
FBD-CYPBUD4 Derived
Period 4 Budget This is the period 4 budget.
FBD-CYPBUD5-DR Derived
Period 5 Debit This is the period 5 debit budget.
Budget
FBD-CYPBUD5-CR Derived
Period 5 Credit This is the period 5 credit budget.
Budget
FBD-CYPBUD5 Derived
Period 5 Budget This is the period 5 budget.
FBD-CYPBUD6-DR Derived
Period 6 Debit This is the period 6 debit budget.
Budget
FBD-CYPBUD6-CR Derived
Period 6 Credit This is the period 6 credit budget.
Budget
FBD-CYPBUD6 Derived
Period 6 Budget This is the period 6 budget.
FBD-CYPBUD7-DR Derived
Period 7 Debit This is the period 7 debit budget.
Budget
FBD-CYPBUD7-CR Derived
Period 7 Credit This is the period 7 credit budget.
Budget
FBD-CYPBUD7 Derived
Period 7 Budget This is the period 7 budget.
FBD-CYPBUD8-DR Derived
Period 8 Debit This is the period 8 debit budget.
Budget
FBD-CYPBUD8-CR Derived
Period 8 Credit This is the period 8 credit budget.
Budget
FBD-CYPBUD8 Derived
Period 8 Budget This is the period 8 budget.
FBD-CYPBUD9-DR Derived
Period 9 Debit This is the period 9 debit budget.
Budget
FBD-CYPBUD9-CR Derived
Period 9 Credit This is the period 9 credit budget.
Budget
FBD-CYPBUD9 Derived
Period 9 Budget This is the period 9 budget.
FBD-CYPBUD10-DR Derived
Period 10 Debit This is the period 10 debit budget.
Budget
FBD-CYPBUD10-CR Derived
Period 10 Credit This is the period 10 credit budget.
Budget
FBD-CYPBUD10 Derived
Period 10 Budget This is the period 10 budget.
FBD-CYPBUD11-DR Derived
Period 11 Debit This is the period 11 debit budget.
Budget
FBD-CYPBUD11-CR Derived
Period 11 Credit This is the period 11 credit budget.
Budget
FBD-CYPBUD11 Derived
Period 11 Budget This is the period 11 budget.
FBD-CYPBUD12-DR Derived
Period 12 Debit This is the period 12 debit budget.
Budget
FBD-CYPBUD12-CR Derived
Period 12 Credit This is the period 12 credit budget.
Budget
FBD-CYPBUD12 Derived
Period 12 Budget This is the period 12 budget.
FBD-CYPBUD13-DR Derived
Period 13 Debit This is the period 13 debit budget.
Budget
FBD-CYPBUD13-CR Derived
Period 13 Credit This is the period 13 credit budget.
Budget
FBD-CYPBUD13 Derived
Period 13 Budget This is the period 13 budget.
FBD-BLANK Derived
Blank This derived field is always blank. It
is used in drill around to allow column
headings.
FBD-UNT-BEG-BAL Derived
Unit Beginning This is the unit beginning balance.
Balance
FBD-UNTBUD1-DR Derived
Period 1 Debit Unit This is the period 1 debit budget unit.
FBD-UNTBUD1-CR Derived
Period 1 Credit Unit This is the period 1 credit budget unit.
FBD-UNTBUD1 Derived
Period 1 Unit This is the period 1 budget unit.
FBD-UNTBUD2-DR Derived
Period 2 Debit Unit This is the period 2 debit budget unit.
FBD-UNTBUD2-CR Derived
Period 2 Credit Unit This is the period 2 credit budget
unit.
FBD-UNTBUD2 Derived
Period 2 Unit This is the period 2 budget unit.
FBD-UNTBUD3-DR Derived
Period 3 Debit Unit This is the period 3 debit budget unit.
FBD-UNTBUD3-CR Derived
Period 3 Credit Unit This is the period 3 credit budget unit
FBD-UNTBUD3 Derived
Period 3 Unit This is the period 3 budget unit.
FBD-UNTBUD4-DR Derived
Period 4 Debit Unit This is the period 4 debit budget unit.
FBD-UNTBUD4-CR Derived
Period 4 Credit Unit This is the period 4 credit budget unit.
FBD-UNTBUD4 Derived
Period 4 Unit This is the period 4 budget unit.
FBD-UNTBUD5-DR Derived
Period 5 Debit Unit This is the period 5 debit budget unit.
FBD-UNTBUD5-CR Derived
Period 5 Credit Unit This is the period 5 credit budget
unit.
FBD-UNTBUD5 Derived
Period 5 Unit This is the period 5 budget unit.
FBD-UNTBUD6-DR Derived
Period 6 Debit Unit This is the period 6 debit budget unit.
FBD-UNTBUD6-CR Derived
Period 6 Credit Unit This is the period 6 credit budget unit.
FBD-UNTBUD6 Derived
Period 6 Unit This is the period 6 budget unit.
FBD-UNTBUD7-DR Derived
Period 7 Debit Unit This is the period 7 debit budget unit.
FBD-UNTBUD7-CR Derived
Period 7 Credit Unit This is the period 7 credit budget unit.
FBD-UNTBUD7 Derived
Period 7 Unit This is the period 7 budget unit.
FBD-UNTBUD8-DR Derived
Period 8 Debit Unit This is the period 8 debit budget unit.
FBD-UNTBUD8-CR Derived
Period 8 Credit Unit This is the period 8 credit budget unit.
FBD-UNTBUD8 Derived
Period 8 Unit This is the period 8 budget unit.
FBD-UNTBUD9-DR Derived
Period 9 Debit Unit This is the period 9 debit budget unit.
FBD-UNTBUD9-CR Derived
Period 9 Credit Unit This is the period 9 credit budget unit.
FBD-UNTBUD9 Derived
Period 9 Unit This is the period 9 budget unit.
FBD-UNTBUD10-DR Derived
Period 10 Debit Unit This is the period 10 debut budget unit.
FBD-UNTBUD10-CR Derived
Period 10 Credit This is the period 10 credit budget
Unit unit.
FBD-UNTBUD10 Derived
Period 10 Unit This is the period 10 budget unit.
FBD-UNTBUD11-DR Derived
Period 11 Debit Unit This is the period 11 debit budget
unit.
FBD-UNTBUD11-CR Derived
Period 11 Credit This is the period 11 credit budget
Unit unit.
FBD-UNTBUD11 Derived
Period 11 Unit This is the period 11 budget unit.
FBD-UNTBUD12-DR Derived
Period 12 Debit Unit This is the period 12 debit budget
unit.
FBD-UNTBUD12-CR Derived
Period 12 Credit This is the period 12 credit budget
Unit unit.
FBD-UNTBUD12 Derived
Period 12 Unit This is the period 12 budget unit.
FBD-UNTBUD13-DR Derived
Period 13 Debit Unit This is the period 13 debit budget unit.
FBD-UNTBUD13-CR Derived
Period 13 Credit This is the period 13 credit budget
Unit unit.
FBD-UNTBUD13 Derived
Period 13 Unit This is the period 13 budget unit.
FBDETAIL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBDSET1 COMPANY CA110 FB100
FISCAL-YEAR FB101 FB120
BUDGET-NBR FB121 FB122
ACCT-UNIT FB141 FB165
ACCOUNT FB195 FB20.1
SUB-ACCOUNT FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB220 FB295
FB30.1 FB700
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL110
GL295 GL300
GL500 GLOP.1
FBDSET2 FISCAL-YEAR CA195 FB100
BUDGET-NBR FB101 FB120
COMPANY FB121 FB195
VAR-LEVELS FB95.1 FB95.2
ACCOUNT FB95.3 FB95.4
SUB-ACCOUNT FB95.5 FB95.6
ACCT-UNIT GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
GL95.7 GL95.8
GL95.9 GL96.1
GL96.2 GL96.3
GL96.4 GL96.5
GL97.1 GL97.2
GL97.3 GL97.4
...
FBDSET3 COMPANY GL120 GL122
ACCT-UNIT GL500 GL20.2
ACCOUNT
SUB-ACCOUNT
BUDGET-NBR
FISCAL-YEAR
FBDSET4 COMPANY Subset FB100 FB230
FISCAL-YEAR Where COMPUTE-NAME != Spaces FB231 RW298
BUDGET-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FBDSET5 FISCAL-YEAR FB100 FB101
BUDGET-NBR FB231 FB295
COMPANY GL320 GLSV.1
ACCOUNT GLRV.1
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
FBDSET6 FISCAL-YEAR GLSV.1 GLRV.1
BUDGET-NBR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
FBDSET7 FISCAL-YEAR GLSV.1 GLRV.1
BUDGET-NBR
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
FBDSET8 COMPANY FB31.1 FB95.2
FISCAL-YEAR FB95.3
BUDGET-NBR
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FBDETAIL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
FBD-COMPANY -> GLM-COMPANY
FBD-ACCT-UNIT -> GLM-ACCT-UNIT
FBD-ACCOUNT -> GLM-ACCOUNT
FBD-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Acct Unit GLNAMES Required
FBD-COMPANY -> GLN-COMPANY
FBD-ACCT-UNIT -> GLN-ACCT-UNIT
Budget FBHEADER Required
FBD-COMPANY -> FBH-COMPANY
FBD-FISCAL-YEAR -> FBH-FISCAL-YEAR
FBD-BUDGET-NBR -> FBH-BUDGET-NBR
Chart Detail GLCHARTDTL Required
FBD-CHART-NAME -> GDT-CHART-NAME
FBD-ACCOUNT -> GDT-ACCOUNT
FBD-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
FBD-COMPANY -> GLS-COMPANY
Compute CMPUTE Not Required
FBD-COMPUTE-NAME -> CMP-COMPUTE-NAME
Fbspread FBSPREAD Not Required
FBD-COMPANY -> FBS-COMPANY
FBD-FISCAL-YEAR -> FBS-FISCAL-YEAR
FBD-SPREAD-CODE -> FBS-SPREAD-CODE
|