InboundShipmentsCData ODBC Driver for Amazon Marketplace 2019 - Build 19.0.7354
Returns a list of inbound shipments based on criteria that you specify.
The driver 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 driver.
For example, the following query is processed server side:
SELECT * FROM InboundShipments
SELECT * FROM InboundShipments WHERE ShipmentStatus = 'Working'
SELECT * FROM InboundShipments WHERE ShipmentStatus IN ('Working','SHIPPED','IN_TRANSIT')
SELECT * FROM InboundShipments WHERE ShipmentId = '503-9993250-1405404'
SELECT * FROM InboundShipments WHERE LastUpdatedDate >= '2016-12-12'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.
|ShipmentId [KEY]||String||The ID of the shipment.|
|ShipmentStatus||String||The status of your inbound shipment. Possible values are WORKING, SHIPPED, IN_TRANSIT, DELIVERED, CHECKED_IN, RECEIVING, CLOSED, CANCELLED, DELETED, and ERROR.|
|ShipmentName||String||The unique name of the inbound shipment.|
|ShipFromPostalCode||String||The PostalCode of the return address.|
|ShipFromName||String||The Name of the return address.|
|ShipFromCountryCode||String||The CountryCode of the return address.|
|ShipFromStateOrProvinceCode||String||The State Or Province Code of the return address.|
|ShipFromAddressLine1||String||The AddressLine of the return address.|
|ShipFromCity||String||The City of the return address.|
|LabelPrepType||String||The type of label preparation.|
|AreCasesRequired||Boolean||Boolean that indicates whether or not an inbound shipment contains case-packed boxes.|
|DestinationFulfillmentCenterId||String||The Amazon fulfillment center identifier created by Amazon.|
|ConfirmedNeedByDate||Date||Date that the shipment must arrive at an Amazon fulfillment center for pre-ordered items.|
|EstimatedBoxContentsFeeTotalUnits||Int||The number of units to ship for an estimate of the manual processing fee charged by Amazon for boxes without box content information.|
|EstimatedBoxContentsFeePerUnitCurrencyCode||String||The currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.|
|EstimatedBoxContentsFeePerUnitValue||Decimal||The manual processing fee per unit for an estimate of the manual processing fee charged by Amazon for boxes without box content information.|
|EstimatedBoxContentsTotalFeeCurrencyCode||String||The Total fee currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.|
|EstimatedBoxContentsTotalFeeValue||Decimal||The Total fee value for an estimate of the manual processing fee charged by Amazon for boxes without box content information.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.