 |
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 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 BR142
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 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 AC500
keyed by object ID. 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 AC500
information. Attribute values can then AC510 MX500
be used in selection and sorting for
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 AC500
AC510 MX500
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 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 AC240
AC258 AC261
AC265 AC290
AC295 AC297
...
AJVSET2 MATRIX-CAT KeyChange AC01.1 AC105
MX-VALUE AC112 AC120
OBJ-ID AC121 AC123
AC13.3 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 AC240
AC258 AC261
AC265 AC290
AC295 AC297
AC298 AC30.3
AC310 AC32.1
...
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
|