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     FB195
FB220     FB225     FB230     FB231     FB25.1    FB295
FB30.1    FB31.1    FB65.1    FB95.1    FB95.2    FB95.3
FB95.4    FB95.5    FB95.6    GL293     GL294     GL295
GL320     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

UPDATED BY

CA195     FB100     FB101     FB120     FB121     FB122
FB165     FB20.1    FB20.2    FB20.3    FB20.4    FB20.6
FB20.7    FB21.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

                         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
                                                                 FB120   FB121
                                                                 FB122   FB165
                                                                 FB195   FB20.1
                                                                 FB20.2  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB220   FB225
                                                                 FB230   FB231
                                                                 FB25.1  FB295
                                                                 FB30.1  FB31.1
                                                                 FB65.1  FB95.1
                                                                 ...

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

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

                         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