FBHISTHDR – Budget History Header
- System
- General Ledger (GL)
- Prefix
FHH- Primary key
COMPANY,FISCAL-YEAR,BUDGET-NBR,VERSION- Fields
- 7
- Updated by
- 4 programs
- Referenced by
- 44 programs
FBHISTHDR is the Budget History Header table in Lawson General Ledger (prefix FHH). It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR, VERSION (FHHSET1). It is related 1:M to FBHSTHDRAU. It is updated by FB122, GL110, GL300 and GL500 and referenced by CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 and 36 more. The table has 7 fields, 1 index and 1 documented relation.
About FBHISTHDR
The Budget History Header file stores budget header information for a budget version.
Fields (7)
Column = COBOL field name without the FHH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
FHH-COMPANY PKCOMPANY | Numeric 4 | The company number budgets are defined for. | FB122, GL110 |
FHH-FISCAL-YEAR PKFISCAL_YEAR | Numeric 4 | This is the fiscal year budgets are defined in. | FB122, GL500 |
FHH-BUDGET-NBR PKBUDGET_NBR | Numeric 3 | The Budget Number field contains the budget number. | FB122, GL500 |
FHH-VERSION PKVERSION | Numeric 2 | This field displays the budget version number. | FB122, GL500 |
FHH-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Occurs 2 Times The description of the version. | FB122 |
FHH-VERSION-DATEVERSION_DATE | Numeric 8 (yyyymmdd) | The date the budget version was created. | FB122 |
FHH-VERSION-TIMEVERSION_TIME | Numeric 6 (hhmmss) | The time the budget version was created. | FB122 |
Indexes (1)
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 |
|---|---|---|---|---|
FHHSET1 | COMPANY, FISCAL-YEAR, BUDGET-NBR, VERSION | Primary | CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +22 more (list truncated in source) |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Fbhsthdrau | FBHSTHDRAU | FHH-COMPANY → FHU-COMPANY, FHH-FISCAL-YEAR → FHU-FISCAL-YEAR, FHH-BUDGET-NBR → FHU-BUDGET-NBR, FHH-VERSION → FHU-VERSION, → FHU-ACTION, → FHU-DATE, → FHU-TIME, → FHU-UNIQUE-I-D |
Programs
Updated by (4)
- FB122 Budget Version
- GL110 Company Copy Delete
- GL300 General Ledger History Delete
- GL500 Fiscal Year Change
Referenced by (44)
- CA110 Allocation Calculation
- CA195 Budget Allocation Interface
- FB10.1 Spread Code
- FB100 Budget Calculation - Computes
- FB101 Budget Calculation - Rates
- FB11.1 Budget Edit Group
- FB120 Intracompany Mass Budgeting
- FB121 Intercompany Mass Budgeting
- FB145 Budget Batch Journal Control
- FB160 Budget Edit Group Interface
- 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
- FB215 Budget Annual Amount Report
- FB220 Budget Listing
- FB295 Budget Analysis Report
- 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
- 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
- SNOP.1 REVENUE PLANNED
- SNRP.1 REVENUE PLANNED
- SNSP.1 REVENUE PLANNED