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
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 BR41.4
BR44.1 CB10.1 CB15.1 CB15.2 CB191 CB20.1
CB30.1 CB500 EE135 EE35.1 EE35.2 EE520
CA10.1 CA10.2 CA10.6 CA10.7 CA110 FB11.1
FB111 FB141 FB145 FB160 FB190 FB195
FB211 FB220 FB225 FB230 FB231 FB240
FB25.1 FB295 FB296 FB30.1 FB31.1 FB60.1
FB65.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 GL146 GL165 GL167 GL170 GL190
GL191 GL199 GL293 GL294 GL295 GL298
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 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 RW70.1 IC222 GLOP.1
IFAC.1 IFGT.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 DecimalsThis 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
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.
FBH-LST-IC-JE-NBR Numeric 4 FB40.2 FB40.4
Element: Lst Ic Je Nbr This is the last journal number used by
FB40 for intercompany journal entries.
FBH-LST-IB-JE-NBR Numeric 8 FB40.2 FB40.4
Element: Lst Ib Je Nbr This is the last journal number used by
FB40 for Interbudget journal entries.
FBH-CURRENCY-CODE Alpha 5 FB120 FB141
Element: Currency Code This field contains the company base FB165 FB195
currency code established in Company FB20.2 FB295
(GL10.1 ). FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 BR41.4
BR44.1 CB10.1
CB15.1 CB15.2
CB191 CB20.1
CB30.1 CB500
EE135 EE35.1
EE35.2 EE520
CA10.1 CA10.2
CA10.6 CA10.7
CA110 CA195
...
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 BR41.4
BR44.1 CB10.1
CB15.1 CB15.2
CB191 CB20.1
CB30.1 CB500
EE135 EE35.1
EE35.2 EE520
CA110 FB11.1
FB111 FB145
FB160 FB190
...
FBHEADER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 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
Curelat CURELAT
GLS-CURRENCY-TABLE -> CRL-CURRENCY-TABLE
FBH-CURRENCY-CODE -> CRL-FR-CURR-CODE
CRL-TO-CURR-CODE
|