RefundOrderAdjustments
Displays order-level adjustments included in refunds, such as discounts or shipping refunds.
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 RefundOrderAdjustments WHERE RefundId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the refund order adjustment record. | |
| RefundId | String | The globally unique identifier of the refund transaction associated with this adjustment. | |
| Reason | String | An optional explanation describing why the refunded amount differs from the originally calculated refund, such as manual adjustments, fees, or rounding differences. | |
| AmountSetPresentmentMoneyAmount | Decimal | The adjustment amount applied to the refund in the customer's presentment currency, represented as a decimal money value. | |
| AmountSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the refund adjustment amount. | |
| AmountSetShopMoneyAmount | Decimal | The adjustment amount converted to the shop's base currency, represented as a decimal money value. | |
| AmountSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the refund adjustment amount. | |
| TaxAmountSetPresentmentMoneyAmount | Decimal | The portion of tax included in the refund adjustment, represented in the customer's presentment currency as a decimal money value. | |
| TaxAmountSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the tax component in the refund adjustment. | |
| TaxAmountSetShopMoneyAmount | Decimal | The portion of tax included in the refund adjustment, represented in the shop's base currency as a decimal money value. | |
| TaxAmountSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency of the tax component in the refund adjustment. |