RefundTransactions
Lists payment transactions generated as part of a refund.
View-Specific Information
Select
The component uses the Shopify API to process WHERE clause conditions built with the following column and operators. The component processes other filters client-side within the component.
- 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 | A globally unique identifier for the related resource. |
| PaymentId | String | The unique identifier of the payment associated with the transaction. | |
| ParentTransactionId | String | The identifier of the parent transaction, such as the authorization for a capture. | |
| AccountNumber | String | The masked account number linked to the payment method. | |
| Gateway | String | The payment gateway used to process the transaction. | |
| Kind | String | The type of transaction (for example, authorization, capture, or refund). | |
| Status | String | The current status of the transaction. | |
| Test | Bool | Indicates whether the transaction was processed in test mode. | |
| AuthorizationCode | String | The authorization code returned for the transaction. | |
| ErrorCode | String | A standardized error code, independent of the payment provider. | |
| FormattedGateway | String | The human-readable name of the payment gateway. | |
| ManuallyCapturable | Bool | Indicates whether the transaction can be manually captured. | |
| MultiCapturable | Bool | Indicates whether the transaction supports multiple captures. | |
| ProcessedAt | Datetime | The date and time when the transaction was processed. | |
| ReceiptJson | String | A JSON receipt from the payment gateway. The format varies depending on the gateway. | |
| SettlementCurrency | String | The currency in which the transaction is settled. | |
| AuthorizationExpiresAt | Datetime | The expiration time of the authorization. Available only for Shopify Plus stores using Shopify Payments. | |
| SettlementCurrencyRate | Decimal | The conversion rate used to settle the transaction amount in the settlement currency. | |
| CreatedAt | Datetime | The date and time when the transaction was created. | |
| CardPaymentDetailsName | String | The name of the credit card holder. | |
| CardPaymentDetailsBin | String | The issuer identification number (IIN/BIN), the first digits of the card number identifying the issuing bank. | |
| CardPaymentDetailsCompany | String | The company that issued the customer's credit card. | |
| CardPaymentDetailsNumber | String | The customer's credit card number with most digits redacted. | |
| CardPaymentDetailsWallet | String | The digital wallet used for the payment, if applicable. | |
| CardPaymentDetailsExpirationMonth | Int | The month when the credit card expires. | |
| CardPaymentDetailsExpirationYear | Int | The year when the credit card expires. | |
| CardPaymentDetailsAvsResultCode | String | The address verification system (AVS) response code (single letter). | |
| CardPaymentDetailsCvvResultCode | String | The CVV response code from the card issuer (single letter or blank if unavailable). | |
| PaymentIconId | String | The unique identifier for the associated payment icon image. | |
| PaymentIconWidth | Int | The original width of the payment icon image in pixels, or null if not hosted by Shopify. | |
| PaymentIconAltText | String | Alternative text describing the payment icon image. | |
| PaymentIconHeight | Int | The original height of the payment icon image in pixels, or null if not hosted by Shopify. | |
| AmountSetPresentmentMoneyAmount | Decimal | The transaction amount in the presentment currency. | |
| AmountSetPresentmentMoneyCurrencyCode | String | The presentment currency code. | |
| AmountSetShopMoneyAmount | Decimal | The transaction amount in the shop currency. | |
| AmountSetShopMoneyCurrencyCode | String | The shop currency code. | |
| MaximumRefundableV2Amount | Decimal | The maximum refundable amount for this transaction. | |
| MaximumRefundableV2CurrencyCode | String | The currency code for the maximum refundable amount. | |
| ShopifyPaymentsSetExtendedAuthorizationSetExtendedAuthorizationExpiresAt | Datetime | The time when the extended authorization expires. After expiry, the payment can no longer be captured. | |
| ShopifyPaymentsSetExtendedAuthorizationSetStandardAuthorizationExpiresAt | Datetime | The time after which capturing the payment incurs an additional fee. | |
| ShopifyPaymentsSetRefundSetAcquirerReferenceNumber | String | The acquirer reference number (ARN) generated for Visa/Mastercard transactions. | |
| TotalUnsettledSetPresentmentMoneyAmount | Decimal | The unsettled transaction amount in the presentment currency. | |
| TotalUnsettledSetPresentmentMoneyCurrencyCode | String | The presentment currency code for the unsettled amount. | |
| TotalUnsettledSetShopMoneyAmount | Decimal | The unsettled transaction amount in the shop currency. | |
| TotalUnsettledSetShopMoneyCurrencyCode | String | The shop currency code for the unsettled amount. |