Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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