ACACTREL – Activity Relationship
- System
- Activity Management (AC)
- Prefix
ARE- Primary key
OLD-ACTIVITY,COMPANY,SUMMARY-TYPE- Fields
- 11
- Updated by
- 4 programs
- Referenced by
- 13 programs
ACACTREL is the Activity Relationship table in Lawson Activity Management (prefix ARE). It is indexed by OLD-ACTIVITY, COMPANY, SUMMARY-TYPE (ARESET1); alternate indexes: ARESET2 and ARESET4. It is related 1:1 to ACACTIVITY. It is updated by AC10.1, AC29.1, AC300 and AC500 and referenced by AC127, AC227, AC229, AC27.1, AC50.1, AC50.2, AC502, AC51.1 and 5 more. The table has 11 fields, 3 indexes and 1 documented relation.
About ACACTREL
This file contains information from AC29.1 (Activity Relationship). The file is used in conversion of non-Lawson activity information to the LAWSON INSIGHT Activity Management system. Its fields Old Activity and Activity link the old system to Activity Management. In addition, it includes the Summary Type and Company fields for upgrade purposes.
Fields (11)
Column = COBOL field name without the ARE- 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 |
|---|---|---|---|
#ARE-OLD-ACTIVITY PKOLD_ACTIVITY | Alpha 35 | Required key. This is the old activity or project, to be associated with a new activity. | AC29.1, AC500 |
#ARE-ACTIVITY SET2 SET4ACTIVITY | Alpha 15 | Enter the name of the new activity associated with the old activity or project. | AC29.1, AC500 |
#ARE-SUMMARY-TYPE PKSUMMARY_TYPE | Alpha 9 | Required key. This field is used for upgrading the Lawson 6.0 Project Accounting or 6.1 Projects systems. It contains a summary type from the Project Accounting system or a project from the Projects system. | AC500 |
#ARE-COMPANY PKCOMPANY | Numeric 4 | Required key. This is the company for the non-Lawson activity or the Lawson 6.0 or 6.1 project or summary type to be upgraded. | AC500 |
#ARE-OLD-VAR-LEV-1OLD_VAR_LEV_1 | Alpha 15 | This is the old variable level 1. | — |
#ARE-VAR-LEVEL-1VAR_LEVEL_1 | Alpha 15 | This is variable level 1 for the new activity. | — |
#ARE-VAR-LEVEL-2VAR_LEVEL_2 | Alpha 15 | This is variable level 2 for the new activity. | — |
#ARE-VAR-LEVEL-3VAR_LEVEL_3 | Alpha 15 | This is variable level 3 for the new activity. | — |
#ARE-VAR-LEVEL-4VAR_LEVEL_4 | Alpha 15 | This is variable level 4 for the new activity. | — |
#ARE-VAR-LEVEL-5VAR_LEVEL_5 | Alpha 15 | This is variable level 5 for the new activity. | — |
#ARE-VAR-LEVELSVAR_LEVELS | Alpha 30 | This field contains the variable levels for the new activity. | — |
Indexes (3)
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 |
|---|---|---|---|---|
ARESET1 |
| Primary | AC127, AC227, AC229, AC27.1, AC29.1, AC50.1, AC500 | |
ARESET2 |
| KeyChange | AC10.1, AC300, AC502 | |
ARESET4 |
| KeyChange | AC50.2, AC502, AC51.1, AC510, AC52.1, AC520, AC54.1, AC540 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Activity | ACACTIVITY | Not Required |
|
Programs
Updated by (4)
Referenced by (13)
- AC127 Budget Interface
- AC227 Budget Interface Listing
- AC229 Activity Relationship Listing
- AC27.1 Budget Interface Adjustment
- AC50.1 Activity Interface Adjustment
- AC50.2 Performance Date Interface Adjustment
- AC502 Performance Date Interface
- AC51.1 Attribute Interface Adjustment
- AC510 Attribute Interface
- AC52.1 Resource Interface Adjustment
- AC520 Resource Interface
- AC54.1 Transaction Interface Adjustment
- AC540 Transaction Interface