ACACTGPREL – Activity Group Relation

System
Activity Management (AC)
Prefix
AGL
Primary key
OLD-ACT-GRP
Fields
2
Updated by
2 programs
Referenced by
10 programs

ACACTGPREL is the Activity Group Relation table in Lawson Activity Management (prefix AGL). It is indexed by OLD-ACT-GRP (AGLSET1); alternate indexes: AGLSET2. It is updated by AC28.1 and AC300 and referenced by AC127, AC227, AC228, AC27.1, AC50.1, AC50.2, AC500, AC502 and 2 more. The table has 2 fields, 2 indexes and 0 documented relations.

About ACACTGPREL

This file contains information from AC28.1 (Activity Group Relationship). It is used in conversion of non-Lawson activity group information to the LAWSON Project Accounting and Activity Management system. The fields Old Activity Group and Activity Group link the old system with Lawson's Activity Management.

Fields (2)

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

Field / columnTypeDescription & valuesUpdated by
AGL-OLD-ACT-GRP PK
OLD_ACT_GRP		Alpha 35Required key. This is the old activity group or project group, to be associated with a new activity group.AC28.1
AGL-ACTIVITY-GRP
ACTIVITY_GRP		Alpha 15Enter the name of the new activity group associated with the old activity group or project group.AC28.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
AGLSET1OLD-ACT-GRPPrimaryAC127, AC227, AC228, AC27.1, AC28.1, AC50.1, AC50.2, AC500 +3 more
AGLSET2ACTIVITY-GRP, OLD-ACT-GRPKeyChangeAC28.1, AC300, AC502

Programs

Updated by (2)

Referenced by (10)