FBSPREAD

Budgeting Spread Code

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.

REFERENCED BY
FB20.1 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1


UPDATED BY
FB10.1 GL500 FB210

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBS-COMPANY
Element: Company
Numeric 4
The company number budgets are defined for.
FB10.1 GL500
FBS-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
This is the fiscal year budgets are defined in.
FB10.1 GL500
FBS-SPREAD-CODE
Element: Spread Code
Alpha 3
This is the name that identifies the spread code.
FB10.1 GL500
FBS-DESCRIPTION
Spread Code
Description
Alpha 30 (Lower Case)
The description of the spread code.
FB10.1 GL500
FBS-SPREAD-UNIT
Element: Period Value
Numeric 13 Occurs 13 Times
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-1
Period 1 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-2
Period 2 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-3
Period 3 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-4
Period 4 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-5
Period 5 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-6
Period 6 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-7
Period 7 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-8
Period 8 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-9
Period 9 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-10
Period 10 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-11
Period 11 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-12
Period 12 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-PRD-13
Period 13 Spread
Amount
Derived
This is the amount of the total spread that applies to this period.
FBS-SPREAD-TOTAL
Element: Spread Total
Derived
This is the total amount to be spread across the period budgets.
FBS-SPREAD-PCT-1
Period 1 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-2
Period 2 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-3
Period 3 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-4
Period 4 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-5
Period 5 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-6
Period 6 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-7
Period 7 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-8
Period 8 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-9
Period 9 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-10
Period 10 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-11
Period 11 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-12
Period 12 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.
FBS-SPREAD-PCT-13
Period 13 Spread
Percentage
Derived
This is the percentage of the total spread that applies to this period.


FBSPREAD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBSSET1 COMPANY
FISCAL-YEAR
SPREAD-CODE
FB10.1 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB210
FBSSET2 COMPANY
SPREAD-CODE
FISCAL-YEAR
GL500


FBSPREAD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
FBS-COMPANY->GLS-COMPANY


File created: Wed Jun 08 20:48:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.