ReturnExchangeLineItems

Lists line items created for exchanges within a return.

View-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.

ResourceId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM ReturnExchangeLineItems WHERE ResourceId = 'Val1'

Columns


Name	Type	References	Description
Id [KEY]	String		A globally unique Id for the return or exchange line item.
ResourceId	String	Returns.Id	A globally unique Id for the related resource.
Name	String		The product title, optionally appended with the variant title if applicable.
Title	String		The product title at the time the order was created.
VariantTitle	String		The variant title at the time the order was created.
VariantId	String		A globally unique Id for the product variant.
ProductId	String		A globally unique Id for the product.
SellingPlanSellingPlanId	String		The Id of the selling plan linked to the line item.
Quantity	Int		The number of units of the variant ordered.
Restockable	Bool		Whether the line item can be restocked.
Sku	String		The stock keeping unit (SKU) of the variant.
Taxable	Bool		Whether the variant is taxable.
Vendor	String		The name of the vendor that supplied the variant.
CurrentQuantity	Int		The current quantity of the line item, after subtracting any removed units.
MerchantEditable	Bool		Whether the line item can be edited by the merchant.
RefundableQuantity	Int		The quantity of the line item that can be refunded.
RequiresShipping	Bool		Whether the variant requires physical shipping.
UnfulfilledQuantity	Int		The number of units that have not yet been fulfilled.
NonFulfillableQuantity	Int		The number of units that cannot be fulfilled. For example, refunded items or non-physical items like tips.
IsGiftCard	Bool		Whether the line item is a gift card purchase.
DiscountedTotalSetPresentmentMoneyAmount	Decimal		The total discounted amount in the presentment currency.
DiscountedTotalSetPresentmentMoneyAmountWithCodeDiscounts	Decimal		The total discounted amount in the presentment currency, including code-based discounts.
DiscountedTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the discounted total in presentment currency.
DiscountedTotalSetShopMoneyAmount	Decimal		The total discounted amount in the shop currency.
DiscountedTotalSetShopMoneyAmountWithCodeDiscounts	Decimal		The total discounted amount in the shop currency, including code-based discounts.
DiscountedTotalSetShopMoneyCurrencyCode	String		The currency code for the discounted total in shop currency.
DiscountedUnitPriceSetPresentmentMoneyAmount	Decimal		The discounted unit price in the presentment currency.
DiscountedUnitPriceSetPresentmentMoneyCurrencyCode	String		The currency code for the discounted unit price in presentment currency.
DiscountedUnitPriceSetShopMoneyAmount	Decimal		The discounted unit price in the shop currency.
DiscountedUnitPriceSetShopMoneyCurrencyCode	String		The currency code for the discounted unit price in shop currency.
ImageId	String		A unique Id for the product image.
ImageWidth	Int		The original width of the product image in pixels, or null if not hosted by Shopify.
ImageAltText	String		Alternative text describing the contents of the product image.
ImageHeight	Int		The original height of the product image in pixels, or null if not hosted by Shopify.
ImageUrl	String		The URL of the product image.
OriginalTotalSetPresentmentMoneyAmount	Decimal		The original total amount in the presentment currency.
OriginalTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the original total in presentment currency.
OriginalTotalSetShopMoneyAmount	Decimal		The original total amount in the shop currency.
OriginalTotalSetShopMoneyCurrencyCode	String		The currency code for the original total in shop currency.
OriginalUnitPriceSetPresentmentMoneyAmount	Decimal		The original unit price in the presentment currency.
OriginalUnitPriceSetPresentmentMoneyCurrencyCode	String		The currency code for the original unit price in presentment currency.
OriginalUnitPriceSetShopMoneyAmount	Decimal		The original unit price in the shop currency.
OriginalUnitPriceSetShopMoneyCurrencyCode	String		The currency code for the original unit price in shop currency.
TotalDiscountSetPresentmentMoneyAmount	Decimal		The total discount amount in the presentment currency.
TotalDiscountSetPresentmentMoneyCurrencyCode	String		The currency code for the total discount in presentment currency.
TotalDiscountSetShopMoneyAmount	Decimal		The total discount amount in the shop currency.
TotalDiscountSetShopMoneyCurrencyCode	String		The currency code for the total discount in shop currency.
UnfulfilledDiscountedTotalSetPresentmentMoneyAmount	Decimal		The unfulfilled discounted total in the presentment currency.
UnfulfilledDiscountedTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the unfulfilled discounted total in presentment currency.
UnfulfilledDiscountedTotalSetShopMoneyAmount	Decimal		The unfulfilled discounted total in the shop currency.
UnfulfilledDiscountedTotalSetShopMoneyCurrencyCode	String		The currency code for the unfulfilled discounted total in shop currency.
UnfulfilledOriginalTotalSetPresentmentMoneyAmount	Decimal		The unfulfilled original total in the presentment currency.
UnfulfilledOriginalTotalSetPresentmentMoneyCurrencyCode	String		The currency code for the unfulfilled original total in presentment currency.
UnfulfilledOriginalTotalSetShopMoneyAmount	Decimal		The unfulfilled original total in the shop currency.
UnfulfilledOriginalTotalSetShopMoneyCurrencyCode	String		The currency code for the unfulfilled original total in shop currency.

Pseudo-Columns

疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。


Name	Type	Description
AppliedDiscountValueAmount	Decimal		A fixed discount amount applied to the exchange line item.
AppliedDiscountValueAmountCurrencyCode	String		The currency code for the fixed discount applied to the exchange line item.
AppliedDiscountValuePercentage	Double		The discount percentage applied to the exchange line item.
AppliedDiscountDescription	String		A description of the discount applied to the exchange line item.
GiftCardCodes	String		The gift card codes linked to physical gift cards in the order.

SSIS Components for Shopify

ReturnExchangeLineItems

View-Specific Information

Select

Columns

Pseudo-Columns