Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POMXVAL


                              POMXVAL FILE

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    AP510     API1.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
IC02.1    IC12.1    IC330     MA180     MA278     MA41.1
MA41.2    MA41.4    MA41.7    MA43.1    MA43.2    MA43.3
MA43.7    MA53.1    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PO04.1    PO04.2    PO04.5    PO04.6    PO10.1
PO10.2    PO100     PO101     PO115     PO120     PO122
PO131     PO15.1    PO15.2    PO150     PO20.1    PO204
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO220     PO224     PO225     PO229     PO23.1    PO230
PO234     PO24.1    PO25.1    PO25.5    PO25.6    PO25.7
PO251     PO27.2    PO275     PO276     PO277     PO280
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO32.4    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POI3.1    POID.1
POII.1    POIJ.1    RQ01.1    RQ10.1    RQ10.2    RQ10.3
RQ11.1    RQ13.2    RQ35.1    RQ44.1    RQ500     RQ810
RQIB.1    RQIF.1    RQII.1    RQIJ.1    WH20.2    WH20.7


UPDATED BY

MX500     POBL.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PMV-BUY-OBJ-ID         Numeric 12                                MX500   PO04.6
Element: Obj Id        This is the object identifier. It is      POBL.3
                       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.

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

PMV-MX-VALUE           Alpha 32                                  MX500   PO04.6
Element: Mx Value      The attribute value.                      POBL.3

                         POMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PMVSET1   BUY-OBJ-ID                                             AP125   AP126
          MATRIX-CAT                                             AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 AP510   API1.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 ...

PMVSET2   MATRIX-CAT    KeyChange                                MX500   POBL.1
          MX-VALUE
          BUY-OBJ-ID

                         POMXVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Buyer          BUYER        Required

                            PMV-BUY-OBJ-ID    -> BUY-BUY-OBJ-ID

Mxcatdef       MXCATDEF     Required

                            PMV-MATRIX-CAT    -> MXC-MATRIX-CAT

Mxobjcat       MXOBJCAT     Required

                            "BUYER"           -> MOC-OBJ-TYPE
                            PMV-MATRIX-CAT    -> MOC-MATRIX-CAT