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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#SPR-SPREAD-CODE PKSPREAD_CODE | Alpha 3 | 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. | AC23.1 |
#SPR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the spread code description. | AC23.1 |
#SPR-ACTIVE-FLAGACTIVE_FLAG | Alpha 1 | This flag indicates whether the spread code is active or inactive.
| AC23.1 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
SPRSET1 |
| Primary | AC20.2, AC20.3, AC20.4, AC20.5, AC21.2, AC220, AC223, AC23.1 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Acspreadx | ACSPREADX |
|
Programs
Updated by (1)
- AC23.1 Spread Codes