Returns a list of inbound shipments based on criteria that you specify.

Select

The add-in 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 add-in.

• ShipmentId supports the '=' and 'IN' comparisons.
• ShipmentStatus supports the '='and 'IN' comparisons.
• MarketplaceId supports the '=' comparison.
• LastUpdatedDate supports the '=', '<', '>', '<=', '>=' comparisons.

For example, the following query is processed server side:

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 MarketplaceId = 'ATVPDKIKX0DER'

SELECT * FROM InboundShipments WHERE LastUpdatedDate >= '2016-12-12'

Columns

Name	Type	References	Description
ShipmentId [KEY]	String		The ID of the shipment.
ShipmentStatus	String		The status of your inbound shipment.
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.
ShipFromDistrictOrCounty	String		The district or county of the return address.
ShipFromStateOrProvinceCode	String		The State Or Province Code of the return address.
ShipFromAddressLine1	String		The street address information of the return address.
ShipFromAddressLine2	String		Additional street address information 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.
MarketplaceId	String		Marketplace identifier for the report.
BoxContentsSource	String		Where the seller provided box contents information for a shipment.
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-Columns

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.

Name	Type	Description
LastUpdatedDate	Datetime		A date used for selecting inbound shipments that were last updated before/after a specified time.
InboundShipmentItemList	String		A list of inbound shipment item information.