Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACSPREAD


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

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

SPR-ACTIVE-FLAG        Alpha 1                                   AC23.1
Element: 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