FBSPREAD – Budgeting Spread Code
- System
- General Ledger (GL)
- Prefix
FBS- Primary key
COMPANY,FISCAL-YEAR,SPREAD-CODE- Fields
- 32
- Updated by
- 2 programs
- Referenced by
- 38 programs
FBSPREAD is the Budgeting Spread Code table in Lawson General Ledger (prefix FBS). It is indexed by COMPANY, FISCAL-YEAR, SPREAD-CODE (FBSSET1); alternate indexes: FBSSET2. It is related 1:1 to GLSYSTEM and 1:M to FBSPREADAU. It is updated by FB10.1 and GL500 and referenced by CA110, CA195, FB100, FB101, FB11.1, FB120, FB121, FB122 and 30 more. The table has 32 fields, 2 indexes and 2 documented relations.
About FBSPREAD
The Budgeting Spread Code file contains company number, fiscal year, and spread codes with associated values and percentages by period. A spread code represents a pattern for spreading budgeted amounts. Seasonal changes in budgets can be modeled and assigned a spread code for ease in entering the budgeted amounts.
Fields (32)
Column = COBOL field name without the FBS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
FBS-COMPANY PKCOMPANY | Numeric 4 | The company number budgets are defined for. | FB10.1, GL500 |
FBS-FISCAL-YEAR PKFISCAL_YEAR | Numeric 4 | This is the fiscal year budgets are defined in. | FB10.1, GL500 |
FBS-SPREAD-CODE PKSPREAD_CODE | Alpha 3 | This is the name that identifies the spread code. | FB10.1, GL500 |
FBS-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description of the spread code. | FB10.1, GL500 |
FBS-SPREAD-UNITSPREAD_UNIT | Numeric 13 Occurs 13 Times ×13 | Type or select the value used to calculate the spread code percentages. You are required to select at least one spread code value. The system does not accept spread code values in periods not defined in the General Ledger system. | FB10.1, GL500 |
FBS-SPREAD-PRD-1SPREAD_PRD_1 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-2SPREAD_PRD_2 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-3SPREAD_PRD_3 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-4SPREAD_PRD_4 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-5SPREAD_PRD_5 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-6SPREAD_PRD_6 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-7SPREAD_PRD_7 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-8SPREAD_PRD_8 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-9SPREAD_PRD_9 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-10SPREAD_PRD_10 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-11SPREAD_PRD_11 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-12SPREAD_PRD_12 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-PRD-13SPREAD_PRD_13 | Derived | This is the amount of the total spread that applies to this period. | — |
FBS-SPREAD-TOTALSPREAD_TOTAL | Derived | This is the total amount to be spread across the period budgets. | — |
FBS-SPREAD-PCT-1SPREAD_PCT_1 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-2SPREAD_PCT_2 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-3SPREAD_PCT_3 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-4SPREAD_PCT_4 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-5SPREAD_PCT_5 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-6SPREAD_PCT_6 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-7SPREAD_PCT_7 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-8SPREAD_PCT_8 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-9SPREAD_PCT_9 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-10SPREAD_PCT_10 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-11SPREAD_PCT_11 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-12SPREAD_PCT_12 | Derived | This is the percentage of the total spread that applies to this period. | — |
FBS-SPREAD-PCT-13SPREAD_PCT_13 | Derived | This is the percentage of the total spread that applies to this period. | — |
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 |
|---|---|---|---|---|
FBSSET1 | COMPANY, FISCAL-YEAR, SPREAD-CODE | Primary | CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +22 more (list truncated in source) | |
FBSSET2 | COMPANY, SPREAD-CODE, FISCAL-YEAR | GL500 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | GLSYSTEM | Required | FBS-COMPANY → GLS-COMPANY |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Fbspreadau | FBSPREADAU | FBS-COMPANY → FSA-COMPANY, FBS-FISCAL-YEAR → FSA-FISCAL-YEAR, FBS-SPREAD-CODE → FSA-SPREAD-CODE, FSA-ACTION, FSA-DATE, FSA-TIME, FSA-UNIQUE-I-D |
Programs
Updated by (2)
Referenced by (38)
- CA110 Allocation Calculation
- CA195 Budget Allocation Interface
- FB100 Budget Calculation - Computes
- FB101 Budget Calculation - Rates
- FB11.1 Budget Edit Group
- FB120 Intracompany Mass Budgeting
- FB121 Intercompany Mass Budgeting
- FB122 Budget Version
- 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
- FB210 Spread Code Listing
- 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
- GL110 Company Copy Delete
- GL120 Level Reorganization
- GL197 Period, Year End GL Commitments Processing
- GL199 Period Closing
- GL300 General Ledger History Delete
- SNOP.1 REVENUE PLANNED
- SNRP.1 REVENUE PLANNED
- SNSP.1 REVENUE PLANNED