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    AC51.1
AC510     AC52.1    AC520     AC54.1    AC540     GL312
GL313

UPDATED BY

AC10.1    AC29.1    AC300     AC310     AC500

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
                       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
                       associated with the old activity or
                       project.

ARE-SUMMARY-TYPE       Alpha 9                                   AC500
Element: Summary Type  Required key. This field is used for
                       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
Element: Company       Required key. This is the company for
                       the non-Lawson activity or the Lawson
                       6.0 or 6.1 project or summary type to be
                       upgraded.

ARE-60-SUMM-LEVEL      Alpha 1
Element: All Flag      This field indicates whether a Project
                       Accounting 6.0 summary-level summary
                       type exists: Yes or No.
                       Y = Yes
                       N = No

ARE-60-POST-EXIST      Alpha 1
Element: All Flag      This field indicates whether a Project
                       Accounting 6.0 posting-level summary
                       type exists: Yes or No.
                       Y = Yes
                       N = No

ARE-70-POST-ACT        Alpha 15
Element: 70 Post Act   This is the Activity Management 7.0
                       posting-level activity.

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

ARESET2   ACTIVITY      KeyChange                                AC10.1  AC300
          OLD-ACTIVITY                                           AC310

ARESET3   COMPANY
          SUMMARY-TYPE
          OLD-ACTIVITY

ARESET4   OLD-ACTIVITY  KeyChange                                AC51.1  AC510
          ACTIVITY                                               AC52.1  AC520
                                                                 AC54.1  AC540
                                                                 GL312   GL313

                         ACACTREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Not Required

                            ARE-OLD-ACTIVITY    -> ACV-ACTIVITY