Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACSPREADX


                             ACSPREADX FILE

                      Activity Spread Code Detail

This file contains detailed information on spread codes from AC23.1 (Spread
Codes). It includes spread code, period, and percentage of budget.

REFERENCED BY

AC121     AC123     AC127     AC20.2    AC20.3    AC20.4
AC20.5    AC21.1    AC21.2    AC21.3    AC21.4    AC22.1
AC223     AC27.1    SB15.1    SB515

UPDATED BY

AC23.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SPX-SPREAD-CODE        Alpha 3                                   AC23.1
Element: Spread Code   Required key. A spread code is a
                       formula for budgeting spending activity
                       that can be set up in AC23.1 (Spread
                       Codes) for each account category. You
                       can use a spread code to schedule
                       spending over the life of the activity
                       or activity group. Spread codes can be
                       used to represent characteristic
                       spending patterns.

SPX-PERIOD             Numeric 2                                 AC23.1
Element: Period        Required key. This is the period for
                       the spread code.

SPX-PERC-OF-TIME       Signed 8.5                                AC23.1
Element: Perc Of Time  This field defines the percentage of
                       budget for this period for the spread
                       code.

                       This field indicates the percent of the
                       total budget of the activity to be
                       allocated to the time interval. The
                       Percent of Budget field is repeated for
                       each time interval on the form.

                       The sum of the entries in the Percent
                       of Budget fields must be 100 percent. If
                       the entries total less than 100 percent,
                       the Activity Management system makes an
                       additional entry, automatically bringing
                       the total to 100 percent. If the entries
                       total more than 100 percent, add and
                       change are not allowed and an error
                       message displays.

                         ACSPREADX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SPXSET1   SPREAD-CODE                                            AC121   AC123
          PERIOD                                                 AC127   AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC21.1
                                                                 AC21.2  AC21.3
                                                                 AC21.4  AC22.1
                                                                 AC223   AC23.1
                                                                 AC27.1  SB15.1
                                                                 SB515

                         ACSPREADX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acspread       ACSPREAD     Required

                            SPX-SPREAD-CODE    -> SPR-SPREAD-CODE