RefundTransactions
Shows transactions created as part of refunds, including payment gateway data and refund amounts.
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.
- ResourceId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM RefundTransactions WHERE ResourceId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the refund transaction record. | |
| ResourceId [KEY] | String |
Refunds.Id | The globally unique identifier of the related resource, such as an order or payment record. |
| PaymentId | String | The unique identifier for the payment associated with this refund transaction. | |
| ParentTransactionId | String | References the parent transaction, such as the original charge or authorization linked to this refund. | |
| AccountNumber | String | The masked account number of the payment method used, with sensitive digits redacted for security. | |
| Gateway | String | The payment gateway responsible for processing this refund, such as Shopify Payments or PayPal. | |
| Kind | String | Specifies the type of transaction, such as 'refund', 'capture', or 'authorization'. | |
| Status | String | Indicates the current state of the refund transaction, such as 'pending', 'completed', or 'failed'. | |
| Test | Bool | Indicates whether the refund transaction was processed in test mode rather than live mode. | |
| AuthorizationCode | String | The authorization code issued by the payment processor for the transaction. | |
| ErrorCode | String | A standardized error identifier that indicates the reason for a failed or declined refund transaction. | |
| FormattedGateway | String | The human-readable name of the payment gateway used to process this refund. | |
| ManuallyCapturable | Bool | Indicates whether this transaction can be manually captured after authorization. | |
| MultiCapturable | Bool | Specifies whether multiple captures are allowed from the same authorization for partial refunds. | |
| ProcessedAt | Datetime | The date and time when the refund transaction was processed by the payment provider. | |
| ReceiptJson | String | A JSON-formatted receipt provided by the payment gateway containing detailed transaction data or metadata. | |
| SettlementCurrency | String | The ISO 4217 currency code representing the currency in which the refund was settled. | |
| AuthorizationExpiresAt | Datetime | The date and time when the authorization for this transaction expires. Available only to Shopify Plus merchants using Shopify Payments. | |
| SettlementCurrencyRate | Decimal | The exchange rate applied when converting the refund amount to the settlement currency. | |
| CreatedAt | Datetime | The date and time when the refund transaction was created in Shopify. | |
| CardPaymentDetailsName | String | The name of the cardholder as displayed on the payment card used for the transaction. | |
| CardPaymentDetailsBin | String | The issuer identification number (IIN/BIN) derived from the first digits of the card number, identifying the issuing bank. | |
| CardPaymentDetailsCompany | String | The name of the financial institution or card network (such as Visa or Mastercard) that issued the customer's credit card. | |
| CardPaymentDetailsNumber | String | The customer's credit card number with most leading digits redacted for security. | |
| CardPaymentDetailsWallet | String | Specifies the digital wallet used for the payment, such as Apple Pay or Google Pay. | |
| CardPaymentDetailsExpirationMonth | Int | The expiration month of the card used for the payment. | |
| CardPaymentDetailsExpirationYear | Int | The expiration year of the card used for the payment. | |
| CardPaymentDetailsAvsResultCode | String | The result code from the Address Verification System (AVS), represented by a single character. | |
| CardPaymentDetailsCvvResultCode | String | The result code from the credit card provider indicating whether the card verification value (CVV) was entered correctly. | |
| PaymentIconId | String | A globally unique identifier for the payment method's icon image. | |
| PaymentIconWidth | Int | The width of the payment method icon in pixels. Returns null if the image is not hosted by Shopify. | |
| PaymentIconAltText | String | Alternative text describing the icon image for accessibility or descriptive purposes. | |
| PaymentIconHeight | Int | The height of the payment method icon in pixels. Returns null if the image is not hosted by Shopify. | |
| AmountSetPresentmentMoneyAmount | Decimal | The refund transaction amount in the customer's presentment currency, expressed as a decimal monetary value. | |
| AmountSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the refund amount. | |
| AmountSetShopMoneyAmount | Decimal | The refund transaction amount converted to the shop's base currency, expressed as a decimal monetary value. | |
| AmountSetShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the refund amount. | |
| MaximumRefundableV2Amount | Decimal | The maximum amount that can still be refunded for this transaction, expressed as a decimal monetary value. | |
| MaximumRefundableV2CurrencyCode | String | The ISO 4217 currency code representing the currency of the maximum refundable amount. | |
| ShopifyPaymentsSetExtendedAuthorizationSetExtendedAuthorizationExpiresAt | Datetime | The date and time when the extended authorization for the transaction expires, after which payment capture is no longer possible. | |
| ShopifyPaymentsSetExtendedAuthorizationSetStandardAuthorizationExpiresAt | Datetime | The expiration date for a standard authorization, after which additional capture fees may apply. | |
| ShopifyPaymentsSetRefundSetAcquirerReferenceNumber | String | The acquirer reference number (ARN) generated for card network tracking of Visa or Mastercard refunds. | |
| TotalUnsettledSetPresentmentMoneyAmount | Decimal | The total amount of unsettled funds in the customer's presentment currency, expressed as a decimal monetary value. | |
| TotalUnsettledSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for unsettled funds. | |
| TotalUnsettledSetShopMoneyAmount | Decimal | The total unsettled amount in the shop's base currency, expressed as a decimal monetary value. | |
| TotalUnsettledSetShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for unsettled funds. |