RefundShippingLines
Lists shipping lines included in a refund.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- RefundId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM RefundShippingLines WHERE RefundId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id of the refund shipping line. | |
| RefundId | String |
Refunds.Id | A globally unique Id of the associated refund. |
| SubtotalAmountSetPresentmentMoneyAmount | Decimal | The subtotal amount in the presentment currency, expressed as a decimal money amount. | |
| SubtotalAmountSetPresentmentMoneyCurrencyCode | String | The currency code of the subtotal amount in the presentment currency. | |
| SubtotalAmountSetShopMoneyAmount | Decimal | The subtotal amount in the shop's currency, expressed as a decimal money amount. | |
| SubtotalAmountSetShopMoneyCurrencyCode | String | The currency code of the subtotal amount in the shop's currency. | |
| TaxAmountSetPresentmentMoneyAmount | Decimal | The tax amount in the presentment currency, expressed as a decimal money amount. | |
| TaxAmountSetPresentmentMoneyCurrencyCode | String | The currency code of the tax amount in the presentment currency. | |
| TaxAmountSetShopMoneyAmount | Decimal | The tax amount in the shop's currency, expressed as a decimal money amount. | |
| TaxAmountSetShopMoneyCurrencyCode | String | The currency code of the tax amount in the shop's currency. | |
| ShippingLineId | String | A globally unique Id of the associated shipping line. | |
| ShippingLineCarrierIdentifier | String | A reference to the carrier service that provided the rate. Present when the rate was computed by a third-party carrier service. | |
| ShippingLineTitle | String | The title of the shipping line. | |
| ShippingLineCode | String | A reference to the shipping method of the line. | |
| ShippingLineCustom | Bool | Indicates whether the shipping line is custom. | |
| ShippingLineDeliveryCategory | String | The general classification of the delivery method. | |
| ShippingLineIsRemoved | Bool | Indicates whether the shipping line has been removed. | |
| ShippingLinePhone | String | The phone number at the shipping address. | |
| ShippingLineShippingRateHandle | String | A unique identifier for the shipping rate. The format can change without notice and isn't intended to be shown to users. | |
| ShippingLineSource | String | The rate source for the shipping line. | |
| ShippingLineCurrentDiscountedPriceSetPresentmentMoneyAmount | Decimal | The current discounted price in the presentment currency, expressed as a decimal money amount. | |
| ShippingLineCurrentDiscountedPriceSetPresentmentMoneyCurrencyCode | String | The currency code of the current discounted price in the presentment currency. | |
| ShippingLineCurrentDiscountedPriceSetShopMoneyAmount | Decimal | The current discounted price in the shop's currency, expressed as a decimal money amount. | |
| ShippingLineCurrentDiscountedPriceSetShopMoneyCurrencyCode | String | The currency code of the current discounted price in the shop's currency. | |
| ShippingLineDiscountedPriceAmount | Decimal | The discounted price, expressed as a decimal money amount. | |
| ShippingLineDiscountedPriceCurrencyCode | String | The currency code of the discounted price. | |
| ShippingLineDiscountedPriceSetPresentmentMoneyAmount | Decimal | The discounted price in the presentment currency, expressed as a decimal money amount. | |
| ShippingLineDiscountedPriceSetPresentmentMoneyCurrencyCode | String | The currency code of the discounted price in the presentment currency. | |
| ShippingLineDiscountedPriceSetShopMoneyAmount | Decimal | The discounted price in the shop's currency, expressed as a decimal money amount. | |
| ShippingLineDiscountedPriceSetShopMoneyCurrencyCode | String | The currency code of the discounted price in the shop's currency. | |
| ShippingLineOriginalPriceAmount | Decimal | The original price, expressed as a decimal money amount. | |
| ShippingLineOriginalPriceCurrencyCode | String | The currency code of the original price. | |
| ShippingLineOriginalPriceSetPresentmentMoneyAmount | Decimal | The original price in the presentment currency, expressed as a decimal money amount. | |
| ShippingLineOriginalPriceSetPresentmentMoneyCurrencyCode | String | The currency code of the original price in the presentment currency. | |
| ShippingLineOriginalPriceSetShopMoneyAmount | Decimal | The original price in the shop's currency, expressed as a decimal money amount. | |
| ShippingLineOriginalPriceSetShopMoneyCurrencyCode | String | The currency code of the original price in the shop's currency. | |
| ShippingLineRequestedFulfillmentServiceId | String | The Id of the fulfillment service requested for the shipping line. |