ODBC Driver for Amazon Marketplace

Build 20.0.7695


Returns a list of items in a specified inbound shipment.


The 本製品 will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品. For example, the following query is processed server side:

SELECT * FROM InboundShipments  WHERE ShipmentId = '503-9993250-1405404'
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.


Name Type References Description
ShipmentId [KEY] String


The ID of the shipment.
SellerSKU [KEY] String The Seller SKU of the item.
QuantityShipped Int The item quantity that you are shipping.
QuantityInCase Int The item quantity in each case, for case-packed items.
QuantityReceived Int The item quantity that has been received at an Amazon fulfillment center.
FulfillmentNetworkSKU String Amazon's fulfillment network SKU of the item.
PrepDetailsListPrepInstruction String Preparation instructions for shipping an item to Amazon's fulfillment network.
PrepDetailsListPrepOwner String Indicates who will prepare the item.
ReleaseDate Date The date that a pre-order item will be available for sale.


SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
LastUpdatedDate Datetime

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695