Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

                            ACACTGPREL FILE

                        Activity Group Relation

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

REFERENCED BY

AC127     AC227     AC228     AC27.1    AC50.1    AC500

UPDATED BY

AC28.1    AC300     AC310

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AGL-OLD-ACT-GRP      Alpha 35                                    AC28.1
Old Activity Group   Required key. This is the old activity
                     group or project group, to be associated
                     with a new activity group.

AGL-ACTIVITY-GRP     Alpha 15                                    AC28.1  AC310
Activity Group       Enter the name of the new activity
                     group associated with the old activity
                     group or project group.

                         ACACTGPREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGLSET1   OLD-ACT-GRP                                            AC127   AC227
                                                                 AC228   AC27.1
                                                                 AC28.1  AC310
                                                                 AC50.1  AC500

AGLSET2   ACTIVITY-GRP  KeyChange                                AC28.1  AC300
          OLD-ACT-GRP                                            AC310

                         ACACTGPREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Not Required

                            AGL-OLD-ACT-GRP    -> AGP-ACTIVITY-GRP