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
CA10.1 CA10.2 CA10.6 CA10.7 FB141 FB195
FB215 FB220 FB240 FB295 FB30.1 FB65.1
GL167 GL190 GL191 GL293 GL294 GL295
RW70.1 GLOP.1 SN01.1 SNGL.1


UPDATED BY
CA195 FB100 FB101 FB120 FB121 FB122
FB165 FB20.1 FB20.2 FB20.3 FB20.4 FB20.6
FB20.7 FB21.1 FB40.2 FB40.4 FB40.1 FB40.3
FB45.1 GL110 GL197 GL199 GL300 GL500
IFGT.1 SNOP.1 SNRP.1 SNSP.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 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 EE135 EE35.1
EE35.2 EE520 CA110 FB11.1 FB111 FB145
FB160 FB190 FB211 FB225 FB230 FB231
FB25.1 FB296 FB31.1 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL146 GL165
GL170 GL298 GL299 GL320 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 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 EX545 IFAC.1 IFEB.1 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MAI1.1 PO136 PO190 PO300
PO520 POCP.1 POI3.1 POII.1 POIJ.1 POIM.1
FB01.2 FB325 GL10.1

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 ).
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
...
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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
CB30.1 CB45.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"
...
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
CB10.1 CB15.1
CB15.2 CB150
CB191 CB20.1
CB30.1 CB45.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: Wed Jun 08 20:48:37 2016

Home
Contact Us



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