ACSPREADX – Activity Spread Code Detail
- System
- Activity Management (AC)
- Prefix
SPX- Primary key
SPREAD-CODE,PERIOD- Fields
- 3
- Updated by
- 1 program
- Referenced by
- 15 programs
ACSPREADX is the Activity Spread Code Detail table in Lawson Activity Management (prefix SPX). It is indexed by SPREAD-CODE, PERIOD (SPXSET1). It is related 1:1 to ACSPREAD. It is updated by AC23.1 and referenced by AC121, AC123, AC127, AC20.2, AC20.3, AC20.4, AC20.5, AC21.1 and 7 more. The table has 3 fields, 1 index and 1 documented relation.
About ACSPREADX
This file contains detailed information on spread codes from AC23.1 (Spread Codes). It includes spread code, period, and percentage of budget.
Fields (3)
Column = COBOL field name without the SPX- 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 |
|---|---|---|---|
#SPX-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 |
#SPX-PERIOD PKPERIOD | Numeric 2 | Required key. This is the period for the spread code. | AC23.1 |
#SPX-PERC-OF-TIMEPERC_OF_TIME | Signed 8.5 | 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. | 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 |
|---|---|---|---|---|
SPXSET1 |
| Primary | AC121, AC123, AC127, AC20.2, AC20.3, AC20.4, AC20.5, AC21.1 +8 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Acspread | ACSPREAD | Required |
|
Programs
Updated by (1)
- AC23.1 Spread Codes
Referenced by (15)
- AC121 Budget Calculation
- AC123 Budget Copy
- AC127 Budget Interface
- AC20.2 Annual Budget
- AC20.3 Period Budget
- AC20.4 Activity Budgets by Activity
- AC20.5 Activity Budgets by Account Category
- AC21.1 Life Only Budget Change Order
- AC21.2 Annual Budget Change Order
- AC21.3 Period Budget Change Order
- AC21.4 Activity Budget Change Orders by Activity
- AC21.5 Period Budget Change Order Import
- AC22.1 Change Order Approval
- AC223 Spread Code Listing
- AC27.1 Budget Interface Adjustment