Lawson Insight Technical Documentation |
|
FBHEADER
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
AC191 AC40.4 AC41.4 AC42.1 AP125 AP126
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 API1.1
API2.1 BR41.4 CB10.1 CB191 CB20.1 CB30.1
CB500 EE135 EE35.1 EE35.2 EE520 CA10.1
CA10.2 CA10.6 CA10.7 CA110 FB11.1 FB111
FB145 FB190 FB195 FB211 FB220 FB225
FB230 FB231 FB240 FB25.1 FB295 FB296
FB30.1 FB31.1 FB65.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL146 GL165 GL170
GL293 GL294 GL295 GL298 GL320 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL65.1 GL75.1 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 RW70.1 IC222 GLOP.1 IFAC.1 MA41.2
MA41.7 MA43.2 MA61.1 MAI1.1 PO150 PO25.1
PO25.6 PO25.7 PO536 POIM.1 FB01.2 GL10.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 FB45.1 GL110
GL197 GL300 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBH-COMPANY Numeric 4 CA195 FB120
Element: Company This is the company number budgets are FB121 FB165
defined for. FB20.2 GL110
FBH-FISCAL-YEAR Numeric 4 CA195 FB120
Element: Fiscal Year This is the fiscal year budgets are FB121 FB165
defined in. FB20.2 GL500
FBH-BUDGET-NBR Numeric 3 CA195 FB120
Element: Budget This is the number that identifies the FB121 FB165
budget. FB20.2
FBH-VERSION Numeric 2 CA195 FB120
Element: Version This is the budget version number. FB121 FB165
FB20.2 GL110
FBH-USER-CLASS Alpha 12 FB20.2
Element: 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
Element: Maintenance DaThis 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
Element: Maintenance TiThis 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
Element: Calculation DaThis is the date the budget was last FB101 FB120
calculated. FB121 FB20.6
FB21.1
FBH-CALC-TIME Numeric 6 (hhmmss) CA195 FB100
Element: Calculation TiThis is the time the budget was last FB101 FB120
calculated. FB121 FB20.6
FB21.1
FBH-DESCRIPTION Alpha 30 (Lower Case) CA195 FB120
Element: Budget DescripThis is the budget description. FB121 FB165
FB20.2
FBH-BUD-TYPE Alpha 1 FB120 FB20.2
Element: Budget Type This field indicates the type of the
budget: computed or noncomputed.
C = Computed
" " = Not Computed
FBH-ALLOW-DEC Alpha 1 CA195 FB120
Element: Allow DecimalsY = Yes FB165 FB20.2
N = No
FBH-LOCK Alpha 1 CA195 FB120
Element: Lock This field indicates whether the budget FB121 FB165
FB20.2 GL110
is locked.
Y = Yes
N = No
FBH-COMMIT-BUD Alpha 1 CA195 FB120
Element: Commit Bud This is the Yes/No flag indicating FB121 FB165
whether this is the budget that GL FB20.2
commitments is edited against.
N = No
Y = Yes
FBH-DOUBLE-ENTRY Alpha 1 CA195 FB120
Element: Double Entry This is the Yes/No flag indicating FB121 FB165
whether this budget will be updated FB20.2
using FB20 or the double entry
functionality in FB40.
FBH-LAST-JE-USED Numeric 8 FB40.2 FB40.4
Element: Journal Entry This is the last journal number used by FB45.1 GL197
FB40.
FBHEADER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBHSET1 COMPANY AC191 AC40.4
FISCAL-YEAR AC41.4 AC42.1
BUDGET-NBR AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR41.4
CB10.1 CB191
CB20.1 CB30.1
CB500 EE135
EE35.1 EE35.2
EE520 CA10.1
...
FBHSET2 COMPANY FB25.1 GL110
BUDGET-NBR GL300 GL500
FISCAL-YEAR
FBHSET3 USER-CLASS KeyChange FB01.2
COMPANY
FISCAL-YEAR
BUDGET-NBR
FBHSET4 COMPANY Subset AC191 AC40.4
FISCAL-YEAR Where COMMIT-BUD = "Y" AC41.4 AC42.1
BUDGET-NBR AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR41.4
CB10.1 CB191
CB20.1 CB30.1
CB500 EE135
EE35.1 EE35.2
EE520 CA110
...
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
|