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