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.

Field / column	Type	Description & values	Updated by
`FUH-COMPANY` PK COMPANY	Numeric 4	The company number represents an established General Ledger company.	FB11.1, FB160, GL110
`FUH-FUND-GROUP` PK FUND_GROUP	Alpha 15	The 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 15	An 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 12	An 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 12	The 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 12	A 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 12	A 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 12	A 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 12	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).	FB11.1, FB160

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`FUHSET1`	`COMPANY`, `FUND-GROUP`	Primary		CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB11.2, FB111 +22 more (list truncated in source)
`FUHSET2`	`FUND-GROUP`, `COMPANY`			FB11.1, FB111, FB160, FB211

Relations

One to one (8) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (5) — child tables

Relation	Table	Field map
Acct Grp Det	RWGRPDET	`"A"` → `RGD-RECORD-TYPE`, `FUH-ACCOUNT-GROUP` → `RGD-HEAD-NAME`, → `RGD-RANGE-NUMBER`
Fbfndhdrau	FBFNDHDRAU	`FUH-COMPANY` → `FFA-COMPANY`, `FUH-FUND-GROUP` → `FFA-FUND-GROUP`, → `FFA-ACTION`, → `FFA-DATE`, → `FFA-TIME`, → `FFA-UNIQUE-I-D`
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`

Programs

Updated by (3)

FB11.1 Budget Edit Group
FB160 Budget Edit Group Interface
GL110 Company Copy Delete

Referenced by (90)

CA110 Allocation Calculation
CA195 Budget Allocation Interface
FB10.1 Spread Code
FB100 Budget Calculation - Computes
FB101 Budget Calculation - Rates
FB111 Budget Edit Group Build
FB120 Intracompany Mass Budgeting
FB121 Intercompany Mass Budgeting
FB122 Budget Version
FB145 Budget Batch Journal Control
FB165 Budget Interface
FB190 Budget Double Entry Posting
FB20.1 Period Budget, Rate
FB20.2 Define Budget
FB20.3 By Account
FB20.4 By Accounting Unit
FB20.6 Period Budget, Amounts
FB20.7 Period Budget, Units
FB21.1 Budget by Period
FB211 Budget Edit Group Listing
FB296 Budget Audit
FB30.1 Computed By Accounting Unit
FB31.1 Computed By Account
FB325 Budget Actuals Rebuild
FB35.1 Interbudget Relationships
FB40.1 Budget Journal Entry
FB40.2 Define Budget Journal
FB40.3 Budget Speed Entry
FB40.4 Budget Journal Copy
FB42.1 Budget Adjustment Code
FB45.1 Budget Journal Control
FB60.1 Budget Edit Group Interface Maintenance
FB95.1 Budget Analysis
FB95.2 Account, Period
FB95.3 Account, Year to Date
FB95.4 Accounting Unit, Period
FB95.5 Accounting Unit, Year to Date
FB95.6 Totals
GL120 Level Reorganization
GL197 Period, Year End GL Commitments Processing
GL199 Period Closing
GL298 GL Commitment Analysis Report
GL299 GL and AC History commitment
GL300 General Ledger History Delete
GL500 Fiscal Year Change
GL90.6 Compare Transaction Analysis
GL94.1 Commitment Analysis
GL94.2 Account
GL94.3 Account Totals
GL94.4 Accounting Unit
GL94.5 Accounting Unit Totals
GL94.6 Commitment Account Detail
GL94.7 Commitment Accounting Unit Detail
GL95.1 Account Analysis
GL95.2 Fiscal Year Summary
GL95.3 Totals
GL95.4 Chart Query
GL95.5 Periods versus Year to Date
GL95.6 Year to Date Current Year versus Last Year
GL95.7 Periods Current Year versus Last Year
GL95.8 Year to Date Actual versus Budget
GL95.9 Periods Actual versus Budget
GL96.1 Accounting Units
GL96.2 Year to Date Current Year versus Last Year
GL96.3 Periods Current Year versus Last Year
GL96.4 Year to Date Actual versus Budget
GL96.5 Periods Actual versus Budget
GL97.1 Accounts
GL97.2 Year to Date Current Year versus Last Year
GL97.3 Periods Current Year versus Last Year
GL97.4 Year to Date Actual versus Budget
GL97.5 Periods Actual versus Budget
GL97.6 Year to Date Account Currencies
GL97.7 Periods Account Currencies
GL97.8 Fiscal Year Summary
GL97.9 Totals
GL98.1 Companies
GL98.2 Year to Date Current Year versus Last Year
GL98.3 Periods Current Year versus Last Year
GL98.4 Year to Date Actual versus Budget
GL98.5 Periods Actual versus Budget
GL99.1 Organization Query
GL99.2 Periods versus Year to Date
GL99.3 Year to Date Current Year versus Last Year
GL99.4 Periods Current Year versus Last Year
GL99.5 Year to Date Actual versus Budget
GL99.6 Periods Actual versus Budget
SNOP.1 REVENUE PLANNED
SNRP.1 REVENUE PLANNED
SNSP.1 REVENUE PLANNED