Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBMXVALUE


                             CBMXVALUE FILE

REFERENCED BY

CB00.3

UPDATED BY

CB01.4    CB01.5

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CMV-OBJ-ID             Numeric 12                                CB01.4  CB01.5
Object                 This is the object identifier. It is
Identification         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.

CMV-MATRIX-CAT         Alpha 12                                  CB01.4  CB01.5
Element: Attribute     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.

CMV-MX-VALUE           Alpha 32                                  CB01.4  CB01.5
Element: Attribute ValuThe attribute value.

                         CBMXVALUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMVSET1   OBJ-ID                                                 CB00.3  CB01.4
          MATRIX-CAT                                             CB01.5  CB01.7

CMVSET2   MATRIX-CAT    KeyChange                                CB01.7
          MX-VALUE
          OBJ-ID

                         CBMXVALUE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbcpycash      CBCPYCASH    Not Required

                            CMV-OBJ-ID        -> CBY-OBJ-ID

Matrix Cat     MXOBJCAT     Required

                            "CSHCD"           -> MOC-OBJ-TYPE
                            CMV-MATRIX-CAT    -> MOC-MATRIX-CAT

Mxcatdef       MXCATDEF     Required

                            CMV-MATRIX-CAT    -> MXC-MATRIX-CAT

                         CBMXVALUE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Same Value     CBMXVALUE

                            CMV-MATRIX-CAT    -> CMV-MATRIX-CAT
                            CMV-MX-VALUE      -> CMV-MX-VALUE
                                                 CMV-OBJ-ID