Returns order items based on the Amazon Order Id that you specify.

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 本製品. OrderItems table supports server side filtering with = and IN operators for AmazonOrderId field.

• AmazonOrderId supports the '=' comparison.

For example, the following query is processed server side:

SELECT * FROM OrderItems WHERE AmazonOrderId = '503-9993250-1405404'

Columns

Name	Type	References	Description
OrderItemId [KEY]	String		An Amazon-defined order item identifier.
AmazonOrderId	String	Orders.AmazonOrderId	The Amazon ID of the order.
ASIN	String		The Amazon Standard Identification Number (ASIN) of the item.
SellerSKU	String		The seller stock keeping unit (SKU) of the item.
BuyerCustomizedInfoCustomizedURL	String		The Buyer CustomizedURL.
Title	String		The name of the item.
QuantityOrdered	Integer		The quantity of items ordered.
QuantityShipped	Integer		The quantity of items shipped.
GrantedPointsNumber	Integer		The Granted Points Number.
GrantedPointsMonetaryValueAmount	Decimal		The Granted Points Amount.
GrantedPointsMonetaryValueCurrencyCode	String		The Granted Points CurrencyCode.
NumberOfItems	Integer		The total number of items that are included in the ASIN.
ItemPriceAmount	Decimal		The Item Price Amount.
ItemPriceCurrencyCode	String		The Item Price Currency Code.
ShippingPriceAmount	Decimal		The Shipping Price Amount.
ShippingPriceCurrencyCode	String		The Shipping Price Currency Code.
ItemTaxAmount	Decimal		The Item Tax Amount.
ItemTaxCurrencyCode	String		The Item Tax Currency Code.
ShippingTaxAmount	String		The Shipping Tax Amount.
ShippingTaxCurrencyCode	String		The ShippingTax Currency Code.
ShippingDiscountAmount	String		The Shipping Discount Amount.
ShippingDiscountCurrencyCode	String		The Shipping Discount Currency Code.
ShippingDiscountTaxAmount	String		The Shipping Discount Tax Amount.
ShippingDiscountTaxCurrencyCode	String		The Shipping Discount Tax Currency Code.
PromotionDiscountAmount	Decimal		The Promotion Discount Amount.
PromotionDiscountCurrencyCode	String		The Promotion Discount Currency Code.
PromotionDiscountTaxAmount	Decimal		The Promotion Discount Tax Amount.
PromotionDiscountTaxCurrencyCode	String		The Promotion Discount Tax Currency Code.
PromotionIds	String		The IDs of Promotions.
CODFeeAmount	Decimal		The COD FeeAmount.
CODFeeCurrencyCode	String		The COD FeeCurrency Code.
CODFeeDiscountAmount	String		The COD FeeDiscount Amount.
CODFeeDiscountCurrencyCode	String		The COD FeeDiscount Currency Code.
IsGift	Boolean		Boolean specifying if the item is gift.
ConditionNote	String		The Condition Note.
ConditionId	String		The Condition Id.
ConditionSubtypeId	String		The Condition Subtype Id.
ScheduledDeliveryStartDate	Datetime		The Scheduled Delivery StartDate.
ScheduledDeliveryEndDate	Datetime		The Scheduled Delivery EndDate.
PriceDesignation	String		The Price Designation.
TaxCollectionModel	String		The tax collection model applied to the item.
TaxCollectionResponsibleParty	String		The party responsible for withholding the taxes and remitting them to the taxing authority.
SerialNumberRequired	Boolean		When true, the product type for this item has a serial number. Returned only for Amazon Easy Ship orders.
IsTransparency	Boolean		When true, transparency codes are required.
IossNumber	String		The IOSS number for the marketplace.
StoreChainStoreId	String		The store chain store identifier. Linked to a specific store in a store chain.
DeemedResellerCategory	String		Applies to selling partners that are not based in the EU and is used to help them meet the VAT Deemed Reseller tax laws in the EU and UK.
IsBuyerRequestedCancel	Boolean		When true, the buyer has requested cancellation.
BuyerCancelReason	String		The reason that the buyer requested cancellation.
BuyerCustomizedInfoURL	String		The location of a zip file containing Amazon Custom data.
GiftWrapPriceAmount	String		The Gift Wrap Price Amount.
GiftWrapPriceCurrencyCode	String		The Gift Wrap Price Currency Code.
GiftWrapTaxAmount	String		The Gift Wrap Tax Amount.
GiftWrapTaxCurrencyCode	String		The Gift Wrap Tax Currency Code.
GiftMessageText	String		A gift message provided by the buyer.
GiftWrapLevel	String		The gift wrap level specified by the buyer.
AssociatedItems	String		A list of associated items that a customer has purchased with a product. For example, a tire installation service purchased with tires.

Pseudo-Columns

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

Name	Type	Description
LastUpdateDate	Datetime		The last time the order is updated.