RefundTransactions
Lists payment transactions generated as part of a refund.
View-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following column and operators. The provider processes other filters client-side within the provider.
- 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. | |
| UserId | String | Staff member who was logged into the Shopify POS device when the transaction was processed. (This column is available only with a ShopifyPlus subscription) | |
| 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. | |
| AmountRoundingSetPresentmentMoneyAmount | Decimal | A monetary value in decimal format, allowing for precise representation of cents or fractional currency. For example, 12. 99. | |
| AmountRoundingSetPresentmentMoneyCurrencyCode | String | The three-letter currency code that represents a world currency used in a store. Currency codes include standard ISO 4217 codes, legacy codes, and non-standard codes. For example, USD. | |
| AmountRoundingSetShopMoneyAmount | Decimal | A monetary value in decimal format, allowing for precise representation of cents or fractional currency. For example, 12. 99. | |
| AmountRoundingSetShopMoneyCurrencyCode | String | The three-letter currency code that represents a world currency used in a store. Currency codes include standard ISO 4217 codes, legacy codes, and non-standard codes. For example, USD. | |
| CurrencyExchangeAdjustmentId | String | A globally-unique ID of the adjustment on the transaction. | |
| PaymentDetailsLocalPaymentDescriptor | String | The descriptor by the payment provider. Only available for Amazon Pay and Buy with Prime. | |
| PaymentDetailsLocalPaymentMethodName | String | The name of payment method used by the buyer. | |
| PaymentDetailsShopPayInstallmentsPaymentMethodName | String | The name of payment method used by the buyer. | |
| PaymentDetailsCardAvsResultCode | String | The response code from the address verification system (AVS). The code is always a single letter. | |
| PaymentDetailsCardBin | String | The issuer identification number (IIN), formerly known as bank identification number (BIN) of the customer's credit card. This is made up of the first few digits of the credit card number. | |
| PaymentDetailsCardCompany | String | The name of the company that issued the customer's credit card. | |
| PaymentDetailsCardCvvResultCode | String | The response code from the credit card company indicating whether the customer entered the card security code, or card verification value, correctly. The code is a single letter or empty string. | |
| PaymentDetailsCardExpirationMonth | Int | The month in which the used credit card expires. | |
| PaymentDetailsCardExpirationYear | Int | The year in which the used credit card expires. | |
| PaymentDetailsCardName | String | The holder of the credit card. | |
| PaymentDetailsCardNumber | String | The customer's credit card number, with most of the leading digits redacted. | |
| PaymentDetailsCardPaymentMethodName | String | The name of payment method used by the buyer. | |
| PaymentDetailsCardWallet | String | Digital wallet used for the payment. | |
| 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. |