Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             FBFUNDHDR FILE

REFERENCED BY

FB211

UPDATED BY

FB11.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


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

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

FUH-ACCT-UNIT        Alpha 15                                    FB11.1
Accounting Unit      The 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
Acct Unit List

FUH-LEVEL-GROUP      Alpha 12                                    FB11.1
Level Group          This is a group of level ranges. The
                     level ranges do not need to be in
                     sequential order.

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

FUH-ACCOUNT-GROUP    Alpha 12                                    FB11.1
Account Group        A group of account ranges that need not
                     be in sequential order.

FUH-ACCOUNT-LIST     Alpha 12                                    FB11.1
Account List

FUH-SUB-ACCT-GRP     Alpha 12                                    FB11.1
Sub Acct Grp         This is a group of subaccount ranges.
                     The subaccount ranges do not need to be
                     in sequential order.

FUH-REBUILD-REQD     Alpha 1
Rebuild Reqd

                         FBFUNDHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

FUHSET2   FUND-GROUP
          COMPANY

                         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