OrderRefundAgreementShippingLineSales
Lists refund sales associated with agreement-based shipping lines.
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.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderRefundAgreementShippingLineSales WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| OrderId | String |
Orders.Id | The Id of the order that the agreement belongs to. |
| AgreementId | String | The unique identifier of the refund agreement. | |
| Id [KEY] | String | The unique identifier of the shipping line sale record. | |
| ActionType | String | The type of order action represented by the sale, such as refund or adjustment. | |
| LineType | String | The category of line item associated with the sale, such as shipping or handling. | |
| Quantity | Int | The number of units sold or refunded in this sale. | |
| TotalAmountPresentmentMoneyAmount | Decimal | The total sale amount after taxes and discounts, expressed as a decimal value in the presentment currency. | |
| TotalAmountPresentmentCurrencyCode | String | The currency code of the total sale amount in the presentment currency. | |
| TotalAmountShopMoneyAmount | Decimal | The total sale amount after taxes and discounts, expressed as a decimal value in the shop's currency. | |
| TotalAmountShopMoneyCurrencyCode | String | The currency code of the total sale amount in the shop's currency. | |
| TotalTaxAmountPresentmentMoneyAmount | Decimal | The total tax amount for the sale, expressed as a decimal value in the presentment currency. | |
| TotalTaxAmountPresentmentCurrencyCode | String | The currency code of the total tax amount in the presentment currency. | |
| TotalTaxAmountShopMoneyAmount | Decimal | The total tax amount for the sale, expressed as a decimal value in the shop's currency. | |
| TotalTaxAmountShopMoneyCurrencyCode | String | The currency code of the total tax amount in the shop's currency. | |
| TotalDiscountAmountBeforeTaxesPresentmentMoneyAmount | Decimal | The total discounts applied to the sale before taxes, expressed as a decimal value in the presentment currency. | |
| TotalDiscountAmountBeforeTaxesPresentmentCurrencyCode | String | The currency code of the discounts applied before taxes in the presentment currency. | |
| TotalDiscountAmountBeforeTaxesShopMoneyAmount | Decimal | The total discounts applied to the sale before taxes, expressed as a decimal value in the shop's currency. | |
| TotalDiscountAmountBeforeTaxesShopMoneyCurrencyCode | String | The currency code of the discounts applied before taxes in the shop's currency. | |
| TotalDiscountAmountAfterTaxesPresentmentMoneyAmount | Decimal | The total discounts applied to the sale after taxes, expressed as a decimal value in the presentment currency. | |
| TotalDiscountAmountAfterTaxesPresentmentCurrencyCode | String | The currency code of the discounts applied after taxes in the presentment currency. | |
| TotalDiscountAmountAfterTaxesShopMoneyAmount | Decimal | The total discounts applied to the sale after taxes, expressed as a decimal value in the shop's currency. | |
| TotalDiscountAmountAfterTaxesShopMoneyCurrencyCode | String | The currency code of the discounts applied after taxes in the shop's currency. | |
| Taxes | String | The list of individual taxes applied to the sale. | |
| ShippingLineSaleShippingLineId | String | A sale associated with a shipping charge. Represents the shipping line item for the sale. Not available if the SaleActionType is a return. A globally unique Id. |