POMESSAGE

Buyer Messages

This file contains information about purchase order receiving and approval tolerance exceptions and adhoc manually entered buyer messages. The receiving and approvals messages must be processed before their related receiving or approval can be released.
UPDATED 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 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POM-COMPANY
Element: Company		Numeric 4
The company number.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-BUYER-CODE
Element: Buyer		Alpha 3
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-MSG-DATE
Element: Date		Numeric 8 (yyyymmdd)
The date the message was created.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-MSG-TIME
Element: Update Time		Numeric 6
The time the message was created.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-MSG-SEQ
Element: Seq Number		Numeric 6
The message sequence number.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-MESSAGE-TYPE
Element: Message Type		Alpha 1
The message type.
M = Manual
R = Receiving
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-DOCUMENT
Element: Document		Alpha 10 (Right Justified)
This field identifies the document from which this transaction record was created.
POM-REC-NUMBER
Element: Rec Number		Numeric 10
The receiver number. Assigned when this receiving information was added.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-DOC-NBR-NUM
Element: Doc Nbr Num		Numeric 10
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-PO-RELEASE
Element: Po Release		Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-RETURN-QTY
Element: Quantity		Signed 13.4
This is the quantity to be returned to the vendor using Vendor Return (PO31.1) when an over receiving buyer message is released.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-LOCATION
Element: Location		Alpha 5
This field contains a valid stock location within the company inventory.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-BATCH-NBR
Element: Batch Nbr		Numeric 6
This identifies the batch the entered invoices, debit memos, and credit memos are a part of.
POM-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-INVOICE
Element: Invoice		Alpha 22
Used to identify the invoice.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-SUFFIX
Element: Suffix		Numeric 3
This is the suffix for the invoice.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-COMMENT
Element: Comment		Alpha 40 (Lower Case)
Occurs 4 Times
This field contains the comment narrative.
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-STATUS
Element: Status		Numeric 1
Status of record.
1 = Unreleased
2 = Released
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-SUBST-FLAG
Element: Subst Flag		Numeric 1

0 = Not a Substitute Item Message
1 = Substitute Item Message
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-OVERRECVD-FLAG
Element: Overrecvd Flag		Numeric 1

0 = Not a Overreceiving Message
1 = Overreceiving Message
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-UNIT-COST-FLAG
Element: Unit Cost Flag		Numeric 1

0 = Not a Vendor Unit Cost Message
1 = Vendor Unit Cost Message
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
POM-REFERENCE-NO
Element: Reference No		Alpha 10 (Right Justified)


POMESSAGE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POMSET1 COMPANY
BUYER-CODE
MSG-DATE
MSG-TIME
MSG-SEQ
POMSET2 COMPANY
BUYER-CODE
DOCUMENT
Subset
WhereMESSAGE-TYPE ="M"
POMSET3 COMPANY
REC-NUMBER
LINE-NBR
Subset
Where(MESSAGE-TYPE ="R")
And(DOC-NBR-NUM =Zeroes)
...
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
POMSET4 COMPANY
BATCH-NBR
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
LINE-NBR
Subset
WhereMESSAGE-TYPE ="I"
MA41.4
POMSET5 COMPANY
REC-NUMBER
LINE-NBR
DOC-NBR-NUM
Subset
WhereMESSAGE-TYPE ="R"
...
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


POMESSAGE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
POM-COMPANY->CPY-COMPANY
Apinvoice APINVOICE Required
POM-COMPANY->API-COMPANY
PCR-VENDOR->API-VENDOR
POM-INVOICE->API-INVOICE
Zeroes->API-SUFFIX
Zeroes->API-CANCEL-SEQ
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
POM-VENDOR->VEN-VENDOR
Buyer BUYER Required
PCY-PROCURE-GROUP->BUY-PROCURE-GROUP
POM-BUYER-CODE->BUY-BUYER-CODE
Iccompany ICCOMPANY Required
POM-COMPANY->ICC-COMPANY
Itemloc ITEMLOC Not Required
POM-COMPANY->ITL-COMPANY
PRL-LOCATION->ITL-LOCATION
PRL-ITEM->ITL-ITEM
Itemmast ITEMMAST Required
When POM-PO-NUMBER !=Spaces
And((PLI-ITEM-TYPE ="I" )
Or(PLI-ITEM-TYPE ="N" ))
ICC-ITEM-GROUP->ITE-ITEM-GROUP
PLI-ITEM->ITE-ITEM
Po Company POCOMPANY Required
POM-COMPANY->PCY-COMPANY
Poline POLINE Required
When POM-LINE-NBR !=Zeroes
POM-COMPANY->PLI-COMPANY
POM-PO-NUMBER->PLI-PO-NUMBER
POM-PO-RELEASE->PLI-PO-RELEASE
POM-PO-CODE->PLI-PO-CODE
POM-LINE-NBR->PLI-LINE-NBR
Porecline PORECLINE Required
When POM-MESSAGE-TYPE ="R"
POM-COMPANY->PRL-COMPANY
POM-REC-NUMBER->PRL-REC-NUMBER
POM-LINE-NBR->PRL-LINE-NBR
Purchorder PURCHORDER Required
When POM-PO-NUMBER !=Spaces
POM-COMPANY->PCR-COMPANY
POM-PO-CODE->PCR-PO-CODE
POM-PO-NUMBER->PCR-PO-NUMBER
POM-PO-RELEASE->PCR-PO-RELEASE
Receiver PORECEIVE Required
When POM-REC-NUMBER !=Zeroes
POM-COMPANY->POR-COMPANY
POM-REC-NUMBER->POR-REC-NUMBER

File created: Wed Jun 08 20:50:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.