FBHEADER – Budget Header

System
General Ledger (GL)
Prefix
FBH
Primary key
COMPANY, FISCAL-YEAR, BUDGET-NBR
Fields
20
Updated by
26 programs
Referenced by
441 programs

FBHEADER is the Budget Header table in Lawson General Ledger (prefix FBH). It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR (FBHSET1); alternate indexes: FBHSET2, FBHSET3 and FBHSET4. It is related 1:1 to GLSYSTEM and CUCODES and 1:M to FBDETAIL, CURELAT and FBHEADERAU. It is updated by CA195, FB100, FB101, FB120, FB121, FB122, FB165, FB20.1 and 18 more and referenced by AC191, AC40.4, AC41.4, AC42.1, AC527, AP125, AP126, AP131 and 433 more. The table has 20 fields, 4 indexes and 5 documented relations.

About FBHEADER

The Budgeting Header file is used to control the processing of the Budgeting system. Processing control information is keyed by fiscal year and budget number.

Fields (20)

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

Field / columnTypeDescription & valuesUpdated by
FBH-COMPANY PK
COMPANY
Numeric 4This is the company number budgets are defined for.CA195, FB120, FB121, FB165, FB20.2, GL110, GL199, IFGT.1
FBH-FISCAL-YEAR PK
FISCAL_YEAR
Numeric 4This is the fiscal year budgets are defined in.CA195, FB120, FB121, FB165, FB20.2, GL199, GL500, IFGT.1
FBH-BUDGET-NBR PK
BUDGET_NBR
Numeric 3This is the number that identifies the budget.CA195, FB120, FB121, FB165, FB20.2, GL199, IFGT.1
FBH-VERSION
VERSION
Numeric 2This is the budget version number.CA195, FB120, FB121, FB165, FB20.2, GL110, GL199, IFGT.1
FBH-USER-CLASS
USER_CLASS
Alpha 12This is the user class assigned to the budget that limits the users that have access to modify the budget.FB20.2
FBH-MAINT-DATE
MAINT_DATE
Numeric 8 (yyyymmdd)This is the last date the budget was maintained.CA195, FB100, FB101, FB120, FB121, FB165, FB20.1, FB20.2 +10 more
FBH-MAINT-TIME
MAINT_TIME
Numeric 6 (hhmmss)This is the last time the budget was maintained.CA195, FB100, FB101, FB120, FB121, FB165, FB20.1, FB20.2 +10 more
FBH-CALC-DATE
CALC_DATE
Numeric 8 (yyyymmdd)This is the date the budget was last calculated.CA195, FB100, FB101, FB120, FB121, FB20.6, FB21.1
FBH-CALC-TIME
CALC_TIME
Numeric 6 (hhmmss)This is the time the budget was last calculated.CA195, FB100, FB101, FB120, FB121, FB20.6, FB21.1
FBH-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the budget description.CA195, FB120, FB121, FB165, FB20.2, GL199, IFGT.1
FBH-BUD-TYPE
BUD_TYPE
Alpha 1This field indicates the type of the budget: computed or noncomputed. " " = Not Computed
  • C Computed
FB120, FB20.2, GL199, IFGT.1
FBH-ALLOW-DEC
ALLOW_DEC
Alpha 1
  • Y Yes
  • N No
CA195, FB120, FB165, FB20.2, GL199, IFGT.1
FBH-LOCK
LOCK
Alpha 1This field indicates whether the budget is locked.
  • Y Yes
  • N No
CA195, FB120, FB121, FB165, FB20.2, GL110
FBH-COMMIT-BUD
COMMIT_BUD
Alpha 1This is the Yes/No flag indicating whether this is the budget that GL commitments is edited against.
  • N No
  • Y Yes
CA195, FB120, FB121, FB165, FB20.2, GL199, IFGT.1
FBH-DOUBLE-ENTRY
DOUBLE_ENTRY
Alpha 1This is the Yes/No flag indicating whether this budget will be updated using FB20 or the double entry functionality in FB40.CA195, FB120, FB121, FB165, FB20.2, GL199, IFGT.1
FBH-LAST-JE-USED
LAST_JE_USED
Numeric 8This is the last journal number used by FB40.FB40.2, FB40.4, FB45.1, GL197, GL199, GL500
FBH-LST-IC-JE-NBR
LST_IC_JE_NBR
Numeric 4This is the last journal number used by FB40 for intercompany journal entries.FB40.2, FB40.4, GL500
FBH-LST-IB-JE-NBR
LST_IB_JE_NBR
Numeric 8This is the last journal number used by FB40 for Interbudget journal entries.FB40.2, FB40.4, GL500
FBH-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).CA195, FB120, FB141, FB165, FB195, FB20.2, FB295, FB95.1 +7 more
FBH-ALLOW-UNIT-DEC
ALLOW_UNIT_DEC
Alpha 1
  • Y Yes
  • N No
CA195, FB120, FB165, FB20.2, GL199, IFGT.1

Indexes (4)

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

IndexKeysFlagsConditionUsed in
FBHSET1COMPANY, FISCAL-YEAR, BUDGET-NBRPrimaryAC191, AC40.4, AC41.4, AC42.1, AC527, AP125, AP126, AP131 +22 more (list truncated in source)
FBHSET2COMPANY, BUDGET-NBR, FISCAL-YEARFB25.1, GL110, GL300, GL500
FBHSET3USER-CLASS, COMPANY, FISCAL-YEAR, BUDGET-NBRKeyChangeFB01.2
FBHSET4COMPANY, FISCAL-YEAR, BUDGET-NBRSubsetWhere COMMIT-BUD = "Y"AC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequiredFBH-COMPANYGLS-COMPANY
CucodesCUCODESRequiredFBH-CURRENCY-CODECUC-CURRENCY-CODE

One to many (3) — child tables

RelationTableRulesConditionField map
Budget DetailFBDETAILFBH-COMPANYFBD-COMPANY, FBH-FISCAL-YEARFBD-FISCAL-YEAR, FBH-BUDGET-NBRFBD-BUDGET-NBR, FBD-ACCT-UNIT, FBD-ACCOUNT, FBD-SUB-ACCOUNT
CurelatCURELATGLS-CURRENCY-TABLECRL-CURRENCY-TABLE, FBH-CURRENCY-CODECRL-FR-CURR-CODE, CRL-TO-CURR-CODE
FbheaderauFBHEADERAUFBH-COMPANYFHA-COMPANY, FBH-FISCAL-YEARFHA-FISCAL-YEAR, FBH-BUDGET-NBRFHA-BUDGET-NBR, FHA-ACTION, FHA-DATE, FHA-TIME, FHA-UNIQUE-I-D

Programs

Updated by (26)

Referenced by (441)