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 AC145 AC160 AC165 AC190 AC191
AC197 AC198 AC200 AC203 AC206 AC207
AC210 AC213 AC218 AC220 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 AC55.1 AC580 AC583
AC90.1 AC92.1 AC93.1 AC94.1 AC95.1 ACBA.1
ACDL.1 ACDM.2 ACVW.1 SE90.1 AP211 AR250
AR251 AR30.1 AR30.5 AR33.1 AR33.2 BR120
BR121 BR130 BR131 BR140 BR142 BR145
BR165 BR19.2 BR190 BR20.9 BR200 BR202
BR204 BR205 BR210 BR212 BR215 BR220
BR245 BR265 BR300 BR400 BR405 BR430
BR450 BR521 BR530 BR580 BRCC.1 MX123
MX202
UPDATED BY
AC10.1 AC110 AC120 AC13.1 AC13.2 AC135
AC300 AC310 AC500 AC510 BR10.7 BR10.8
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
BR10.8 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 BR10.8 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
BR10.7 BR10.8
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
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
...
AJVSET2 MATRIX-CAT KeyChange AC01.1 AC105
MX-VALUE AC112 AC113
OBJ-ID AC120 AC121
AC123 AC13.3
AC130 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC246 AC261
AC265 AC290
...
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
|