FBHEADER

Budget Header

The Budgeting Header file is used to control the processing of the Budgeting system. Processing control information is keyed by fiscal year and budget number.

REFERENCED BY
AC527 CA10.1 CA10.2 CA10.6 CA10.7 FB220
GL167 GL190 GL293 CU01.1 CU01.2 CU02.1
CU02.2 CU03.1 CU10.1 CU10.2 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 GL20.1
GL20.2 GL20.4 FB141 FB195 FB215 FB225
FB230 FB231 FB240 FB25.1 FB295 FB30.1
FB31.1 FB65.1 GL191 GL294 GL295 GL320
RW70.1 GLOP.1 ML293 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 SN01.1
SNGL.1 FB01.2 FB325


UPDATED BY
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 AP520
API1.1 API2.1 BR41.4 BR44.1 CB10.1 CB15.1
CB15.2 CB150 CB191 CB20.1 CB222 CB30.1
CB45.1 CB46.1 CB500 CB543 CB544 CB55.1
CB554 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 FB11.1 FB111 FB120 FB121 FB122
FB145 FB160 FB165 FB190 FB20.1 FB20.2
FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB211
FB296 FB40.1 FB40.2 FB40.3 FB40.4 FB45.1
FB60.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 GL110 GL146 GL165 GL170 GL197
GL199 GL298 GL299 GL300 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GL65.1 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 GL76.1 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 DR100 IC140 IC141 IC142
IC222 IC66.1 IC83.1 EX545 GL10.1 IFAC.1
IFEB.1 IFGT.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
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 ML165 ML65.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO28.2 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 POI3.1 POID.1
POII.1 POIJ.1 POIK.1 POIM.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1 SNOP.1
SNRP.1 SNSP.1 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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBH-COMPANY
Element: Company		Numeric 4
This is the company number budgets are defined for.
CA195 FB120
FB121 FB165
FB20.2 GL110
GL199 IFGT.1
FBH-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
This is the fiscal year budgets are defined in.
CA195 FB120
FB121 FB165
FB20.2 GL199
GL500 IFGT.1
FBH-BUDGET-NBR
Element: Budget		Numeric 3
This is the number that identifies the budget.
CA195 FB120
FB121 FB165
FB20.2 GL199
IFGT.1
FBH-VERSION
Element: Version		Numeric 2
This is the budget version number.
CA195 FB120
FB121 FB165
FB20.2 GL110
GL199 IFGT.1
FBH-USER-CLASS
Element: User Class		Alpha 12
This is the user class assigned to the budget that limits the users that have access to modify the budget.
FB20.2
FBH-MAINT-DATE
Element: Maintenance Date		Numeric 8 (yyyymmdd)
This is the last date the budget was maintained.
CA195 FB100
FB101 FB120
FB121 FB165
FB20.1 FB20.2
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 GL199
IFGT.1 SNOP.1
SNRP.1 SNSP.1
FBH-MAINT-TIME
Element: Maintenance Time		Numeric 6 (hhmmss)
This is the last time the budget was maintained.
CA195 FB100
FB101 FB120
FB121 FB165
FB20.1 FB20.2
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 GL199
IFGT.1 SNOP.1
SNRP.1 SNSP.1
FBH-CALC-DATE
Element: Calculation Date		Numeric 8 (yyyymmdd)
This is the date the budget was last calculated.
CA195 FB100
FB101 FB120
FB121 FB20.6
FB21.1
FBH-CALC-TIME
Element: Calculation Time		Numeric 6 (hhmmss)
This is the time the budget was last calculated.
CA195 FB100
FB101 FB120
FB121 FB20.6
FB21.1
FBH-DESCRIPTION
Element: Budget Description		Alpha 30 (Lower Case)
This is the budget description.
CA195 FB120
FB121 FB165
FB20.2 GL199
IFGT.1
FBH-BUD-TYPE
Element: Bud Type		Alpha 1
This field indicates the type of the budget: computed or noncomputed.
C = Computed
" " = Not Computed
FB120 FB20.2
GL199 IFGT.1
FBH-ALLOW-DEC
Element: Allow Decimals		Alpha 1

Y = Yes
N = No
CA195 FB120
FB165 FB20.2
GL199 IFGT.1
FBH-LOCK
Element: Lock		Alpha 1
This field indicates whether the budget is locked.
Y = Yes
N = No
CA195 FB120
FB121 FB165
FB20.2 GL110
FBH-COMMIT-BUD
Element: Commit Bud		Alpha 1
This is the Yes/No flag indicating whether this is the budget that GL commitments is edited against.
N = No
Y = Yes
CA195 FB120
FB121 FB165
FB20.2 GL199
IFGT.1
FBH-DOUBLE-ENTRY
Element: Double Entry		Alpha 1
This is the Yes/No flag indicating whether this budget will be updated using FB20 or the double entry functionality in FB40.
CA195 FB120
FB121 FB165
FB20.2 GL199
IFGT.1
FBH-LAST-JE-USED
Element: Je Nbr		Numeric 8
This is the last journal number used by FB40.
FB40.2 FB40.4
FB45.1 GL197
GL199 GL500
FBH-LST-IC-JE-NBR
Element: Lst Ic Je Nbr		Numeric 4
This is the last journal number used by FB40 for intercompany journal entries.
FB40.2 FB40.4
GL500
FBH-LST-IB-JE-NBR
Element: Lst Ib Je Nbr		Numeric 8
This is the last journal number used by FB40 for Interbudget journal entries.
FB40.2 FB40.4
GL500
FBH-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
CA195 FB120
FB141 FB165
FB195 FB20.2
FB295 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL199
IFGT.1
FBH-ALLOW-UNIT-DEC
Element: All Flag		Alpha 1

Y = Yes
N = No
CA195 FB120
FB165 FB20.2
GL199 IFGT.1


FBHEADER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBHSET1 COMPANY
FISCAL-YEAR
BUDGET-NBR
...
AC191 AC40.4
AC41.4 AC42.1
AC527 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
AP520 API1.1
API2.1 BR41.4
BR44.1 CB10.1
FBHSET2 COMPANY
BUDGET-NBR
FISCAL-YEAR
FB25.1 GL110
GL300 GL500
FBHSET3 USER-CLASS
COMPANY
FISCAL-YEAR
BUDGET-NBR
KeyChange
FB01.2
FBHSET4 COMPANY
FISCAL-YEAR
BUDGET-NBR
Subset
WhereCOMMIT-BUD ="Y"
...
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 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1


FBHEADER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
FBH-COMPANY->GLS-COMPANY
Cucodes CUCODES Required
FBH-CURRENCY-CODE->CUC-CURRENCY-CODE


FBHEADER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Budget Detail FBDETAIL
FBH-COMPANY->FBD-COMPANY
FBH-FISCAL-YEAR->FBD-FISCAL-YEAR
FBH-BUDGET-NBR->FBD-BUDGET-NBR
  FBD-ACCT-UNIT
  FBD-ACCOUNT
  FBD-SUB-ACCOUNT
Curelat CURELAT
GLS-CURRENCY-TABLE->CRL-CURRENCY-TABLE
FBH-CURRENCY-CODE->CRL-FR-CURR-CODE
  CRL-TO-CURR-CODE

File created: Thu Jun 09 11:13:05 2016

Home
Contact Us



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