Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACTREL


                             ACACTREL FILE

                           Activity Relation

This file contains information from AC29.1 (Activity Relationship). The file
is used in conversion of non-Lawson activity information to the LAWSON INSIGHT
Activity Management system. Its fields Old Activity and Activity link the old
system to Activity Management. In addition, it includes the Summary Type and
Company fields for upgrade purposes.

REFERENCED BY

AC127     AC227     AC229     AC27.1    AC50.1    AC50.2
SB15.1    SB515     AC502     AC51.1    AC510     AC52.1
AC520     AC54.1    AC540

UPDATED BY

AC10.1    AC29.1    AC300     AC310     AC500     PW110
PW510

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARE-OLD-ACTIVITY       Alpha 35                                  AC29.1  AC500
Element: Old Activity  Required key. This is the old activity    PW110   PW510
                       or project, to be associated with a new
                       activity.

ARE-ACTIVITY           Alpha 15                                  AC29.1  AC310
Element: Activity      Enter the name of the new activity        AC500   PW110
                       associated with the old activity or       PW510
                       project.

ARE-SUMMARY-TYPE       Alpha 9                                   AC500   PW110
Element: Summary Type  Required key. This field is used for      PW510
                       upgrading the Lawson 6.0 Project
                       Accounting or 6.1 Projects systems. It
                       contains a summary type from the Project
                       Accounting system or a project from the
                       Projects system.

ARE-COMPANY            Numeric 4                                 AC500   PW110
Element: Company       Required key. This is the company for     PW510
                       the non-Lawson activity or the Lawson
                       6.0 or 6.1 project or summary type to be
                       upgraded.

ARE-OLD-VAR-LEV-1      Alpha 15
Element: Old Variable LThis is the old variable level 1.

ARE-VAR-LEVEL-1        Alpha 15
Element: Variable LevelThis is variable level 1 for the new
                       activity.

ARE-VAR-LEVEL-2        Alpha 15
Element: Variable LevelThis is variable level 2 for the new
                       activity.

ARE-VAR-LEVEL-3        Alpha 15
Element: Variable LevelThis is variable level 3 for the new
                       activity.

ARE-VAR-LEVEL-4        Alpha 15
Element: Variable LevelThis is variable level 4 for the new
                       activity.

ARE-VAR-LEVEL-5        Alpha 15
Element: Variable LevelThis is variable level 5 for the new
                       activity.

ARE-VAR-LEVELS         Alpha 30
Element: Variable LevelThis field contains the variable levels
                       for the new activity.

                         ACACTREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARESET1   OLD-ACTIVITY                                           AC127   AC227
          COMPANY                                                AC229   AC27.1
          SUMMARY-TYPE                                           AC29.1  AC310
                                                                 AC50.1  AC500
                                                                 PW110   PW510
                                                                 SB15.1  SB515

ARESET2   ACTIVITY      KeyChange                                AC10.1  AC300
          OLD-ACTIVITY                                           AC310   AC502

ARESET4   OLD-ACTIVITY  KeyChange                                AC50.2  AC502
          ACTIVITY                                               AC51.1  AC510
                                                                 AC52.1  AC520
                                                                 AC54.1  AC540

                         ACACTREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Not Required

                            ARE-OLD-ACTIVITY    -> ACV-ACTIVITY

Activity       ACACTIVITY   Not Required

                            ARE-ACTIVITY        -> ACV-ACTIVITY