Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICMXVAL


                              ICMXVAL FILE

REFERENCED BY

IC11.1    IC811     MX123     PO150     PO25.6    PO25.7
PO36.2    PO536

UPDATED BY

ICBL.3    MX500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IMV-IC-OBJ-ID          Numeric 12                                ICBL.3  MX500
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

IMV-MATRIX-CAT         Alpha 12                                  ICBL.3  MX500
Element: Matrix Cat    Attribute name assigned to an object
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

IMV-MX-VALUE           Alpha 32                                  ICBL.3  MX500
Element: Mx Value      The attribute value.

                         ICMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IMVSET1   IC-OBJ-ID                                              IC11.1  IC811
          MATRIX-CAT                                             ICBL.1  ICBL.2
                                                                 ICBL.3  MX123
                                                                 MX500   PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536

IMVSET2   MATRIX-CAT    KeyChange                                ICBL.1  ICBL.2
          MX-VALUE                                               MX123   MX500
          IC-OBJ-ID

                         ICMXVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemmast       ITEMMAST     Required

                            IMV-IC-OBJ-ID     -> ITE-IC-OBJ-ID

Mxcatdef       MXCATDEF     Required

                            IMV-MATRIX-CAT    -> MXC-MATRIX-CAT

Mxobjcat       MXOBJCAT     Required

                            "ITEM"            -> MOC-OBJ-TYPE
                            IMV-MATRIX-CAT    -> MOC-MATRIX-CAT