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 AC720
AC51.1 AC510 AC52.1 AC520 AC54.1 AC540
GL312 GL313
UPDATED BY
AC29.1 AC300 AC310 AC500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARE-OLD-ACTIVITY Alpha 35 AC29.1 AC500
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
Activity Enter the name of the new activity AC500
associated with the old activity or
project.
ARE-SUMMARY-TYPE Alpha 9 AC500
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
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
60 Summ Level 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
f 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
70 Post Act This is the Activity Management 7.0
posting-level activity.
ARE-OLD-VAR-LEV-1 Alpha 15
Old Variable Level 1 This is the old variable level 1.
ARE-VAR-LEVEL-1 Alpha 15
Variable Level 1 This is variable level 1 for the new
activity.
ARE-VAR-LEVEL-2 Alpha 15
Variable Level 2 This is variable level 2 for the new
activity.
ARE-VAR-LEVEL-3 Alpha 15
Variable Level 3 This is variable level 3 for the new
activity.
ARE-VAR-LEVEL-4 Alpha 15
Variable Level 4 This is variable level 4 for the new
activity.
ARE-VAR-LEVEL-5 Alpha 15
Variable Level 5 This is variable level 5 for the new
activity.
ARE-VAR-LEVELS Alpha 30
Variable Levels This 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
AC720
ARESET2 ACTIVITY KeyChange AC300 AC310
OLD-ACTIVITY
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
|
