Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POMATCHOBJ


                            POMATCHOBJ FILE

REFERENCED BY

AP131     MA60.3    MA68.3    MA90.2    MA90.3    MA90.5
PO00.1    PO278

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PMJ-COMPANY            Numeric 4                                 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                                MAI1.1
Element: Rec Number    The receiver number.  Assigned when
                       this receiving information was added.

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

PMJ-MATCH-OBJ-ID       Numeric 12                                MAI1.1
Element: Obj Id        This is the object identifier. It is
                       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.

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

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



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

PMJ-SUFFIX             Numeric 3                                 MAI1.1
Element: Suffix        This is the suffix for the invoice.

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

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

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

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

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

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

PMJ-MATCHED-QTY        Signed 13.4                               MA66.2  MAI1.1
Element: Rec Qty       This is the total quantity to date
                       received for this ordered item.

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

PMJ-AOC-CODE           Alpha 2                                   MAI1.1
Element: Aoc Code      This 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   MA60.3
          REC-NUMBER                                             MA68.3  MA70.1
          LINE-NBR                                               MA75.1  MA90.2
          MATCH-OBJ-ID                                           MA90.3  MA90.5
          MATCH-SEQ-NBR                                          MAI1.1  PO00.1
          AOC-CODE                                               PO278

PMJSET2   COMPANY                                                MA66.1  MA66.2
          MATCH-OBJ-ID                                           MA70.1  MA75.1
          MATCH-SEQ-NBR                                          MA90.2  MA90.3
          REC-NUMBER                                             MA90.5
          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