Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBFUNDHDR


                             FBFUNDHDR FILE

                           Budget Fund Header

The Budget Edit Group Header file contains the parameter information
maintained in FB11 which is used in the build of the budget edit group
detail (FBFUNDDTL).

REFERENCED BY

FB111     FB211     FB60.1

UPDATED BY

FB11.1    FB160     GL110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FUH-COMPANY            Numeric 4                                 FB11.1  FB160
Element: Company       The company number represents an          GL110
                       established General Ledger company.

FUH-FUND-GROUP         Alpha 15                                  FB11.1  FB160
Element: Fund Group    The Budget Edit Group established in
                       FB11 represents a set of accounting
                       units and accounts that are grouped
                       together for budget editing purposes.

FUH-DESCRIPTION        Alpha 30  (Lower Case)                    FB11.1  FB160
Element: Description   The Budget Edit Group description.

FUH-ACCT-UNIT          Alpha 15                                  FB11.1  FB160
Element: Acct Unit     An Accounting Unit, List or Level Group
                       is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FUH-ACCT-UNIT-LIST     Alpha 12                                  FB11.1  FB160
Element: Acct Unit ListAn Accounting Unit, List or Level Group
                       is required. The value is used to build
                       the members of the group (FBFUNDDTL).

FUH-LEVEL-GROUP        Alpha 12                                  FB11.1  FB160
Element: Level Group   The Accounting Unit, List or Level Group
                       is required.
                       The value is used to build members of
                       the group (FBFUNDDTL).

FUH-SUMMARY-ACCT       Alpha 12                                  FB11.1  FB160
Element: Summary Acct  A Summary Account, List or Account Group
                       is required. The value is used to build
                       the members of the group (FBFUNDDTL).

FUH-ACCOUNT-GROUP      Alpha 12                                  FB11.1  FB160
Element: Account Group A Summary Account, List or Account Group
                       is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FUH-ACCOUNT-LIST       Alpha 12                                  FB11.1  FB160
Element: Account List  A Summary Account, List or Account Group
                       is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FUH-SUB-ACCT-GRP       Alpha 12                                  FB11.1  FB160
Element: Sub Acct Grp  The Subaccount Group is not required. If
                       a value is entered, the specified
                       subaccounts will be included in  the
                       detail members.  If the value is
                       blank, only major accounts will be
                       included in the members (FBFUNDDTL).

                         FBFUNDHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FUHSET1   COMPANY                                                FB11.1  FB11.2
          FUND-GROUP                                             FB111   FB160
                                                                 FB211   FB60.1
                                                                 GL110

FUHSET2   FUND-GROUP                                             FB11.1  FB111
          COMPANY                                                FB160   FB211

                         FBFUNDHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account Group  RWHEADER     Required
                            When FUH-ACCOUNT-GROUP != Spaces

                            "G"                   -> RWH-HEAD-TYPE
                            FUH-ACCOUNT-GROUP     -> RWH-HEAD-NAME
                            "A"                   -> RWH-RECORD-TYPE

Acct Unit      GLNAMES      Not Required

                            FUH-COMPANY           -> GLN-COMPANY
                            FUH-ACCT-UNIT         -> GLN-ACCT-UNIT

Company        GLSYSTEM     Not Required

                            FUH-COMPANY           -> GLS-COMPANY

Glchartsum     GLCHARTSUM   Not Required

                            GLS-CHART-NAME        -> GCS-CHART-NAME
                            FUH-SUMMARY-ACCT      -> GCS-SUMMARY-ACCT

Level Group    RWHEADER     Not Required

                            "G"                   -> RWH-HEAD-TYPE
                            FUH-LEVEL-GROUP       -> RWH-HEAD-NAME
                            "L"                   -> RWH-RECORD-TYPE

Mxlisthdr      MXLISTHDR    Not Required

                            "ACCTU"               -> MLH-OBJ-TYPE
                            FUH-ACCT-UNIT-LIST    -> MLH-MATRIX-LIST

Mxlisthdr2     MXLISTHDR    Not Required

                            "ACCNT"               -> MLH-OBJ-TYPE
                            FUH-ACCOUNT-LIST      -> MLH-MATRIX-LIST

Subacct Group  RWHEADER     Required
                            When FUH-SUB-ACCT-GRP != Spaces

                            "G"                   -> RWH-HEAD-TYPE
                            FUH-SUB-ACCT-GRP      -> RWH-HEAD-NAME
                            "S"                   -> RWH-RECORD-TYPE

                         FBFUNDHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Grp Det   RWGRPDET

                            "A"                   -> RGD-RECORD-TYPE
                            FUH-ACCOUNT-GROUP     -> RGD-HEAD-NAME
                                                     RGD-RANGE-NUMBER

Fbfundamt      FBFUNDAMT

                            FUH-COMPANY           -> FBB-COMPANY
                            FUH-FUND-GROUP        -> FBB-FUND-GROUP
                                                     FBB-FISCAL-YEAR

Fbfunddtl      FBFUNDDTL

                            FUH-COMPANY           -> FUD-COMPANY
                            FUH-FUND-GROUP        -> FUD-FUND-GROUP
                                                     FUD-ACCT-UNIT
                                                     FUD-ACCOUNT
                                                     FUD-SUB-ACCOUNT

Fbfundhdr      FBFUNDHDR

                            FUH-FUND-GROUP        -> FUH-FUND-GROUP
                                                     FUH-COMPANY