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 AC229 AC27.1 AC50.1 AC950 AC951
AC952 AM951 AM955 AP950 AP952 AP960
AP961 AR951 BL960 BL961 BL963 BL96A
BL96B BL96C BL96D CB952 GL950 GL951
IC963 OE963 OE964 PO990 RQ961 RQ990
SA960 SA961 AC51.1 AC510 AC52.1 AC520
AC54.1 AC540 GL312 GL313
UPDATED BY
AC29.1 AC300 AC310 AC500 AC730
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARE-OLD-ACTIVITY Alpha 35 AC29.1 AC500
Old Activity Required key. This is the old activity AC730
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 AC730
associated with the old activity or
project.
ARE-SUMMARY-TYPE Alpha 9 AC500 AC730
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 AC730
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 AC730
6.0 Summary 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 AC730
6.0 Posting Level This field indicates whether a Project
Exists Accounting 6.0 posting-level summary
type exists: Yes or No.
Y = Yes
N = No
ARE-70-POST-ACT Alpha 15 AC730
7.0 Posting Activity This is the Activity Management 7.0
posting-level activity.
ARE-OLD-VAR-LEV-1 Alpha 15 AC730
Old Variable Level 1 This is the old variable level 1.
ARE-VAR-LEVEL-1 Alpha 15 AC730
Variable Level 1 This is variable level 1 for the new
activity.
ARE-VAR-LEVEL-2 Alpha 15 AC730
Variable Level 2 This is variable level 2 for the new
activity.
ARE-VAR-LEVEL-3 Alpha 15 AC730
Variable Level 3 This is variable level 3 for the new
activity.
ARE-VAR-LEVEL-4 Alpha 15 AC730
Variable Level 4 This is variable level 4 for the new
activity.
ARE-VAR-LEVEL-5 Alpha 15 AC730
Variable Level 5 This is variable level 5 for the new
activity.
ARE-VAR-LEVELS Alpha 30 AC730
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 AC229
COMPANY AC27.1 AC29.1
SUMMARY-TYPE AC310 AC50.1
AC500 AC730
AC950 AC951
AC952 AM951
AM955 AP950
AP952 AP960
AP961 AR951
BL960 BL961
BL963 BL96A
BL96B BL96C
BL96D CB952
GL950 GL951
IC963 OE963
...
ARESET2 ACTIVITY KeyChange AC300 AC310
OLD-ACTIVITY
ARESET3 COMPANY AM951 AM955
SUMMARY-TYPE AP950 AP952
OLD-ACTIVITY AP960 AP961
AR951 BL960
BL961 BL963
BL96A BL96B
BL96C BL96D
CB952 GL950
GL951 IC963
OE963 OE964
PO990 RQ961
RQ990 SA960
SA961
ARESET4 OLD-ACTIVITY KeyChange AC51.1 AC510
ACTIVITY AC52.1 AC520
AC54.1 AC540
GL312 GL313
ARESET5 COMPANY Duplicates
OLD-VAR-LEV-1
ARESET6 VAR-LEVELS Duplicates
ACACTREL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Not Required
ARE-OLD-ACTIVITY -> ACV-ACTIVITY (ACVSET1)
|