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
Project Accounting and 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    AC50.2
AC500     AC502     AC52.1    AC520     PW110     PW510
SB15.1    SB515

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  AC50.2
                                                                 AC500   AC502
                                                                 AC52.1  AC520
                                                                 PW110   PW510
                                                                 SB15.1  SB515

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

                         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