 |
Lawson Insight Technical Documentation |
|
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 AC121 AC123 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 DA233 DA240 GR240
SE90.1 AR250 AR251 AR30.1 AR30.2 AR30.3
AR30.5 BR120 BR121 BR130 BR131 BR142
BR165 BR200 BR202 BR204 BR205 BR210
BR220 BR265 BR400 BR405 BR420 BR430
BR450 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
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
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
Attribute Value This 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)
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 AC120
AC121 AC123
AC13.1 AC13.2
AC13.3 AC135
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
...
AJVSET2 MATRIX-CAT KeyChange AC01.1 AC105
MX-VALUE AC112 AC120
OBJ-ID AC121 AC123
AC13.3 AC135
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
AC295 AC297
AC298 AC30.3
...
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
|