FBHEADER FILE
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.7 CA10.8 CA110 FB195
FB220 FB225 FB230 FB231 FB25.1 FB295
FB30.1 FB31.1 FB65.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL293 GL294 GL295
GL320 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 RW70.1
GLOP.1 FB01.2
UPDATED BY
CA195 FB100 FB101 FB120 FB121 FB122
FB165 FB20.1 FB20.2 FB20.3 FB20.4 FB20.6
FB20.7 FB21.1 FB700 GL110 GL300 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBH-COMPANY Numeric 4 CA195 FB120
Company This is the company number budgets are FB121 FB165
defined for. FB20.2 GL110
FBH-FISCAL-YEAR Numeric 4 CA195 FB120
Fiscal Year This is the fiscal year budgets are FB121 FB165
defined in. FB20.2 GL500
FBH-BUDGET-NBR Numeric 3 CA195 FB120
Budget This is the number that identifies the FB121 FB165
budget. FB20.2
FBH-VERSION Numeric 2 CA195 FB120
Version This is the budget version number. FB121 FB165
FB20.2 GL110
FBH-USER-CLASS Alpha 12 FB20.2
User Class This is the user class assigned to the
budget that limits the users that have
access to modify the budget.
FBH-MAINT-DATE Numeric 8 (yyyymmdd) CA195 FB100
Maintenance Date This is the last date the budget was FB101 FB120
maintained. FB121 FB165
FB20.1 FB20.2
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1
FBH-MAINT-TIME Numeric 6 (hhmmss) CA195 FB100
Maintenance Time This is the last time the budget was FB101 FB120
maintained. FB121 FB165
FB20.1 FB20.2
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1
FBH-CALC-DATE Numeric 8 (yyyymmdd) CA195 FB100
Calculation Date This is the date the budget was last FB101 FB120
calculated. FB121 FB20.6
FB21.1
FBH-CALC-TIME Numeric 6 (hhmmss) CA195 FB100
Calculation Time This is the time the budget was last FB101 FB120
calculated. FB121 FB20.6
FB21.1
FBH-DESCRIPTION Alpha 30 (Lower Case) CA195 FB120
Budget Description This is the budget description. FB121 FB165
FB20.2
FBH-BUD-TYPE Alpha 1 CA195 FB120
Budget Type This field indicates the type of the FB20.2
budget: computed or noncomputed.
C = Computed
" " = Not Computed
FBH-ALLOW-DEC Alpha 1 CA195 FB120
Allow Decimals This field determines whether to allow FB165 FB20.2
decimals in the budget.
If you change the value to No at a later
date, budget amounts can change due to
rounding.
Y = Yes
N = No
FBH-LOCK Alpha 1 CA195 FB120
Lock This field indicates whether the budget FB121 FB165
is locked. FB20.2 GL110
Y = Yes
N = No
FBH-UNITS-CODE Alpha 1 FB700
Units Code This field determines whether the
budget is in amounts or units.
FBHEADER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBHSET1 COMPANY CA10.1 CA10.2
FISCAL-YEAR CA10.7 CA10.8
BUDGET-NBR CA110 CA195
FB100 FB101
FB120 FB121
FB122 FB165
FB195 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB220 FB225
FB230 FB231
FB25.1 FB295
FB30.1 FB31.1
FB65.1 FB700
...
FBHSET2 COMPANY FB25.1 GL300
BUDGET-NBR GL500
FISCAL-YEAR
FBHSET3 USER-CLASS KeyChange FB01.2
COMPANY
FISCAL-YEAR
BUDGET-NBR
FBHEADER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
FBH-COMPANY -> GLS-COMPANY
FBHEADER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|