Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBFUNDHDR


                             FBFUNDHDR FILE

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

UPDATED BY

FB11.1    GL110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FUH-COMPANY            Numeric 4                                 FB11.1  GL110
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

FUH-FUND-GROUP         Alpha 15                                  FB11.1
Element: Fund Group

FUH-DESCRIPTION        Alpha 30  (Lower Case)                    FB11.1
Element: Description   This field displays the description.

FUH-ACCT-UNIT          Alpha 15                                  FB11.1
Element: Accounting UniThe accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


FUH-ACCT-UNIT-LIST     Alpha 12                                  FB11.1
Element: Acct Unit List

FUH-LEVEL-GROUP        Alpha 12                                  FB11.1
Element: Company Group

FUH-SUMMARY-ACCT       Alpha 12                                  FB11.1
Element: Summary Account

FUH-ACCOUNT-GROUP      Alpha 12                                  FB11.1
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
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
Element: Account Group 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).

FUH-REBUILD-REQD       Alpha 1
Element: Rebuild Reqd  Not used.

                         FBFUNDHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

FUHSET2   FUND-GROUP                                             FB11.1  FB111
          COMPANY                                                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

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