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.

Field / column	Type	Description & values	Updated by
`ARE-OLD-ACTIVITY` PK OLD_ACTIVITY	Alpha 35	Required key. This is the old activity or project, to be associated with a new activity.	AC29.1, AC500
`ARE-ACTIVITY` ACTIVITY	Alpha 15	Enter the name of the new activity associated with the old activity or project.	AC29.1, AC500
`ARE-SUMMARY-TYPE` PK SUMMARY_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` PK COMPANY	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-1` OLD_VAR_LEV_1	Alpha 15	This is the old variable level 1.	—
`ARE-VAR-LEVEL-1` VAR_LEVEL_1	Alpha 15	This is variable level 1 for the new activity.	—
`ARE-VAR-LEVEL-2` VAR_LEVEL_2	Alpha 15	This is variable level 2 for the new activity.	—
`ARE-VAR-LEVEL-3` VAR_LEVEL_3	Alpha 15	This is variable level 3 for the new activity.	—
`ARE-VAR-LEVEL-4` VAR_LEVEL_4	Alpha 15	This is variable level 4 for the new activity.	—
`ARE-VAR-LEVEL-5` VAR_LEVEL_5	Alpha 15	This is variable level 5 for the new activity.	—
`ARE-VAR-LEVELS` VAR_LEVELS	Alpha 30	This field contains the variable levels for the new activity.	—

Indexes (3)

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

Index	Keys	Flags	Used in
`ARESET1`	`OLD-ACTIVITY`, `COMPANY`, `SUMMARY-TYPE`	Primary	AC127, AC227, AC229, AC27.1, AC29.1, AC50.1, AC500
`ARESET2`	`ACTIVITY`, `OLD-ACTIVITY`	KeyChange	AC10.1, AC300, AC502
`ARESET4`	`OLD-ACTIVITY`, `ACTIVITY`	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		`ARE-ACTIVITY` → `ACV-ACTIVITY`

Programs

Updated by (4)

AC10.1 Activity
AC29.1 Activity Relationship
AC300 Activity Group Purge
AC500 Activity Interface

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