ACSPREAD – Activity Spread Codes

System
Activity Management (AC)
Prefix
SPR
Primary key
SPREAD-CODE
Fields
3
Updated by
1 program
Referenced by
7 programs

ACSPREAD is the Activity Spread Codes table in Lawson Activity Management (prefix SPR). It is indexed by SPREAD-CODE (SPRSET1). It is related 1:M to ACSPREADX. It is updated by AC23.1 and referenced by AC20.2, AC20.3, AC20.4, AC20.5, AC21.2, AC220 and AC223. The table has 3 fields, 1 index and 1 documented relation.

About ACSPREAD

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

Fields (3)

Column = COBOL field name without the SPR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
SPR-SPREAD-CODE PK
SPREAD_CODE		Alpha 3Required 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.AC23.1
SPR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the spread code description.AC23.1
SPR-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1This flag indicates whether the spread code is active or inactive.
  • A Active
  • I Inactive
AC23.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SPRSET1SPREAD-CODEPrimaryAC20.2, AC20.3, AC20.4, AC20.5, AC21.2, AC220, AC223, AC23.1

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
AcspreadxACSPREADXSPR-SPREAD-CODE → SPX-SPREAD-CODE, → SPX-PERIOD

Programs

Updated by (1)

Referenced by (7)