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 PO122 PO20.1 PO21.3 PO22.2 PO22.3
PO34.1 PO35.1 RQ10.1 RQ10.2 AP125 AP126
AP225 AP226 AP26.1
UPDATED BY
AP25.3 MA300 MA40.1 MA41.1 MA41.2 MA41.4
MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4
MA52.1 MA530 MA540 PO30.1 PO30.2 PO31.1
PO50.1 PO52.1 PO530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POM-COMPANY Numeric 4 MA43.1 MA43.2
Company The company number. MA43.3 MA52.1
MA530 MA540
PO30.1 PO30.2
PO31.1 PO50.1
PO52.1 PO530
POM-BUYER-CODE Alpha 3 MA43.1 MA43.2
Buyer Code The user defined buyer identifier. MA43.3 MA530
MA540 PO30.1
PO30.2 PO31.1
PO50.1 PO530
POM-MSG-DATE Numeric 8 (yyyymmdd) MA43.1 MA43.2
Message Date The date the message was created. MA43.3 MA530
MA540 PO30.1
PO30.2 PO31.1
PO50.1 PO530
POM-MSG-TIME Numeric 6 MA43.1 MA43.2
Message Time The time the message was created. MA43.3 MA530
MA540 PO30.1
PO30.2 PO31.1
PO50.1 PO530
POM-MSG-SEQ Numeric 6 MA43.1 MA43.2
Message Sequence The message sequence number. MA43.3 MA530
Number MA540 PO30.1
PO30.2 PO31.1
PO50.1 PO530
POM-MESSAGE-TYPE Alpha 1 MA43.1 MA43.2
Message Type The message type. MA43.3 MA52.1
I = Invoice MA530 MA540
M = Manual PO30.1 PO30.2
R = Receiving PO31.1 PO50.1
PO52.1 PO530
POM-DOCUMENT Alpha 10 (Right Justified) PO50.1
Document ID This field identifies the document from
which this transaction record was
created.
POM-PO-NUMBER Alpha 7 (Right Justified) MA43.1 MA43.2
PO Number This field contains the number MA43.3 MA52.1
representing the purchase order. MA530 MA540
PO30.1 PO30.2
PO31.1 PO50.1
PO530
POM-PO-RELEASE Numeric 6 MA43.1 MA43.2
PO Release Number Used to identify a purchase order MA43.3 MA52.1
release (created from a Blanket or MA530 MA540
Standing order). PO30.1 PO30.2
PO31.1 PO50.1
PO530
POM-LINE-NBR Numeric 6 MA43.1 MA43.2
Line Number This field contains the line number. MA43.3 MA52.1
MA530 MA540
PO30.1 PO30.2
PO31.1 PO50.1
PO52.1 PO530
POM-REC-NUMBER Alpha 10 (Right Justified) PO30.1 PO30.2
Receiver Number The receiver number. Assigned when PO50.1 PO52.1
this receiving information was added. PO530
POM-LOCATION Alpha 5 PO30.1 PO30.2
Location Code This field contains a valid stock PO530
location within the company inventory.
POM-BATCH-NBR Numeric 6 AP25.3 MA43.1
Batch Number This identifies the batch the entered MA43.2 MA43.3
invoices, debit memos, and credit memos MA52.1 MA530
are a part of. MA540 PO31.1
PO50.1
POM-VENDOR Alpha 9 MA43.1 MA43.2
Vendor ID The vendor's identification code. MA43.3 MA52.1
MA530 MA540
PO30.1 PO30.2
PO31.1 PO50.1
PO530
POM-INVOICE Alpha 22 MA43.1 MA43.2
Invoice Number Used to identify the invoice. MA43.3 MA52.1
MA530 MA540
PO30.1 PO30.2
PO31.1 PO50.1
PO530
POM-SUFFIX Numeric 3 MA52.1 PO30.1
Invoice Suffix This is the suffix for the invoice. PO30.2 PO50.1
PO530
POM-COMMENT Alpha 40 (Lower Case) MA52.1 PO50.1
Comment Line Occurs 4 Times PO52.1
This field contains the comment
narrative.
POM-STATUS Numeric 1 MA43.1 MA43.2
Status Status of record. MA43.3 MA52.1
1 = Unreleased MA530 MA540
2 = Released PO30.1 PO30.2
PO31.1 PO50.1
PO52.1 PO530
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 PO50.1
BUYER-CODE Where MESSAGE-TYPE = "M"
DOCUMENT
POMSET3 COMPANY Subset MA300 MA40.1
REC-NUMBER Where MESSAGE-TYPE = "R" MA40.2 MA41.1
LINE-NBR MA41.2 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA52.1 MA530
MA540 PO122
PO20.1 PO21.3
PO22.2 PO22.3
PO30.1 PO30.2
PO31.1 PO34.1
PO35.1 PO52.1
PO530 RQ10.1
RQ10.2
POMSET4 COMPANY Subset AP125 AP126
BATCH-NBR Where MESSAGE-TYPE = "I" AP225 AP226
VENDOR AP25.1 AP25.2
INVOICE AP25.3 AP26.1
SUFFIX MA300 MA40.1
PO-NUMBER MA40.2 MA41.1
PO-RELEASE MA41.2 MA41.4
LINE-NBR MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1 MA530
MA540 PO122
PO20.1 PO21.3
PO22.2 PO22.3
PO30.1 PO31.1
...
POMESSAGE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apbatch APBATCH Required
When POM-BATCH-NBR != Zeroes
POM-COMPANY -> APB-COMPANY
POM-BATCH-NBR -> APB-BATCH-NUM
Apcompany APCOMPANY Required
POM-COMPANY -> CPY-COMPANY
Apinvoice APINVOICE Required
When POM-BATCH-NBR != Zeroes
POM-COMPANY -> API-COMPANY
POM-VENDOR -> API-VENDOR
POM-INVOICE -> API-INVOICE
POM-SUFFIX -> API-SUFFIX
Zeroes -> API-CANCEL-SEQ
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
POM-VENDOR -> VEN-VENDOR
Buyer BUYER Required
POM-COMPANY -> BUY-COMPANY
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 Not Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
PLI-ITEM -> ITE-ITEM
Po Company POCOMPANY Required
POM-COMPANY -> PCY-COMPANY
Poinvoice POINVOICE Required
POM-COMPANY -> POI-COMPANY
POM-PO-NUMBER -> POI-PO-NUMBER
POM-PO-RELEASE -> POI-PO-RELEASE
POM-VENDOR -> POI-VENDOR
POM-INVOICE -> POI-INVOICE
Zeroes -> POI-SUFFIX
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-LINE-NBR -> PLI-LINE-NBR
Porecline PORECLINE Required
When POM-MESSAGE-TYPE = "R"
POM-COMPANY -> PRL-COMPANY
"PO" -> PRL-DOC-TYPE
POM-REC-NUMBER -> PRL-DOCUMENT
POM-LINE-NBR -> PRL-LINE-NBR
Purchorder PURCHORDER Required
When POM-PO-NUMBER != Spaces
POM-COMPANY -> PCR-COMPANY
POM-PO-NUMBER -> PCR-PO-NUMBER
POM-PO-RELEASE -> PCR-PO-RELEASE
Receiver PORECEIVE Required
When POM-REC-NUMBER != Spaces
POM-COMPANY -> POR-COMPANY
POM-REC-NUMBER -> POR-REC-NUMBER
POMESSAGE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poapprove POAPPROVE Required
When POM-MESSAGE-TYPE = "I"
POM-COMPANY -> POA-COMPANY
POM-VENDOR -> POA-VENDOR
POM-INVOICE -> POA-INVOICE
POM-SUFFIX -> POA-SUFFIX
POM-PO-NUMBER -> POA-PO-NUMBER
POM-PO-RELEASE -> POA-PO-RELEASE
POM-LINE-NBR -> POA-LINE-NBR
POA-AOC-CODE
|