FBDETAIL

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
FB10.1 FB11.1 FB111 FB141 FB160 FB195
FB211 FB215 FB220 FB295 FB296 FB35.1
FB42.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
FB95.1 GL122 GL167 GL190 GL191 GL295
GL298 GLBO.2 CU01.1 CU01.2 CU02.1 CU02.2
CU03.1 CU10.1 CU10.2 CU20.1 CU20.3 GL00.1
GL00.2 GL00.3 GL00.6 GL00.7 GL00.8 GL00.9
GL02.1 GL02.2 GL02.3 GL02.6 GL03.2 GL03.4
GL10.1 GL121 GL20.1 GL20.2 GL20.4 GLOP.1
FB60.1 GL299 GL90.6 GL94.1 GL94.2 GL94.3
GL94.4 GL94.5 GL94.6 GL94.7 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 ML94.1
ML94.2 ML94.3 ML94.4 ML95.1 ML95.2 ML95.3
ML95.4 ML95.5 ML95.6 ML95.7 ML95.8 ML95.9
ML96.1 ML96.2 ML96.3 ML96.4 ML96.5 ML97.1
ML97.2 ML97.3 ML97.4 ML97.5 ML97.6 ML97.7
ML97.8 ML97.9 ML98.1 ML98.2 ML98.3 ML98.4
ML98.5 ML99.1 ML99.2 ML99.3 ML99.4 ML99.5
ML99.6 AC191 AC40.4 AC41.4 AC42.1 BR41.4
BR44.1 CB222 GL165 GL65.1 IC222 EX545
IFAC.1 IFEB.1 ML165 ML65.1 POIK.1 POIM.1
FB230 FB231 RW298 GL320


UPDATED BY
AP125 AP126 AP131 AP170 AP190 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP510 AP520 API1.1 API2.1
ARLL.1 BN150 BN66.1 CB10.1 CB15.1 CB150
CB180 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 CB57.1
CB80.1 CB82.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
EE135 EE35.1 EE35.2 EE520 CA110 CA195
FB100 FB101 FB120 FB121 FB122 FB145
FB165 FB190 FB20.1 FB20.2 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 FB325
FB40.1 FB40.2 FB40.3 FB45.1 GL110 GL120
GL146 GL170 GL197 GL199 GL300 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL500 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 GL76.1 PR521 DR100 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 EX175 EX542
EXI2.1 EXI4.1 IFGT.1 IFUC.1 LP130 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PA182 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO135 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO18.1
PO190 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO220 PO222 PO224 PO225 PO229
PO23.1 PO230 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO26.2 PO26.3 PO26.4
PO26.5 PO26.6 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
POCP.1 POD0.1 POI3.1 POID.1 POIF.1 POII.1
POIJ.1 PR128 PR131 PR132 PR134 PR135
PR136 PR137 PR140 PR189 PR195 PR197
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR36.4 PR37.1 PR38.1
PR45.1 PR529 PR530 PR560 PR582 PR80.1
PR80.4 PR82.1 PR85.1 PR89.1 PRAT.1 UK102
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQD0.1 RQIB.1 RQIF.1 RQII.1
RQIJ.1 SNOP.1 SNRP.1 SNSP.1 TA147 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBD-COMPANY
Element: Company
Numeric 4
The company number you are defining budgets for.
CA110 CA195
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL197
GL199 GL500
GLSV.1 IFGT.1
RW298 RW80.1
SNRP.1 SNSP.1
FBD-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
This is the fiscal year you are defining budgets in.
CA110 CA195
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
IFGT.1 RW298
SNRP.1 SNSP.1
FBD-BUDGET-NBR
Element: Budget
Numeric 3
The number that identifies the budget.
CA110 CA195
FB100 FB101
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
IFGT.1 RW298
SNRP.1 SNSP.1
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.
CA110 CA195
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
IFGT.1 RW298
SNRP.1 SNSP.1
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.
CA110 CA195
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
IFGT.1 RW298
RW80.1 SNRP.1
SNSP.1
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.
CA110 CA195
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
IFGT.1 RW298
RW80.1 SNRP.1
SNSP.1
FBD-VAR-LEVELS
Element: Variable Level
Alpha 30
A variable level represents the location of an accounting unit in an organization's level structure.
CA110 CA195
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL120 GL197
GL199 GL500
GLSV.1 IFGT.1
SNRP.1 SNSP.1
FBD-DB-AMOUNT
Element: Debit Amount
Signed 18.2 Occurs 13 Times
This is the budget debit amount.
CA195 FB100
FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
SNOP.1 SNRP.1
SNSP.1
FBD-CR-AMOUNT
Element: Credit Amount
Signed 18.2 Occurs 13 Times
This is the budget credit amount.
CA195 FB100
FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
SNOP.1 SNRP.1
SNSP.1
FBD-DB-UNITS
Element: Auto Debits
Signed 15.2 Occurs 13 Times
The total positive detail auto reversing amounts.
CA195 FB100
FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
SNOP.1 SNRP.1
SNSP.1
FBD-CR-UNITS
Element: Auto Credits
Signed 15.2 Occurs 13 Times
The total negative detail auto reversing amounts.
CA195 FB100
FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
SNOP.1 SNRP.1
SNSP.1
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.
CA195 FB100
FB120 FB121
FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 GL500
GLSV.1
FBD-MAINT-DATE
Element: Maintenance Date
Numeric 8 (yyyymmdd)
The last date the budget was maintained.
CA195 FB100
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
IFGT.1 SNOP.1
SNRP.1 SNSP.1
FBD-MAINT-TIME
Element: Maintenance Time
Numeric 6 (hhmmss)
The last time the budget was maintained.
CA195 FB100
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
IFGT.1 SNOP.1
SNRP.1 SNSP.1
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.
CA110 CA195
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
IFGT.1 SNRP.1
SNSP.1
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.
CA195 FB120
FB121 FB165
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
GL500 GLSV.1
FBD-DB-BEG-BAL
Debit Beginning
Balance
Signed 18.2
This is the debit beginning balance.
CA195 FB101
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL199 GL500
GLSV.1
FBD-CR-BEG-BAL
Credit Beginning
Balance
Signed 18.2
This is the credit beginning balance.
CA195 FB101
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL199 GL500
GLSV.1
FBD-DB-BEG-BAL-UNT
Element: Intl Amt
Signed 18.2
FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
FBD-CR-BEG-BAL-UNT
Element: Intl Amt
Signed 18.2
FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500 GLSV.1
FBD-BEG-BAL-FACTOR
Element: Factor
Alpha 15
The element that affects the budget change.
CA195 FB120
FB121 FB165
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FBD-BEG-BAL-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
CA195 FB101
FB120 FB121
FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1
FBD-FACTOR
Element: Factor
Alpha 15 Occurs 13 Times
The global factor defined in FB00.1 (Global Factors).
FB100 FB120
FB121 FB165
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
GL500 SNOP.1
SNRP.1 SNSP.1
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.
FB101 FB120
FB121 FB165
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
GL500 SNOP.1
SNRP.1 SNSP.1
FBD-PARENT-VAR-LEV
Element: Parent Var Lev
Alpha 30
The variable level address of the parent accounting unit.
CA110 CA195
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB325
FB40.1 FB40.2
FB40.3 FB45.1
GL120 GL197
GL199 GL500
IFGT.1 SNRP.1
SNSP.1
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
...
AP125 AP126
AP131 AP170
AP190 AP193
AP21.1 AP23.1
AP26.1 AP27.1
AP510 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB150
CB180 CB191
CB500 CB543
CB544 CB554
CB57.1 CX100
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE520
EX175 EX542
EXI2.1 EXI4.1
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL170
GL197 GL199
GL500 GL75.1
IC140 IC141
IC142 IC145
IC243 IC330
IC83.1 IFGT.1
IFUC.1 LP130
FBD-ROLLOVER-BAL
Element: Intl Amt
Signed 18.2
...
AP125 AP126
AP131 AP170
AP190 AP193
AP21.1 AP23.1
AP26.1 AP27.1
AP510 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB150
CB180 CB191
CB500 CB543
CB544 CB554
CB57.1 CX100
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE520
EX175 EX542
EXI2.1 EXI4.1
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL170
GL197 GL199
GL500 GL75.1
IC140 IC141
IC142 IC145
IC243 IC330
IC83.1 IFGT.1
IFUC.1 LP130
FBD-BUD-ACT-AMT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
FB325 GL110
GL146 GL197
GL199 GL44.1
GL500 IFGT.1
FBD-FUTURE-BUD-ACT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
FB325 GL110
GL146 GL197
GL44.1 GL500
IFGT.1


FBDETAIL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBDSET1 COMPANY
FISCAL-YEAR
BUDGET-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
FBDSET2 FISCAL-YEAR
BUDGET-NBR
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
KeyChange
...
CA195 FB100
FB101 FB11.1
FB111 FB120
FB121 FB160
FB195 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL299
GL90.6 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
FBDSET3 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
BUDGET-NBR
FISCAL-YEAR
...
AC191 AC40.4
AC41.4 AC42.1
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP510
AP520 API1.1
API2.1 BR41.4
BR44.1 CB10.1
FBDSET4 COMPANY
FISCAL-YEAR
BUDGET-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
Subset
WhereCOMPUTE-NAME !=Spaces
FB100 FB230
FB231 RW298
FBDSET5 FISCAL-YEAR
BUDGET-NBR
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
KeyChange
FB100 FB101
FB231 FB295
GL320 GLSV.1
GLRV.1
FBDSET6 FISCAL-YEAR
BUDGET-NBR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
KeyChange
GLSV.1 GLRV.1
FBDSET7 FISCAL-YEAR
BUDGET-NBR
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
KeyChange
GLSV.1 GLRV.1
FBDSET8 COMPANY
FISCAL-YEAR
BUDGET-NBR
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FB31.1 FB95.2
FB95.3
FBDSET9 PARENT-VAR-LEV
FISCAL-YEAR
BUDGET-NBR
COMPANY
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT


FBDETAIL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
FBD-COMPANY->GLM-COMPANY (GLMSET2)
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
Fbdtlbod FBDTLBOD Not Required, Delete Cascades
FBD-COMPANY->YBQ-COMPANY
FBD-FISCAL-YEAR->YBQ-FISCAL-YEAR
FBD-BUDGET-NBR->YBQ-BUDGET-NBR
FBD-ACCT-UNIT->YBQ-ACCT-UNIT
FBD-ACCOUNT->YBQ-ACCOUNT
FBD-SUB-ACCOUNT->YBQ-SUB-ACCOUNT
Fbspread FBSPREAD Not Required
FBD-COMPANY->FBS-COMPANY
FBD-FISCAL-YEAR->FBS-FISCAL-YEAR
FBD-SPREAD-CODE->FBS-SPREAD-CODE


FBDETAIL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Bud Unt Parent GLCONSOL
FBD-PARENT-VAR-LEV->GCN-VAR-LEVELS
"N"->GCN-TRANS-TYPE
FBD-COMPANY->GCN-COMPANY
FBD-ACCOUNT->GCN-ACCOUNT
FBD-SUB-ACCOUNT->GCN-SUB-ACCOUNT
FBD-FISCAL-YEAR->GCN-FISCAL-YEAR
FBD-BUDGET-NBR->GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE
Budget Parent GLCONSOL
FBD-PARENT-VAR-LEV->GCN-VAR-LEVELS
"B"->GCN-TRANS-TYPE
FBD-COMPANY->GCN-COMPANY
FBD-ACCOUNT->GCN-ACCOUNT
FBD-SUB-ACCOUNT->GCN-SUB-ACCOUNT
FBD-FISCAL-YEAR->GCN-FISCAL-YEAR
FBD-BUDGET-NBR->GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE
Fbbatrans FBBATRANS
FBD-COMPANY->FBT-COMPANY
FBD-FISCAL-YEAR->FBT-FISCAL-YEAR
FBD-BUDGET-NBR->FBT-BUDGET-NBR
FBD-ACCT-UNIT->FBT-ACCT-UNIT
FBD-ACCOUNT->FBT-ACCOUNT
FBD-SUB-ACCOUNT->FBT-SUB-ACCOUNT
  FBT-UNIQUE-I-D
Fbdetailau FBDETAILAU
FBD-COMPANY->FDA-COMPANY
FBD-FISCAL-YEAR->FDA-FISCAL-YEAR
FBD-BUDGET-NBR->FDA-BUDGET-NBR
FBD-ACCT-UNIT->FDA-ACCT-UNIT
FBD-ACCOUNT->FDA-ACCOUNT
FBD-SUB-ACCOUNT->FDA-SUB-ACCOUNT
  FDA-ACTION
  FDA-DATE
  FDA-TIME
  FDA-UNIQUE-I-D
Fbtrans FBTRANS
FBD-COMPANY->FLT-TO-COMPANY
FBD-FISCAL-YEAR->FLT-FISCAL-YEAR
FBD-BUDGET-NBR->FLT-BUDGET-NBR
FBD-ACCT-UNIT->FLT-ACCT-UNIT
FBD-ACCOUNT->FLT-ACCOUNT
FBD-SUB-ACCOUNT->FLT-SUB-ACCOUNT
  FLT-OBJ-ID
Glcommitx GLCOMMITX
FBD-COMPANY->GOX-COMPANY
FBD-ACCT-UNIT->GOX-ACCT-UNIT
FBD-ACCOUNT->GOX-ACCOUNT
FBD-SUB-ACCOUNT->GOX-SUB-ACCOUNT
FBD-FISCAL-YEAR->GOX-FISCAL-YEAR
  GOX-PERIOD
  GOX-SYSTEM
  GOX-CURRENCY-CODE
  GOX-GLT-OBJ-ID
Gltrans GLTRANS
FBD-COMPANY->GLT-TO-COMPANY
FBD-ACCOUNT->GLT-ACCOUNT
FBD-SUB-ACCOUNT->GLT-SUB-ACCOUNT
FBD-ACCT-UNIT->GLT-ACCT-UNIT
FBD-FISCAL-YEAR->GLT-FISCAL-YEAR
  GLT-ACCT-PERIOD
  GLT-SYSTEM
  GLT-CONTROL-GROUP
  GLT-JE-TYPE
  GLT-JE-SEQUENCE
  GLT-LINE-NBR
  GLT-COMPANY


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

Home
Contact Us



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