FBFUNDHDR – Budget Fund Header

System
General Ledger (GL)
Prefix
FUH
Primary key
COMPANY, FUND-GROUP
Fields
10
Updated by
3 programs
Referenced by
90 programs

FBFUNDHDR is the Budget Fund Header table in Lawson General Ledger (prefix FUH). It is indexed by COMPANY, FUND-GROUP (FUHSET1); alternate indexes: FUHSET2. It is related 1:1 to RWHEADER, GLNAMES, GLSYSTEM, GLCHARTSUM and MXLISTHDR and 1:M to RWGRPDET, FBFNDHDRAU, FBFUNDAMT, FBFUNDDTL and FBFUNDHDR. It is updated by FB11.1, FB160 and GL110 and referenced by CA110, CA195, FB10.1, FB100, FB101, FB111, FB120, FB121 and 82 more. The table has 10 fields, 2 indexes and 13 documented relations.

About FBFUNDHDR

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).

Fields (10)

Column = COBOL field name without the FUH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#FUH-COMPANY PK
COMPANY		Numeric 4The company number represents an established General Ledger company.FB11.1, FB160, GL110
#FUH-FUND-GROUP PK
FUND_GROUP		Alpha 15The Budget Edit Group established in FB11 represents a set of accounting units and accounts that are grouped together for budget editing purposes.FB11.1, FB160
#FUH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The Budget Edit Group description.FB11.1, FB160
#FUH-ACCT-UNIT
ACCT_UNIT		Alpha 15An Accounting Unit, List or Level Group is required. The value is used to build the members of the group (FBFUNDDTL).FB11.1, FB160
#FUH-ACCT-UNIT-LIST
ACCT_UNIT_LIST		Alpha 12An Accounting Unit, List or Level Group is required. The value is used to build the members of the group (FBFUNDDTL).FB11.1, FB160
#FUH-LEVEL-GROUP
LEVEL_GROUP		Alpha 12The Accounting Unit, List or Level Group is required. The value is used to build members of the group (FBFUNDDTL).FB11.1, FB160
#FUH-SUMMARY-ACCT
SUMMARY_ACCT		Alpha 12A Summary Account, List or Account Group is required. The value is used to build the members of the group (FBFUNDDTL).FB11.1, FB160
#FUH-ACCOUNT-GROUP
ACCOUNT_GROUP		Alpha 12A Summary Account, List or Account Group is required. The value is used to build the members of the group (FBFUNDDTL).FB11.1, FB160
#FUH-ACCOUNT-LIST
ACCOUNT_LIST		Alpha 12A Summary Account, List or Account Group is required. The value is used to build the members of the group (FBFUNDDTL).FB11.1, FB160
#FUH-SUB-ACCT-GRP
SUB_ACCT_GRP		Alpha 12The 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).FB11.1, FB160

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FUHSET1
  1. COMPANY
  2. FUND-GROUP
PrimaryCA110, CA195, FB10.1, FB100, FB101, FB11.1, FB11.2, FB111 +22 more (list truncated in source)
FUHSET2
  1. FUND-GROUP
  2. COMPANY
FB11.1, FB111, FB160, FB211

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
RWHEADERGLNAMESGLSYSTEMGLCHARTSUMMXLISTHDRRWGRPDETFBFNDHDRAUFBFUNDAMTFBFUNDDTLFBFUNDHDRFBFUNDHDR

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Account GroupRWHEADERRequiredWhen FUH-ACCOUNT-GROUP != Spaces
"G"→RWH-HEAD-TYPE
FUH-ACCOUNT-GROUP→RWH-HEAD-NAME
"A"→RWH-RECORD-TYPE
Acct UnitGLNAMESNot Required
FUH-COMPANY→GLN-COMPANY
FUH-ACCT-UNIT→GLN-ACCT-UNIT
CompanyGLSYSTEMNot Required
FUH-COMPANY→GLS-COMPANY
GlchartsumGLCHARTSUMNot Required
GLS-CHART-NAME→GCS-CHART-NAME
FUH-SUMMARY-ACCT→GCS-SUMMARY-ACCT
Level GroupRWHEADERNot Required
"G"→RWH-HEAD-TYPE
FUH-LEVEL-GROUP→RWH-HEAD-NAME
"L"→RWH-RECORD-TYPE
MxlisthdrMXLISTHDRNot Required
"ACCTU"→MLH-OBJ-TYPE
FUH-ACCT-UNIT-LIST→MLH-MATRIX-LIST
Mxlisthdr2MXLISTHDRNot Required
"ACCNT"→MLH-OBJ-TYPE
FUH-ACCOUNT-LIST→MLH-MATRIX-LIST
Subacct GroupRWHEADERRequiredWhen FUH-SUB-ACCT-GRP != Spaces
"G"→RWH-HEAD-TYPE
FUH-SUB-ACCT-GRP→RWH-HEAD-NAME
"S"→RWH-RECORD-TYPE

One to many (5) — child tables

RelationTableRulesConditionField map
Acct Grp DetRWGRPDET
"A"→RGD-RECORD-TYPE
FUH-ACCOUNT-GROUP→RGD-HEAD-NAME
—→RGD-RANGE-NUMBER
FbfndhdrauFBFNDHDRAU
FUH-COMPANY→FFA-COMPANY
FUH-FUND-GROUP→FFA-FUND-GROUP
—→FFA-ACTION
—→FFA-DATE
—→FFA-TIME
—→FFA-UNIQUE-I-D
FbfundamtFBFUNDAMT
FUH-COMPANY→FBB-COMPANY
FUH-FUND-GROUP→FBB-FUND-GROUP
—→FBB-FISCAL-YEAR
FbfunddtlFBFUNDDTL
FUH-COMPANY→FUD-COMPANY
FUH-FUND-GROUP→FUD-FUND-GROUP
—→FUD-ACCT-UNIT
—→FUD-ACCOUNT
—→FUD-SUB-ACCOUNT
FbfundhdrFBFUNDHDR
FUH-FUND-GROUP→FUH-FUND-GROUP
—→FUH-COMPANY

Programs

Updated by (3)

Referenced by (90)