OrderItems
Returns order items based on the Amazon Order Id 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. OrderItems table supports server side filtering with = and IN operators for AmazonOrderId field.
- AmazonOrderId supports the '=' comparison.
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. |
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 | |
LastUpdateDate | Datetime | The last time the order is updated. |