FBFUNDAMT – Budget Fund Balance

System
General Ledger (GL)
Prefix
FBB
Primary key
COMPANY, FUND-GROUP, FISCAL-YEAR
Fields
9
Updated by
357 programs
Referenced by
18 programs

FBFUNDAMT is the Budget Fund Balance table in Lawson General Ledger (prefix FBB). It is indexed by COMPANY, FUND-GROUP, FISCAL-YEAR (FBBSET1). It is related 1:1 to FBFUNDHDR. It is updated by AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 and 349 more and referenced by AC191, AC40.4, AC41.4, AC42.1, BR41.4, BR44.1, CA110, CB222 and 10 more. The table has 9 fields, 1 index and 1 documented relation.

About FBFUNDAMT

The Budget Edit Group Balance file contains the stored commitment budget balance and the released General Ledger transaction balance/posted balance for the budget edit group established in FB11.

Fields (9)

Column = COBOL field name without the FBB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
FBB-COMPANY PK
COMPANY		Numeric 4The company number represents an established General Ledger company.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
FBB-FUND-GROUP PK
FUND_GROUP		Alpha 15The Fund Group represents a set of accounting units and accounts that are grouped together for budget editing purposes.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
FBB-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4The fiscal year of the record.AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +52 more (list truncated in source)
FBB-BEG-BAL-AMOUNT
BEG_BAL_AMOUNT		Signed 18.2the cumulative beginning balance total (GLAMOUNTS) and released transactions (GLTRANS) for the budget edit group for the fiscal year.CA195, FB100, FB101, FB11.1, FB120, FB121, FB122, FB145 +30 more
FBB-PER-AMOUNT
PER_AMOUNT		Signed 18.2 Occurs 13 Times ×13The cumulative period balance (GLAMOUNTS) and the released transactions (GLTRANS) for the budget edit group.CA195, FB100, FB101, FB11.1, FB120, FB121, FB122, FB145 +30 more
FBB-BEG-BAL-BUD
BEG_BAL_BUD		Signed 18.2The cumulative commitment budget beginning balance for the budget edit group.CA195, FB100, FB101, FB11.1, FB120, FB121, FB122, FB145 +30 more
FBB-PER-BUDGET
PER_BUDGET		Signed 18.2 Occurs 13 Times ×13The cumulative commitment budget period balance for the budget edit group.CA195, FB100, FB101, FB11.1, FB120, FB121, FB122, FB145 +29 more
FBB-ROLLOVER-AMT
ROLLOVER_AMT		Signed 18.2—AP125, AP126, AP131, AP170, AP190, AP193, AP21.1, AP23.1 +52 more (list truncated in source)
FBB-ROLLOVER-BAL
ROLLOVER_BAL		Signed 18.2—AP125, AP126, AP131, AP170, AP190, AP193, AP21.1, AP23.1 +52 more (list truncated in source)

Indexes (1)

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

IndexKeysFlagsConditionUsed in
FBBSET1COMPANY, FUND-GROUP, FISCAL-YEARPrimaryAC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
FbfundhdrFBFUNDHDRRequiredFBB-COMPANY → FUH-COMPANY, FBB-FUND-GROUP → FUH-FUND-GROUP

Programs

Updated by (357)

Referenced by (18)