RefundShippingLines
Retrieve shipping lines attached to refunds.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- 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. | |
| RefundId | String |
Refunds.Id | A globally-unique ID. |
| SubtotalAmountSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| SubtotalAmountSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| SubtotalAmountSetShopMoneyAmount | Decimal | Decimal money amount. | |
| SubtotalAmountSetShopMoneyCurrencyCode | String | Currency of the money. | |
| TaxAmountSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| TaxAmountSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| TaxAmountSetShopMoneyAmount | Decimal | Decimal money amount. | |
| TaxAmountSetShopMoneyCurrencyCode | String | Currency of the money. | |
| ShippingLineId | String | A globally-unique ID. | |
| 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 | Returns the title of the shipping line. | |
| ShippingLineCode | String | A reference to the shipping method. | |
| ShippingLineCustom | Bool | Whether the shipping line is custom or not. | |
| ShippingLineDeliveryCategory | String | The general classification of the delivery method. | |
| ShippingLineIsRemoved | Bool | 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 meant to be shown to users. | |
| ShippingLineSource | String | Returns the rate source for the shipping line. | |
| ShippingLineCurrentDiscountedPriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| ShippingLineCurrentDiscountedPriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| ShippingLineCurrentDiscountedPriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| ShippingLineCurrentDiscountedPriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| ShippingLineDiscountedPriceAmount | Decimal | Decimal money amount. | |
| ShippingLineDiscountedPriceCurrencyCode | String | Currency of the money. | |
| ShippingLineDiscountedPriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| ShippingLineDiscountedPriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| ShippingLineDiscountedPriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| ShippingLineDiscountedPriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| ShippingLineOriginalPriceAmount | Decimal | Decimal money amount. | |
| ShippingLineOriginalPriceCurrencyCode | String | Currency of the money. | |
| ShippingLineOriginalPriceSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| ShippingLineOriginalPriceSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| ShippingLineOriginalPriceSetShopMoneyAmount | Decimal | Decimal money amount. | |
| ShippingLineOriginalPriceSetShopMoneyCurrencyCode | String | Currency of the money. | |
| ShippingLineRequestedFulfillmentServiceId | String | The ID of the fulfillment service. |