Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

APVNMXVAL


                             APVNMXVAL FILE

REFERENCED BY

AM115     AM117     AM15.1    AM15.2    AM15.3    AM15.4
AM20.1    AM20.3    AM21.1    AM21.3    AM500     AM51.1
AM551     AM97.1    AP10.1    AP510     API3.1    API4.1
IC840     PR05.1    PR05.3    PR226     PR247     PR26.1
PR47.1    UK47.1

UPDATED BY

AP03.1    AP03.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

VMX-AP-OBJ-ID          Numeric 12                                AP03.1  AP03.2
Object
Identification

VMX-MATRIX-CAT         Alpha 12                                  AP03.1  AP03.2
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.

VMX-MX-VALUE           Alpha 32                                  AP03.1  AP03.2
Element: Attribute ValuThe attribute value.

                         APVNMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VMXSET1   AP-OBJ-ID                                              AM115   AM117
          MATRIX-CAT                                             AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP03.1  AP03.2
                                                                 AP03.3  AP10.1
                                                                 AP510   API3.1
                                                                 API4.1  IC840
                                                                 PR05.1  PR05.3
                                                                 PR226   PR247
                                                                 PR26.1  PR47.1
                                                                 UK47.1

VMXSET2   MATRIX-CAT    KeyChange                                AM115   AM117
          MX-VALUE                                               AM15.1  AM15.2
          AP-OBJ-ID                                              AM15.3  AM15.4
                                                                 AM20.1  AM20.3
                                                                 AM21.1  AM21.3
                                                                 AM500   AM51.1
                                                                 AM551   AM97.1
                                                                 AP03.3  AP510
                                                                 API3.1  API4.1
                                                                 IC840   PR05.1
                                                                 PR05.3  PR226
                                                                 PR247   PR26.1
                                                                 PR47.1  UK47.1

                         APVNMXVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvenmast      APVENMAST    Required

                            VMX-AP-OBJ-ID     -> VEN-AP-OBJ-ID

Mxcatdef       MXCATDEF     Required

                            VMX-MATRIX-CAT    -> MXC-MATRIX-CAT

Mxobjcat       MXOBJCAT     Required

                            "VENDR"           -> MOC-OBJ-TYPE
                            VMX-MATRIX-CAT    -> MOC-MATRIX-CAT