Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACSPREAD FILE

                         Activity Spread Codes

This file contains information on spread codes from AC23.1 (Spread Codes). It
includes spread code, description, and an active flag.

REFERENCED BY

AC20.2    AC20.3    AC20.4    AC20.5    AC21.2    AC220
AC223

UPDATED BY

AC23.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SPR-SPREAD-CODE      Alpha 3                                     AC23.1
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.

SPR-DESCRIPTION      Alpha 30  (Lower Case)                      AC23.1
Spread Code          This is the spread code description.
Description

SPR-ACTIVE-FLAG      Alpha 1                                     AC23.1
Active Flag          This flag indicates whether the spread
                     code is active or inactive.
                     A = Active
                     I = Inactive

                         ACSPREAD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SPRSET1   SPREAD-CODE                                            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC21.2  AC220
                                                                 AC223   AC23.1

                         ACSPREAD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acspreadx      ACSPREADX

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