Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBSPREAD


                             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       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