OrderTransactions

Lists payment transactions associated with orders (authorization, capture, refund).

Table-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.

ResourceId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM OrderTransactions WHERE ResourceId = 'Val1'

Insert

The following columns can be used to create a new record:

ResourceId, ParentTransactionId

The following pseudo-columns can be used to create a new record:

Amount, Currency, FinalCapture

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally unique Id.
ResourceId [KEY]	String	True	Orders.Id	A globally unique Id.
PaymentId	String	True		The payment Id associated with the transaction.
ParentTransactionId	String	True		The parent transaction associated with this transaction, for example the authorization of a capture.
AccountNumber	String	True		The masked account number associated with the payment method.
Gateway	String	True		The payment gateway used to process the transaction.
Kind	String	True		The type of transaction (for example, authorization, capture, or refund).
Status	String	True		The status of the transaction.
Test	Bool	True		Whether the transaction is a test transaction.
AuthorizationCode	String	True		The authorization code associated with the transaction.
ErrorCode	String	True		A standardized error code, independent of the payment provider.
FormattedGateway	String	True		The human-readable payment gateway name used to process the transaction.
ManuallyCapturable	Bool	True		Whether the transaction can be manually captured.
MultiCapturable	Bool	True		Whether the transaction can be captured multiple times.
ProcessedAt	Datetime	True		The date and time when the transaction was processed.
ReceiptJson	String	True		The transaction receipt attached by the payment gateway. The content depends on the payment gateway.
SettlementCurrency	String	True		The settlement currency of the transaction.
AuthorizationExpiresAt	Datetime	True		The date and time when the authorization expires. Available only to Shopify Plus stores, and only for Shopify Payments authorizations.
SettlementCurrencyRate	Decimal	True		The conversion rate used when converting the transaction amount to settlement currency.
CreatedAt	Datetime	True		The date and time when the transaction was created.
CardPaymentDetailsName	String	True		The name of the credit card holder.
CardPaymentDetailsBin	String	True		The issuer identification number (IIN), formerly called the bank identification number (BIN), from the first digits of the card.
CardPaymentDetailsCompany	String	True		The name of the company that issued the customer's credit card.
CardPaymentDetailsNumber	String	True		The customer's credit card number, with most leading digits redacted.
CardPaymentDetailsWallet	String	True		The digital wallet used for the payment.
CardPaymentDetailsExpirationMonth	Int	True		The month when the credit card expires.
CardPaymentDetailsExpirationYear	Int	True		The year when the credit card expires.
CardPaymentDetailsAvsResultCode	String	True		The address verification system (AVS) response code. Always a single letter.
CardPaymentDetailsCvvResultCode	String	True		The credit card company's response code for the card verification value (CVV). A single letter or empty string.
PaymentIconId	String	True		A unique Id for the payment icon image.
PaymentIconWidth	Int	True		The original width of the image in pixels. Returns null if the image isn't hosted by Shopify.
PaymentIconAltText	String	True		Alt text describing the content or purpose of the image.
PaymentIconHeight	Int	True		The original height of the image in pixels. Returns null if the image isn't hosted by Shopify.
AmountSetPresentmentMoneyAmount	Decimal	True		The transaction amount in the presentment currency, expressed as a decimal.
AmountSetPresentmentMoneyCurrencyCode	String	True		The currency code of the transaction amount in the presentment currency.
AmountSetShopMoneyAmount	Decimal	True		The transaction amount in the shop's currency, expressed as a decimal.
AmountSetShopMoneyCurrencyCode	String	True		The currency code of the transaction amount in the shop's currency.
MaximumRefundableV2Amount	Decimal	True		The maximum refundable amount, expressed as a decimal.
MaximumRefundableV2CurrencyCode	String	True		The currency code of the maximum refundable amount.
ShopifyPaymentsSetExtendedAuthorizationSetExtendedAuthorizationExpiresAt	Datetime	True		The date and time when the extended authorization expires. After this, the payment can no longer be captured.
ShopifyPaymentsSetExtendedAuthorizationSetStandardAuthorizationExpiresAt	Datetime	True		The date and time after which capturing the payment incurs an additional fee.
ShopifyPaymentsSetRefundSetAcquirerReferenceNumber	String	True		The acquirer reference number (ARN) for Visa or Mastercard transactions.
TotalUnsettledSetPresentmentMoneyAmount	Decimal	True		The unsettled transaction amount in the presentment currency, expressed as a decimal.
TotalUnsettledSetPresentmentMoneyCurrencyCode	String	True		The currency code of the unsettled amount in the presentment currency.
TotalUnsettledSetShopMoneyAmount	Decimal	True		The unsettled transaction amount in the shop's currency, expressed as a decimal.
TotalUnsettledSetShopMoneyCurrencyCode	String	True		The currency code of the unsettled amount in the shop's currency.
UserId	String	True		The staff member logged into Shopify POS when the transaction was processed. (Available only with a Shopify Plus subscription.)
AmountRoundingSetPresentmentMoneyAmount	Decimal	True		A monetary value in decimal format, allowing precise representation of cents or fractional currency. For example, 12.99.
AmountRoundingSetPresentmentMoneyCurrencyCode	String	True		The three-letter ISO 4217 currency code (or legacy/non-standard code) for the presentment currency. For example, USD.
AmountRoundingSetShopMoneyAmount	Decimal	True		A monetary value in decimal format, allowing precise representation of cents or fractional currency. For example, 12.99.
AmountRoundingSetShopMoneyCurrencyCode	String	True		The three-letter ISO 4217 currency code (or legacy/non-standard code) for the shop currency. For example, USD.
PaymentDetailsLocalPaymentDescriptor	String	True		The descriptor provided by the payment provider. Available only for Amazon Pay and Buy with Prime.
PaymentDetailsLocalPaymentMethodName	String	True		The local payment method name used by the buyer.
PaymentDetailsShopPayInstallmentsPaymentMethodName	String	True		The Shop Pay Installments payment method name used by the buyer.
PaymentDetailsCardAvsResultCode	String	True		The address verification system (AVS) response code. Always a single letter.
PaymentDetailsCardBin	String	True		The issuer identification number (IIN), formerly called the bank identification number (BIN), from the first digits of the card.
PaymentDetailsCardCompany	String	True		The name of the company that issued the customer's credit card.
PaymentDetailsCardCvvResultCode	String	True		The credit card company's response code for the card verification value (CVV). A single letter or empty string.
PaymentDetailsCardExpirationMonth	Int	True		The month when the credit card expires.
PaymentDetailsCardExpirationYear	Int	True		The year when the credit card expires.
PaymentDetailsCardName	String	True		The name of the credit card holder.
PaymentDetailsCardNumber	String	True		The customer's credit card number, with most leading digits redacted.
PaymentDetailsCardPaymentMethodName	String	True		The payment method name used by the buyer.
PaymentDetailsCardWallet	String	True		The digital wallet used for the payment.

Pseudo-Columns

Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.