Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACTGPREL


                            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
Element: Old Activity GRequired 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
Element: Activity GroupEnter 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