|
|
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
|
