Destination Quantity (SDQ) is an optional segment that might be
received on an inbound purchase order (850).
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.
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.
SPLC01 - 1001
SPQT01 - 75
SPLC02 - 4242
SPQT02 - 25
X12 EDI 850 SET-UP
PID*F****Mountain Bike, Red
By: Sean Hoppe on