|
|
FBSPREAD FILE
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
FB210
UPDATED BY
FB10.1 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBS-COMPANY Numeric 4 FB10.1 GL500
Element: Company The company number budgets are defined
for.
FBS-FISCAL-YEAR Numeric 4 FB10.1 GL500
Element: Fiscal Year This is the fiscal year budgets are
defined in.
FBS-SPREAD-CODE Alpha 3 FB10.1 GL500
Element: Spread Code This is the name that identifies the
spread code.
FBS-DESCRIPTION Alpha 30 (Lower Case) FB10.1 GL500
Spread Code The description of the spread code.
Description
FBS-SPREAD-UNIT Numeric 13 Occurs 13 Times FB10.1 GL500
Element: Period Value 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.
FBS-SPREAD-PRD-1 Derived
Period 1 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-2 Derived
Period 2 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-3 Derived
Period 3 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-4 Derived
Period 4 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-5 Derived
Period 5 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-6 Derived
Period 6 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-7 Derived
Period 7 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-8 Derived
Period 8 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-9 Derived
Period 9 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-10 Derived
Period 10 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-11 Derived
Period 11 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-12 Derived
Period 12 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-PRD-13 Derived
Period 13 Spread This is the amount of the total spread
Amount that applies to this period.
FBS-SPREAD-TOTAL Derived
Element: Spread Total This is the total amount to be spread
across the period budgets.
FBS-SPREAD-PCT-1 Derived
Period 1 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-2 Derived
Period 2 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-3 Derived
Period 3 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-4 Derived
Period 4 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-5 Derived
Period 5 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-6 Derived
Period 6 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-7 Derived
Period 7 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-8 Derived
Period 8 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-9 Derived
Period 9 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-10 Derived
Period 10 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-11 Derived
Period 11 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-12 Derived
Period 12 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBS-SPREAD-PCT-13 Derived
Period 13 Spread This is the percentage of the total
Percentage spread that applies to this period.
FBSPREAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBSSET1 COMPANY FB10.1 FB20.1
FISCAL-YEAR FB20.3 FB20.4
SPREAD-CODE FB20.6 FB20.7
FB21.1 FB210
FBSSET2 COMPANY GL500
SPREAD-CODE
FISCAL-YEAR
FBSPREAD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
FBS-COMPANY -> GLS-COMPANY
|
