RefundTransactionFees
Lists transaction fees applied to the original order transaction (Shopify Payments only).
View-Specific Information
Select
The server uses the Shopify API to process WHERE clause conditions built with the following column and operators. The server processes other filters client-side within the server.
- RefundId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM RefundTransactionFees WHERE RefundId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the refund transaction fee record. | |
| TransactionId | String | A globally unique identifier for the related transaction. | |
| RefundId | String |
Refunds.Id | A globally unique identifier for the associated refund. |
| RateName | String | The name of the credit card rate applied to the transaction. | |
| FlatFeeName | String | The name of the credit card flat fee applied to the transaction. | |
| Rate | Decimal | The percentage fee rate charged for the transaction. | |
| Type | String | The category or type of fee applied (for example, rate-based or flat). | |
| AmountAmount | Decimal | The total fee amount, expressed as a decimal value. | |
| AmountCurrencyCode | String | The currency of the total fee amount. | |
| FlatFeeAmount | Decimal | The flat fee amount, expressed as a decimal value. | |
| FlatFeeCurrencyCode | String | The currency of the flat fee amount. | |
| TaxAmountAmount | Decimal | The tax amount applied to the fee, expressed as a decimal value. | |
| TaxAmountCurrencyCode | String | The currency of the tax amount applied to the fee. |