SeanHoppe.com > CLEO Tips > CLEO JDE Tips > 4 Using F47013 for POs with SDQ Segments

Using F47013 for POs with SDQ Segments

4th May 2015

Shipment Destination Quantity (SDQ) is an optional segment that might be received on an inbound purchase order (850).

If trading partners want items on a single order to be shipped to various destinations, users can populate information for multiple Ship To locations to the Shipment Destination Quantity (SDQ) table.

Note: The Sold To location must be the same for all Ship To locations.

Minimum Required Fields:

SPEKCO - EDI Key Company
SPEDOC - EDI Key Document Number
SPEDCT - EDI Key Document Type
SPEDLN - EDI Key Line Number

Note:  The EKCO, EDOC, EDCT and EDLN must be the same values as they are in EDI Purchase Order Header (F47011) and EDI Purchase Order Detail (F47012) and SDQ (F47013) records.

SPLC01 to SPLC10 - Ship To (Depending on the number of SDQs, the LC01 to LC10 need to be populated with the appropriate Ship To address book number.)
SPUITM - Item Number

SPQT01 to SPQT10 - Quantity

  • Note: For SDQ functionality, AN8 (Sold To) must be populated in both EDI Purchase Order Header (F47011) and EDI Purchase Order Detail (F47012), and SHAN (Ship To) must be blank in both EDI Purchase Order Header (F47011) and EDI Purchase Order Detail (F47012).

SPEDSQ - Record Sequence

  • Each record relates back to a single EDI Purchase Order Detail (F47012) record.  When the next EDI Purchase Order Detail (F47012) record is processed, the count must be reset to value of 1.

SDQ Example

The EDI Purchase Order Detail (F47012) has item number 2001 with a quantity of 10. The Sold To address is 59334, but the Ship To address is left blank, because the quantity of 10 will be split between multiple Ship To addresses.

The EDI Purchase Order Detail SDQ (F47013) record is used to determine how the 10 units are shipped to different locations. In this case the Ship To location 01 (address 5225) will receive 5 units and the Ship To location 02 (address 59334) will receive the remaining 5 units.

F47013 SET-UP

SPLC01 - 1001
SPQT01 - 75
SPLC02 - 4242
SPQT02 - 25

X12 EDI 850 SET-UP

GS*PO*3034881418*3033771916*970903*1338
ST*850*170001
BEG*00*PO*5439**970827
DTM*002*970827
PO1*1000*100*EA*798**BP*M001
PID*F****Mountain Bike, Red
SDQ*EA*ZZ*1001*75*4242*25*


By: on
load('http://www.seanhoppe.com/EXTOL-Blog-Feed2/'); $feed2 = array(); foreach ($rss2->getElementsByTagName('item') as $node2) { $item2 = array ( 'title' => $node2->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node2->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node2->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node2->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed2, $item2); } $limit2 = 5; $rss3 = new DOMDocument(); $rss3->load('http://www.ebithree.com/EBIThree-RSS/'); $feed3 = array(); foreach ($rss3->getElementsByTagName('item') as $node3) { $item3 = array ( 'title' => $node3->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node3->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed3, $item3); } $limit3 = 5; $rss4 = new DOMDocument(); //$rss4->load('http://www.ebithree.com/EBIThree-RSS/'); $rss4->load('http://www.ebiworld.com/EBI-Feed/'); $feed4 = array(); foreach ($rss4->getElementsByTagName('item') as $node4) { $item4 = array ( 'title' => $node4->getElementsByTagName('title')->item(0)->nodeValue, 'link' => $node4->getElementsByTagName('link')->item(0)->nodeValue, ); array_push($feed4, $item4); } $limit4 = 5; echo ' '; ?>