Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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