InboundShipmentItems
Returns a list of items in a specified inbound shipment.
Select
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'
Columns
| Name | Type | References | Description |
| ShipmentId [KEY] | String |
InboundShipments.ShipmentId | 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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| LastUpdatedDate | Datetime |