POMESSAGE FILE
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.
REFERENCED BY
PO251 POID.1
UPDATED BY
POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POM-COMPANY Numeric 4 POIJ.1
Company The company number.
POM-BUYER-CODE Alpha 3 POIJ.1
Buyer Code The user defined buyer identifier.
POM-MSG-DATE Numeric 8 (yyyymmdd) POIJ.1
Message Date The date the message was created.
POM-MSG-TIME Numeric 6 POIJ.1
Message Time The time the message was created.
POM-MSG-SEQ Numeric 6 POIJ.1
Message Sequence The message sequence number.
Number
POM-MESSAGE-TYPE Alpha 1 POIJ.1
Message Type The message type.
I = Invoice
M = Manual
R = Receiving
POM-DOCUMENT Alpha 10 (Right Justified)
Document ID This field identifies the document from
which this transaction record was
created.
POM-REC-NUMBER Numeric 10 POIJ.1
Receiver Number The receiver number. Assigned when
this receiving information was added.
POM-DOC-NBR-NUM Numeric 10 POIJ.1
Doc Nbr Num
POM-LINE-NBR Numeric 6 POIJ.1
Line Number This field contains the line number.
POM-PO-NUMBER Alpha 14 (Right Justified) POIJ.1
PO Number This field contains the number
representing the purchase order.
POM-PO-RELEASE Numeric 4 POIJ.1
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
POM-PO-CODE Alpha 4 POIJ.1
Po Code This is the purchase order code.
POM-RETURN-QTY Signed 13.4
Quantity Returned This is the quantity to be returned to
the vendor using Vendor Returns when an
over receiving buyer message is
released.
POM-LOCATION Alpha 5 POIJ.1
Location Code This field contains a valid stock
location within the company inventory.
POM-BATCH-NBR Numeric 6
Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
POM-VENDOR Alpha 9 (Right Justified) POIJ.1
Vendor ID The vendor's identification code.
POM-INVOICE Alpha 22 POIJ.1
Invoice Number Used to identify the invoice.
POM-SUFFIX Numeric 3 POIJ.1
Invoice Suffix This is the suffix for the invoice.
POM-COMMENT Alpha 40 (Lower Case) POIJ.1
Comment Line Occurs 4 Times
This field contains the comment
narrative.
POM-STATUS Numeric 1 POIJ.1
Status Status of record.
1 = Unreleased
2 = Released
POMESSAGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POMSET1 COMPANY PO251
BUYER-CODE
MSG-DATE
MSG-TIME
MSG-SEQ
POMSET2 COMPANY Subset
BUYER-CODE Where MESSAGE-TYPE = "M"
DOCUMENT
POMSET3 COMPANY Subset POIJ.1
REC-NUMBER Where (MESSAGE-TYPE = "R" )
LINE-NBR And (DOC-NBR-NUM = Zeroes )
POMSET4 COMPANY Subset
BATCH-NBR Where MESSAGE-TYPE = "I"
VENDOR
INVOICE
SUFFIX
PO-NUMBER
PO-RELEASE
LINE-NBR
POMSET5 COMPANY Subset POID.1 POIJ.1
REC-NUMBER Where MESSAGE-TYPE = "R"
LINE-NBR
DOC-NBR-NUM
POMESSAGE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 ((POM-ITEM-TYPE = "I" )
Or (POM-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-DOCUMENT -> 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
|
