WSElectronicOrder Web Service

WSElectronicOrder

Click here for a complete list of operations.

GetOrderHistory

This web service method allows the user to check order history. It returns a dataset containing real-time status on orders placed.

Input Values:
Key - Web service security key assigned by Keystone.
FullAccountNo - The 5-7 character account number provided by Keystone.
PONumber - The PONumber in question (this is an optional parameter).
FromDate - The date in which to start searching for order history. Must be in YYYYMMDD format.
ToDate - The date in which to stop searching for order history. Must be in YYYYMMDD format.
You may pass a PO Number, a range of dates, or both. Passing all three parameters
will cause the function to search for the PO within the range of dates specified (most efficient).
If no dates are specified, the entire available history will be searched. If only a date range is
passed, then all history from within that date range will be returned.
If there is no data available for your query, the field EKORD# will contain the 'NoData'.
If you pass bad data to the web method, the field EKORD# will contain 'BadInDt'.
Note: Using a date range of more than 30 days may cause a timeout because of the volume
of data. Please limit the range to 120 days.

Return Values:
EKCCUS - Customer Number - 7 Char
EKORD# - PO Number - 20 Char
EKDATE - Date Ordered - 8 Char (YYYYMMDD)
EKTIME - Time Ordered - 6 Char (HHMMSS) - if length is shorter than 6, zeros should be padded to the left)
EKVEND - Vendor Code - 3 Char
EKPART - Part Number - 20 Char
EKXQTY - Quantity - 5 Char
EKEXTD - Extended Price - 11 Char, 2 decimal places
EKFRTD - Freight Charge - 9 Char, 2 decimal places
EKSWHS - Ship Warehouse - 2 Char:
____ Whse 1 = Exeter, Pennsylvania (EAST)
____ Whse 14 = Kansas City, Kansas (MIDWEST)
____ Whse 25 = Eastvale, California (CALIFORNIA)
____ Whse 30 = Atlanta, Georgia (SOUTHEAST)
____ Whse 45 = Spokane, Washington (PACIFIC NORTHWEST)
____ Whse 50 = Flower Mound, Texas (TEXAS)
____ Whse 60 = Brownstown, Michigan (GREAT LAKES)
____ Whse 70 = Orlando, Florida (FLORIDA)
EKSVIA - Ship Method Code - 1 Char (6 = Keystone Truck Run, 2 = Fedex, 3 = UPS)
EKTRCK - Tracking Number - 30 Char
EKSTAT - Status Code - 7 Char
____ 3rd party shipping method values: RCV ORD, ORDER, PICK, PACKAGE, INVOICE, CANCEL
____ Keystone Truck Run method values: RCV ORD, ORDER, PICK, XDOCK, OUT4DLV, INVOICE, CANCEL
EKPRIC - Unit Price - 9 Char, 2 decimal places
EKKEY# - Keystone internal order number - 7 Char
EKINV# - Invoice Number - 11 Char, 0 decimal places

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /WSElectronicOrder/ElectronicOrder.asmx HTTP/1.1
Host: order.ekeystone.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://eKeystone.com/GetOrderHistory"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetOrderHistory xmlns="http://eKeystone.com">
      <Key>string</Key>
      <FullAccountNo>string</FullAccountNo>
      <PONumber>string</PONumber>
      <FromDate>string</FromDate>
      <ToDate>string</ToDate>
    </GetOrderHistory>
  </soap:Body>
</soap:Envelope>

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetOrderHistoryResponse xmlns="http://eKeystone.com">
      <GetOrderHistoryResult>
        <xsd:schema>schema</xsd:schema>xml</GetOrderHistoryResult>
    </GetOrderHistoryResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /WSElectronicOrder/ElectronicOrder.asmx HTTP/1.1
Host: order.ekeystone.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <GetOrderHistory xmlns="http://eKeystone.com">
      <Key>string</Key>
      <FullAccountNo>string</FullAccountNo>
      <PONumber>string</PONumber>
      <FromDate>string</FromDate>
      <ToDate>string</ToDate>
    </GetOrderHistory>
  </soap12:Body>
</soap12:Envelope>

HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <GetOrderHistoryResponse xmlns="http://eKeystone.com">
      <GetOrderHistoryResult>
        <xsd:schema>schema</xsd:schema>xml</GetOrderHistoryResult>
    </GetOrderHistoryResponse>
  </soap12:Body>
</soap12:Envelope>