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
FB10.1 | GL500 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
FBS-COMPANY Element: Company | Numeric 4 The company number budgets are defined for. |
|
||
FBS-FISCAL-YEAR Element: Fiscal Year | Numeric 4 This is the fiscal year budgets are defined in. |
|
||
FBS-SPREAD-CODE Element: Spread Code | Alpha 3 This is the name that identifies the spread code. |
|
||
FBS-DESCRIPTION Spread Code Description | Alpha 30 (Lower Case) The description of the spread code. |
|
||
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. |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
FBSSET1 |
COMPANY FISCAL-YEAR SPREAD-CODE |
|
|||||||||
FBSSET2 |
COMPANY SPREAD-CODE FISCAL-YEAR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Company | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Fbspreadau | FBSPREADAU |
|
All trademarks and registered trademarks are the property of their
respective owners.