Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBMXVALUE


                             CBMXVALUE FILE

                       Cash Code Attribute Value

REFERENCED BY

AP150     AP155     AP160     AP161     AP265     CB00.3
CB145     CB170     CB175     CB180     CB186     CB187
CB210     CB215     CB220     CB221     CB260     CB286
CB62.1    CBBC.1    MX123

UPDATED BY

CB01.4    CB01.5    CB162     MX500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CMV-OBJ-ID             Numeric 12                                CB01.4  CB01.5
Element: Obj Id        This is the object identifier. It is      CB162   MX500
                       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: Matrix Cat    Attribute name assigned to an object      CB162   MX500
                       (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: Mx Value      The attribute value.                      CB162   MX500

                         CBMXVALUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMVSET1   OBJ-ID                                                 AP150   AP155
          MATRIX-CAT                                             AP160   AP161
                                                                 AP265   CB00.3
                                                                 CB01.4  CB01.5
                                                                 CB01.7  CB145
                                                                 CB162   CB170
                                                                 CB175   CB180
                                                                 CB186   CB187
                                                                 CB210   CB215
                                                                 CB220   CB221
                                                                 CB260   CB286
                                                                 CB62.1  CBBC.1
                                                                 MX123   MX500

CMVSET2   MATRIX-CAT    KeyChange                                AP150   AP155
          MX-VALUE                                               AP160   AP161
          OBJ-ID                                                 AP265   CB01.7
                                                                 CB145   CB170
                                                                 CB175   CB180
                                                                 CB186   CB187
                                                                 CB210   CB215
                                                                 CB220   CB221
                                                                 CB260   CB286
                                                                 MX123   MX500

                         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