|
|
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
|
