OrderRefundAgreementShippingLineSales
Shows refunded shipping line sales under order agreements.
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.
- 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 identifier of the parent order that the shipping-related agreement adjustment is associated with. |
| AgreementId | String | A unique identifier for the refund agreement connected to this shipping line sale adjustment. | |
| Id [KEY] | String | A unique identifier for the individual shipping sale adjustment record within the agreement. | |
| ActionType | String | Indicates the type of order action represented by this shipping line sale adjustment, such as refund, charge, or adjustment. | |
| LineType | String | Specifies the classification of the line item involved in the shipping line sale adjustment, typically identifying it as a shipping charge. | |
| Quantity | Int | The number of shipping units affected by the sale adjustment, such as shipments charged, refunded, or adjusted. | |
| TotalAmountPresentmentMoneyAmount | Decimal | The total amount of the shipping line sale adjustment, including taxes and discounts, expressed in the buyer's presentment currency as a decimal value. | |
| TotalAmountPresentmentCurrencyCode | String | The ISO currency code representing the buyer's presentment currency for the total shipping line sale amount. | |
| TotalAmountShopMoneyAmount | Decimal | The total amount of the shipping line sale adjustment, including taxes and discounts, expressed in the shop's base currency as a decimal value. | |
| TotalAmountShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for the total shipping line sale amount. | |
| TotalTaxAmountPresentmentMoneyAmount | Decimal | The total tax amount applied to the shipping line sale adjustment in the buyer's presentment currency, expressed as a decimal. | |
| TotalTaxAmountPresentmentCurrencyCode | String | The ISO currency code representing the presentment currency used for tax calculations on the shipping line sale. | |
| TotalTaxAmountShopMoneyAmount | Decimal | The total tax amount applied to the shipping line sale adjustment in the shop's base currency, expressed as a decimal. | |
| TotalTaxAmountShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency used for tax calculations on the shipping line sale. | |
| TotalDiscountAmountBeforeTaxesPresentmentMoneyAmount | Decimal | The total value of discounts applied to the shipping line sale adjustment before taxes, expressed in the buyer's presentment currency as a decimal. | |
| TotalDiscountAmountBeforeTaxesPresentmentCurrencyCode | String | The ISO currency code representing the presentment currency for discounts applied before taxes on the shipping line sale. | |
| TotalDiscountAmountBeforeTaxesShopMoneyAmount | Decimal | The total value of discounts applied to the shipping line sale adjustment before taxes, expressed in the shop's base currency as a decimal. | |
| TotalDiscountAmountBeforeTaxesShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for discounts applied before taxes on the shipping line sale. | |
| TotalDiscountAmountAfterTaxesPresentmentMoneyAmount | Decimal | The total value of discounts applied to the shipping line sale adjustment after taxes, expressed in the buyer's presentment currency as a decimal. | |
| TotalDiscountAmountAfterTaxesPresentmentCurrencyCode | String | The ISO currency code representing the presentment currency for discounts applied after taxes on the shipping line sale. | |
| TotalDiscountAmountAfterTaxesShopMoneyAmount | Decimal | The total value of discounts applied to the shipping line sale adjustment after taxes, expressed in the shop's base currency as a decimal. | |
| TotalDiscountAmountAfterTaxesShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency for discounts applied after taxes on the shipping line sale. | |
| Taxes | String | A collection of individual tax components associated with the shipping line sale adjustment, detailing rates and applied amounts. | |
| ShippingLineSaleShippingLineId | String | A unique identifier linking the shipping line sale adjustment to the corresponding shipping charge line item. Not available when the SaleActionType represents a return. |