RefundShippingLines
Lists refunded shipping lines, including refunded shipping cost and related carrier information.
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 identifier for the refund shipping line record. | |
| RefundId | String |
Refunds.Id | The globally unique identifier of the refund associated with this refunded shipping charge. |
| SubtotalAmountSetPresentmentMoneyAmount | Decimal | The subtotal amount of the refunded shipping charge in the customer's presentment currency, expressed as a decimal money value. | |
| SubtotalAmountSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for the refunded shipping subtotal. | |
| SubtotalAmountSetShopMoneyAmount | Decimal | The subtotal amount of the refunded shipping charge in the shop's base currency, expressed as a decimal money value. | |
| SubtotalAmountSetShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the refunded shipping subtotal. | |
| TaxAmountSetPresentmentMoneyAmount | Decimal | The refunded tax amount applied to shipping in the customer's presentment currency, expressed as a decimal money value. | |
| TaxAmountSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for the refunded tax on shipping. | |
| TaxAmountSetShopMoneyAmount | Decimal | The refunded tax amount applied to shipping in the shop's base currency, expressed as a decimal money value. | |
| TaxAmountSetShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the refunded tax on shipping. | |
| ShippingLineId | String | The globally unique identifier of the original shipping line being refunded. | |
| ShippingLineCarrierIdentifier | String | A reference to the carrier service that provided the shipping rate, if the rate was computed by a third-party carrier integration. | |
| ShippingLineTitle | String | The display name or label of the shipping line as shown to the customer. | |
| ShippingLineCode | String | A reference or code representing the shipping method used for the order. | |
| ShippingLineCustom | Bool | Indicates whether this shipping line was manually added or customized by the merchant. | |
| ShippingLineDeliveryCategory | String | The general classification of the delivery method, such as standard, express, or local delivery. | |
| ShippingLineIsRemoved | Bool | Indicates whether the original shipping line was removed from the order. | |
| ShippingLinePhone | String | The phone number associated with the shipping address for this shipment. | |
| ShippingLineShippingRateHandle | String | A unique identifier for the shipping rate. Its format may vary and is not intended for display to customers. | |
| ShippingLineSource | String | Indicates the origin or source of the shipping rate, such as the carrier, manual entry, or a third-party app. | |
| ShippingLineCurrentDiscountedPriceSetPresentmentMoneyAmount | Decimal | The current discounted shipping price in the customer's presentment currency, expressed as a decimal money value. | |
| ShippingLineCurrentDiscountedPriceSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for the current discounted shipping price. | |
| ShippingLineCurrentDiscountedPriceSetShopMoneyAmount | Decimal | The current discounted shipping price in the shop's base currency, expressed as a decimal money value. | |
| ShippingLineCurrentDiscountedPriceSetShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the current discounted shipping price. | |
| ShippingLineDiscountedPriceAmount | Decimal | The discounted price of the shipping line, represented as a decimal money value. | |
| ShippingLineDiscountedPriceCurrencyCode | String | The ISO 4217 currency code for the discounted shipping line price. | |
| ShippingLineDiscountedPriceSetPresentmentMoneyAmount | Decimal | The discounted shipping price in the customer's presentment currency, expressed as a decimal money value. | |
| ShippingLineDiscountedPriceSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for the discounted shipping line. | |
| ShippingLineDiscountedPriceSetShopMoneyAmount | Decimal | The discounted shipping price in the shop's base currency, expressed as a decimal money value. | |
| ShippingLineDiscountedPriceSetShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the discounted shipping line. | |
| ShippingLineOriginalPriceAmount | Decimal | The original pre-discount price of the shipping line, expressed as a decimal money value. | |
| ShippingLineOriginalPriceCurrencyCode | String | The ISO 4217 currency code representing the currency of the original shipping line price. | |
| ShippingLineOriginalPriceSetPresentmentMoneyAmount | Decimal | The original pre-discount shipping line price in the customer's presentment currency, expressed as a decimal money value. | |
| ShippingLineOriginalPriceSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the original shipping line price. | |
| ShippingLineOriginalPriceSetShopMoneyAmount | Decimal | The original pre-discount shipping line price in the shop's base currency, expressed as a decimal money value. | |
| ShippingLineOriginalPriceSetShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the original shipping line price. | |
| ShippingLineRequestedFulfillmentServiceId | String | The globally unique identifier of the fulfillment service responsible for processing the shipment. |