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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#AGL-OLD-ACT-GRP PKOLD_ACT_GRP | Alpha 35 | Required key. This is the old activity group or project group, to be associated with a new activity group. | AC28.1 |
#AGL-ACTIVITY-GRP SET2ACTIVITY_GRP | Alpha 15 | Enter the name of the new activity group associated with the old activity group or project group. | AC28.1 |
Indexes (2)
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 |
|---|---|---|---|---|
AGLSET1 |
| Primary | AC127, AC227, AC228, AC27.1, AC28.1, AC50.1, AC50.2, AC500 +3 more | |
AGLSET2 |
| KeyChange | AC28.1, AC300, AC502 |
Programs
Updated by (2)
Referenced by (10)
- AC127 Budget Interface
- AC227 Budget Interface Listing
- AC228 Activity Group Relationship List
- AC27.1 Budget Interface Adjustment
- AC50.1 Activity Interface Adjustment
- AC50.2 Performance Date Interface Adjustment
- AC500 Activity Interface
- AC502 Performance Date Interface
- AC52.1 Resource Interface Adjustment
- AC520 Resource Interface