|
|
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
Company The company number budgets are defined
for.
FBS-FISCAL-YEAR Numeric 4 FB10.1 GL500
Fiscal Year This is the fiscal year budgets are
defined in.
FBS-SPREAD-CODE Alpha 3 FB10.1 GL500
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
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
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 This path accesses the spread code via FB10.1 FB20.1
FISCAL-YEAR fiscal year within company. FB20.3 FB20.4
SPREAD-CODE FB20.6 FB20.7
FB21.1 FB210
FBSSET2 COMPANY This path accesses the fiscal year via GL500
SPREAD-CODE spread code within company.
FISCAL-YEAR
FBSPREAD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
FBS-COMPANY -> GLS-COMPANY
|