Lawson Insight Technical Documentation |
|
ACACTMXVAL
ACACTMXVAL FILE
Activity List Attribute Values
This file contains activity attributes from AC13.1 (Activity Attributes) and
attribute values from AC13.2 (Values by Activity Attributes). It contains a
record for each activity level, with the level attribute from AC10.1
(Activity). The file includes the activity object ID and the attributes and
values assigned to the activity.
You can define unlimited attributes for the Activity Management system, to be
used in tracking additional information for reporting and analysis. You define
attributes in AC13.1.
REFERENCED BY
AC01.1 AC105 AC112 AC113 AC121 AC123
AC130 AC160 AC165 AC190 AC191 AC196
AC198 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC240 AC258 AC261 AC265
AC290 AC295 AC297 AC298 AC30.3 AC32.1
AC34.1 AC35.1 AC36.1 AC400 AC401 AC410
AC412 AC420 AC421 AC440 AC460 AC471
AC472 AC473 AC480 AC490 AC493 AC494
AC51.1 AC530 AC55.1 AC90.1 AC92.1 AC93.1
AC94.1 AC95.1 AC97.1 ACBA.1 ACVW.1 SE90.1
AR250 AR251 AR30.1 AR30.2 AR30.3 AR30.5
BR120 BR121 BR130 BR131 BR142 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR200 BR202 BR204 BR205 BR210
BR215 BR220 BR251 BR252 BR253 BR254
BR265 BR400 BR405 BR420 BR430 BR450
BR51.1 BR51.2 BR52.1 BR521 BR530 BR900
BRCC.1 MX123 MX202
UPDATED BY
AC10.1 AC110 AC120 AC13.1 AC13.2 AC135
AC300 AC310 AC500 AC510 MX500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AJV-OBJ-ID Numeric 12 AC10.1 AC110
Element: Object ID This field is used with activity AC120 AC13.1
attributes. Attribute matrix files are AC13.2 AC135
keyed by object ID. AC500 AC510
MX500
AJV-MATRIX-CAT Alpha 12 AC10.1 AC110
Element: Attribute This is an attribute value assigned to AC120 AC13.1
an activity to track additional AC13.2 AC135
information. Attribute values can then AC500 AC510
be used in selection and sorting for MX500
reporting and analysis.
AJV-MX-VALUE Alpha 32 AC10.1 AC110
Element: Attribute ValuThis is the value assigned to the AC120 AC13.1
attribute for the activity. AC13.2 AC135
AC500 AC510
MX500
AJV-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field displays the description.
ACACTMXVAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AJVSET1 OBJ-ID AC01.1 AC10.1
MATRIX-CAT AC105 AC110
AC112 AC113
AC120 AC121
AC123 AC13.1
AC13.2 AC13.3
AC130 AC135
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC258 AC261
...
AJVSET2 MATRIX-CAT KeyChange AC01.1 AC105
MX-VALUE AC112 AC113
OBJ-ID AC120 AC121
AC123 AC13.3
AC130 AC135
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
AC295 AC297
...
ACACTMXVAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
AJV-OBJ-ID -> ACV-OBJ-ID
Mxcatdef MXCATDEF Required
AJV-MATRIX-CAT -> MXC-MATRIX-CAT
Mxobjcat MXOBJCAT Required
"ACTVY" -> MOC-OBJ-TYPE
AJV-MATRIX-CAT -> MOC-MATRIX-CAT
ACACTMXVAL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Same Value ACACTMXVAL
AJV-MATRIX-CAT -> AJV-MATRIX-CAT
AJV-MX-VALUE -> AJV-MX-VALUE
AJV-OBJ-ID
|