Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POMATCHOBJ


                            POMATCHOBJ FILE

REFERENCED BY

AP131     AP30.4    PO00.1

UPDATED BY

MA61.1    MA66.2    MA70.1    MA75.1    MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PMJ-COMPANY            Numeric 4                                 MA61.1  MAI1.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PMJ-REC-NUMBER         Numeric 10                                MA61.1  MAI1.1
Element: Receiver NumbeThe receiver number.  Assigned when
                       this receiving information was added.

PMJ-LINE-NBR           Numeric 6                                 MA61.1  MAI1.1
Element: Line Number   This field contains the line number.

PMJ-MATCH-OBJ-ID       Numeric 12                                MA61.1  MAI1.1
Object
Identification

PMJ-MATCH-SEQ-NBR      Numeric 4                                 MA61.1  MAI1.1
Element: Match Seq Nbr

PMJ-VENDOR             Alpha 9  (Right Justified)                MA61.1  MAI1.1
Element: Vendor ID     The vendor's identification code.



PMJ-INVOICE            Alpha 22                                  MA61.1  MAI1.1
Element: Invoice NumberUsed to identify the invoice.

PMJ-SUFFIX             Numeric 3                                 MA61.1  MAI1.1
Element: Invoice SuffixThis is the suffix for the invoice.

PMJ-PO-NUMBER          Alpha 14  (Right Justified)               MA61.1  MAI1.1
Element: PO Number     This field contains the number
                       representing the purchase order.

PMJ-PO-RELEASE         Numeric 4                                 MA61.1  MAI1.1
Element: PO Release NumUsed to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

PMJ-PO-CODE            Alpha 4                                   MA61.1  MAI1.1
Element: Po Code       This is the purchase order code.

PMJ-PO-LINE-NBR        Numeric 6                                 MA61.1  MAI1.1
Element: Line Number   The PO line number this record is
                       associated with.

PMJ-ITEM               Alpha 32                                  MA61.1  MAI1.1
Element: Item Number   This field contains the item
                       identifier.

PMJ-MATCH-DTL-KEY      Alpha 85                                  MA61.1  MAI1.1
Element: Match Dtl Key

PMJ-MATCHED-QTY        Signed 13.4                               MA61.1  MA66.2
Element: Receiving Quantity                                      MAI1.1

PMJ-MATCH-UNIT-CST     Signed 18.5                               MA61.1  MAI1.1
Element: Intl Cost

PMJ-AOC-CODE           Alpha 2
Element: Add On Cost CoThis field contains the identifier for
                       the add on cost associated with this
                       line item.

                         POMATCHOBJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PMJSET1   COMPANY                                                AP131   AP30.4
          REC-NUMBER                                             MA61.1  MAI1.1
          LINE-NBR                                               PO00.1
          MATCH-OBJ-ID
          MATCH-SEQ-NBR
          AOC-CODE

PMJSET2   COMPANY                                                MA66.2  MA70.1
          MATCH-OBJ-ID                                           MA75.1
          MATCH-SEQ-NBR
          REC-NUMBER
          LINE-NBR
          AOC-CODE

                         POMATCHOBJ FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mainvdtl       MAINVDTL

                            PMJ-COMPANY    -> MAD-COMPANY
                            PMJ-VENDOR     -> MAD-VENDOR
                            PMJ-INVOICE    -> MAD-INVOICE
                            PMJ-SUFFIX     -> MAD-SUFFIX
                                              MAD-PO-NUMBER
                                              MAD-PO-RELEASE
                                              MAD-PO-CODE
                                              MAD-LINE-NBR
                                              MAD-SEQ-NBR