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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET3
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 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
FBHSET1
  1. COMPANY
  2. FISCAL-YEAR
  3. BUDGET-NBR
PrimaryAC191, AC40.4, AC41.4, AC42.1, AC527, AP125, AP126, AP131 +22 more (list truncated in source)
FBHSET2
  1. COMPANY
  2. BUDGET-NBR
  3. FISCAL-YEAR
FB25.1, GL110, GL300, GL500
FBHSET3
  1. USER-CLASS
  2. COMPANY
  3. FISCAL-YEAR
  4. BUDGET-NBR
KeyChangeFB01.2
FBHSET4
  1. COMPANY
  2. FISCAL-YEAR
  3. BUDGET-NBR
SubsetWhere COMMIT-BUD = "Y"AC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source)

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequired
FBH-COMPANY→GLS-COMPANY
CucodesCUCODESRequired
FBH-CURRENCY-CODE→CUC-CURRENCY-CODE

One to many (3) — child tables

RelationTableRulesConditionField map
Budget DetailFBDETAIL
FBH-COMPANY→FBD-COMPANY
FBH-FISCAL-YEAR→FBD-FISCAL-YEAR
FBH-BUDGET-NBR→FBD-BUDGET-NBR
—→FBD-ACCT-UNIT
—→FBD-ACCOUNT
—→FBD-SUB-ACCOUNT
CurelatCURELAT
GLS-CURRENCY-TABLE→CRL-CURRENCY-TABLE
FBH-CURRENCY-CODE→CRL-FR-CURR-CODE
—→CRL-TO-CURR-CODE
FbheaderauFBHEADERAU
FBH-COMPANY→FHA-COMPANY
FBH-FISCAL-YEAR→FHA-FISCAL-YEAR
FBH-BUDGET-NBR→FHA-BUDGET-NBR
—→FHA-ACTION
—→FHA-DATE
—→FHA-TIME
—→FHA-UNIQUE-I-D

Programs

Updated by (26)

Referenced by (441)