ACACTREL

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 AC502 AC51.1
AC510


UPDATED BY
AC10.1 AC29.1 AC300 AC50.1 AC50.2 AC500
AC52.1 AC520 AC54.1 AC540

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARE-OLD-ACTIVITY
Element: Old Activity
Alpha 35
Required key. This is the old activity or project, to be associated with a new activity.
AC29.1 AC500
ARE-ACTIVITY
Element: Activity
Alpha 15
Enter the name of the new activity associated with the old activity or project.
AC29.1 AC500
ARE-SUMMARY-TYPE
Element: Summary Type
Alpha 9
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.
AC500
ARE-COMPANY
Element: Company
Numeric 4
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.
AC500
ARE-OLD-VAR-LEV-1
Element: Old Variable Level 1
Alpha 15
This is the old variable level 1.
ARE-VAR-LEVEL-1
Element: Variable Level 1
Alpha 15
This is variable level 1 for the new activity.
ARE-VAR-LEVEL-2
Element: Variable Level 2
Alpha 15
This is variable level 2 for the new activity.
ARE-VAR-LEVEL-3
Element: Variable Level 3
Alpha 15
This is variable level 3 for the new activity.
ARE-VAR-LEVEL-4
Element: Variable Level 4
Alpha 15
This is variable level 4 for the new activity.
ARE-VAR-LEVEL-5
Element: Variable Level 5
Alpha 15
This is variable level 5 for the new activity.
ARE-VAR-LEVELS
Element: Variable Levels
Alpha 30
This field contains the variable levels for the new activity.


ACACTREL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARESET1 OLD-ACTIVITY
COMPANY
SUMMARY-TYPE
AC127 AC227
AC229 AC27.1
AC29.1 AC50.1
AC500
ARESET2 ACTIVITY
OLD-ACTIVITY
KeyChange
AC10.1 AC300
AC502
ARESET4 OLD-ACTIVITY
ACTIVITY
KeyChange
AC50.2 AC502
AC51.1 AC510
AC52.1 AC520
AC54.1 AC540


ACACTREL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Activity ACACTIVITY Not Required
ARE-ACTIVITY->ACV-ACTIVITY


File created: Thu Jun 09 11:03:48 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.