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 AC120 AC121
AC123 AC128 AC130 AC145 AC16.3 AC160
AC165 AC169 AC190 AC191 AC197 AC198
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC261
AC265 AC290 AC295 AC298 AC30.3 AC32.1
AC34.1 AC346 AC35.1 AC36.1 AC400 AC401
AC410 AC412 AC420 AC421 AC440 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC51.1 AC527 AC55.1 AC580 AC583
AC90.1 AC92.1 AC93.1 AC94.1 AC95.1 ACBA.1
ACDL.1 ACDM.2 ACDM.9 ACVW.1 ATVW.1 SE90.1
AP211 AR21.2 AR237 AR239 AR250 AR251
AR257 AR27.2 AR29.1 AR296 AR30.1 AR30.5
AR32.1 AR33.1 AR33.2 AR38.5 AR39.1 AR39.2
AR39.3 AR39.4 AR42.1 AR42.2 AR42.7 AR43.1
AR502 AR503 AR55.1 AR560 AR575 AR800
AR91.1 ARLL.1 BR120 BR121 BR130 BR131
BR140 BR142 BR145 BR151 BR152 BR153
BR154 BR155 BR156 BR157 BR165 BR19.2
BR190 BR20.9 BR200 BR202 BR204 BR205
BR210 BR212 BR215 BR220 BR245 BR251
BR252 BR253 BR254 BR265 BR300 BR400
BR405 BR422 BR430 BR450 BR51.1 BR51.2
BR52.1 BR521 BR530 BR580 MX123 MX202
SN02.1 SNAC.1
UPDATED BY
AC10.1 AC110 AC13.1 AC13.2 AC135 AC300
AC310 AC500 AC510 AC560 BR10.7 BR10.8
MX500 PW110 PW510
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AJV-OBJ-ID Numeric 12 AC110 AC13.1
Element: Object ID This field is used with activity AC13.2 AC135
attributes. Attribute matrix files are AC500 AC510
keyed by object ID. AC560 BR10.8
MX500 PW110
PW510
AJV-MATRIX-CAT Alpha 12 AC110 AC13.1
Element: Attribute This is an attribute value assigned to AC13.2 AC135
an activity to track additional AC500 AC510
information. Attribute values can then AC560 BR10.8
be used in selection and sorting for MX500 PW110
reporting and analysis. PW510
AJV-MX-VALUE Alpha 32 AC110 AC13.1
Element: Attribute ValuThis is the value assigned to the AC13.2 AC135
attribute for the activity. AC500 AC510
AC560 BR10.7
BR10.8 MX500
PW110 PW510
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 AC128
AC13.1 AC13.2
AC13.3 AC130
AC135 AC145
AC16.3 AC160
AC165 AC169
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
...
AJVSET2 MATRIX-CAT KeyChange AC01.1 AC105
MX-VALUE AC112 AC113
OBJ-ID AC120 AC121
AC123 AC128
AC13.3 AC130
AC135 AC145
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
AC240 AC246
...
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
|