OrderRefundAgreementAdditionalFeeSales
Shows refund-related sales adjustments for agreements involving additional fees.
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 OrderRefundAgreementAdditionalFeeSales WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| OrderId | String |
Orders.Id | The unique identifier of the order associated with this refund agreement. |
| AgreementId | String | A globally unique identifier representing the specific refund agreement record. | |
| Id [KEY] | String | A globally unique identifier for the refunded sale associated with the agreement. | |
| ActionType | String | Describes the type of refund-related action performed, such as a full or partial refund. | |
| LineType | String | Specifies the type of line involved in the refund, such as a product, shipping, or additional fee line. | |
| Quantity | Int | The number of units affected by the refund, whether returned, canceled, or otherwise adjusted. | |
| TotalAmountPresentmentMoneyAmount | Decimal | The total refunded amount after taxes and discounts, expressed in the customer's presentment currency. | |
| TotalAmountPresentmentCurrencyCode | String | The ISO currency code representing the presentment currency used for the refund total. | |
| TotalAmountShopMoneyAmount | Decimal | The total refunded amount after taxes and discounts, expressed in the shop's base currency. | |
| TotalAmountShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency used for the refund total. | |
| TotalTaxAmountPresentmentMoneyAmount | Decimal | The total tax amount refunded for the sale, expressed in the customer's presentment currency. | |
| TotalTaxAmountPresentmentCurrencyCode | String | The ISO currency code representing the presentment currency of the refunded tax amount. | |
| TotalTaxAmountShopMoneyAmount | Decimal | The total tax amount refunded for the sale, expressed in the shop's base currency. | |
| TotalTaxAmountShopMoneyCurrencyCode | String | The ISO currency code representing the shop's base currency of the refunded tax amount. | |
| TotalDiscountAmountBeforeTaxesPresentmentMoneyAmount | Decimal | The total amount of discounts applied before tax on the refunded sale, expressed in the customer's presentment currency. | |
| TotalDiscountAmountBeforeTaxesPresentmentCurrencyCode | String | The ISO currency code for the presentment currency used for discounts before taxes. | |
| TotalDiscountAmountBeforeTaxesShopMoneyAmount | Decimal | The total amount of discounts applied before tax on the refunded sale, expressed in the shop's base currency. | |
| TotalDiscountAmountBeforeTaxesShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency used for discounts before taxes. | |
| TotalDiscountAmountAfterTaxesPresentmentMoneyAmount | Decimal | The total amount of discounts applied after tax on the refunded sale, expressed in the customer's presentment currency. | |
| TotalDiscountAmountAfterTaxesPresentmentCurrencyCode | String | The ISO currency code for the presentment currency used for discounts after taxes. | |
| TotalDiscountAmountAfterTaxesShopMoneyAmount | Decimal | The total amount of discounts applied after tax on the refunded sale, expressed in the shop's base currency. | |
| TotalDiscountAmountAfterTaxesShopMoneyCurrencyCode | String | The ISO currency code for the shop's base currency used for discounts after taxes. | |
| Taxes | String | A list of the individual taxes associated with the refunded sale, including details on tax rate, source, and jurisdiction. | |
| AdditionalFeeSaleAdditionalFeeId | String | The unique identifier of the additional fee charge associated with this refund sale. Represents specific refunded fee adjustments. |