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 AC527 AP125
AP126 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 AP520 API1.1
API2.1 BR41.4 BR44.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 CA10.1 CA10.2 CA10.6
CA10.7 CA110 FB11.1 FB111 FB141 FB145
FB160 FB190 FB195 FB211 FB215 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 GLOP.1 IFAC.1 IFGT.1 MA41.1
MA41.2 MA41.4 MA41.7 MA43.2 MA61.1 MAI1.1
PO150 PO25.1 PO25.6 PO25.7 PO536 POIM.1
RQ10.1 RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ500
RQIB.1 RQIF.1 RQIJ.1 SN01.1 SNGL.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 SNOP.1 SNRP.1 SNSP.1
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 SNOP.1
SNRP.1 SNSP.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 SNOP.1
SNRP.1 SNSP.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: Bud 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: Je Nbr This is the last journal number used by FB45.1 GL197
FB40. GL500
FBH-LST-IC-JE-NBR Numeric 4 FB40.2 FB40.4
Element: Lst Ic Je Nbr This is the last journal number used by GL500
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 GL500
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 AC527 AP125
AP126 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
AP520 API1.1
API2.1 BR41.4
BR44.1 CB10.1
CB15.1 CB15.2
...
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
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 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1
CB15.2 CB150
...
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
|