RefundTransactionFees
Displays transaction fees refunded to merchants for Shopify Payments transactions.
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 RefundTransactionFees WHERE RefundId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the refund transaction fee record. | |
| TransactionId | String | The globally unique identifier of the original transaction associated with this refunded fee. | |
| RefundId | String |
Refunds.Id | The globally unique identifier of the refund linked to this fee record. |
| RateName | String | The descriptive name of the percentage-based fee rate applied to the original transaction, such as a credit card processing rate. | |
| FlatFeeName | String | The descriptive name of the flat fee applied to the original transaction, typically associated with fixed transaction costs. | |
| Rate | Decimal | The percentage rate charged by the payment provider, expressed as a decimal value. | |
| Type | String | Specifies the type of fee, such as 'processing', 'network', or 'refund adjustment'. | |
| AmountAmount | Decimal | The amount of the percentage-based fee in decimal monetary format. | |
| AmountCurrencyCode | String | The ISO 4217 currency code representing the currency of the percentage-based fee amount. | |
| FlatFeeAmount | Decimal | The flat, fixed amount of the transaction fee charged or refunded, expressed as a decimal monetary value. | |
| FlatFeeCurrencyCode | String | The ISO 4217 currency code representing the currency of the flat fee amount. | |
| TaxAmountAmount | Decimal | The amount of tax applied to the transaction fee, represented as a decimal monetary value. | |
| TaxAmountCurrencyCode | String | The ISO 4217 currency code representing the currency of the tax applied to the transaction fee. |