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
CA110 CA195 FB100 FB101 FB11.1 FB120
FB121 FB122 FB145 FB160 FB165 FB190
FB20.1 FB20.2 FB20.3 FB20.4 FB20.6 FB20.7
FB21.1 FB210 FB30.1 FB31.1 FB325 FB35.1
FB40.1 FB40.2 FB40.3 FB40.4 FB42.1 FB45.1
GL110 GL120 GL197 GL199 GL300 SNOP.1
SNRP.1 SNSP.1


UPDATED BY
FB10.1 GL500

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
...
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB210 FB30.1
FB31.1 FB325
FB35.1 FB40.1
FB40.2 FB40.3
FB40.4 FB42.1
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


FBSPREAD FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 02:13:50 2016

Home
Contact Us



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