Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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.6    CA10.7    CA110     FB11.1
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    GL293     GL294     GL295     GL298
GL320     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    FB01.2    AC191     AP125     AP126
AP25.1    AP25.2    AP26.1    AP27.1    CB10.1    CB191
CB20.1    CB30.1    CB500     EE135     EE35.1    EE35.2
EE520     GL146     GL165     GL170     GL197     GL40.1
GL40.2    GL40.3    GL40.7    GL40.8    GL44.1    GL45.1
GL65.1    GL75.1    IC222     GL10.1    IFAC.1    POIM.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
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                                     FB120   FB20.2
Budget Type          This field indicates the type of the
                     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
                                                                 FB20.2  GL110
                     is locked.
                     Y = Yes
                     N = No

FBH-COMMIT-BUD       Alpha 1                                     CA195   FB120
Commit Bud           N = No                                      FB121   FB165
                     Y = Yes                                     FB20.2

FBH-DOUBLE-ENTRY     Alpha 1                                     CA195   FB120
Double Entry                                                     FB121   FB165
                                                                 FB20.2

FBH-LAST-JE-USED     Numeric 8                                   FB40.2  FB40.4
Last JE Number Used                                              FB45.1  GL110

                         FBHEADER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FBHSET1   COMPANY                                                CA10.1  CA10.2
          FISCAL-YEAR                                            CA10.6  CA10.7
          BUDGET-NBR                                             CA110   CA195
                                                                 FB100   FB101
                                                                 FB11.1  FB120
                                                                 FB121   FB122
                                                                 FB165   FB190
                                                                 FB195   FB20.1
                                                                 FB20.2  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB220
                                                                 FB225   FB230
                                                                 FB231   FB240
                                                                 FB25.1  FB295
                                                                 ...

FBHSET2   COMPANY                                                FB25.1  GL110
          BUDGET-NBR                                             GL300   GL500
          FISCAL-YEAR

FBHSET3   USER-CLASS                                             FB01.2
          COMPANY
          FISCAL-YEAR
          BUDGET-NBR

FBHSET4   COMPANY       Subset                                   AC191   AP125
          FISCAL-YEAR   Where COMMIT-BUD = "Y"                   AP126   AP25.1
          BUDGET-NBR                                             AP25.2  AP26.1
                                                                 AP27.1  CB10.1
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 CA110   FB11.1
                                                                 FB190   FB211
                                                                 FB296   FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  FB95.1
                                                                 FB95.2  FB95.3
                                                                 FB95.4  FB95.5
                                                                 ...

                         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