List of all transactions associated with the orders.

View-Specific Information

Select

The driver uses the Shopify API to process search criteria that refer to the OrderId column. The driver processes other filters client-side within the driver.

The Shopify APIs requires the search criteria to contain OrderId. For example, the following query is processed server side.

SELECT * FROM OrderTransactions WHERE OrderId = '123'

When performing a query without a filter or a filter other then the OrderId column, the driver will retrieve the entire list of transactions and perform the filters client-side. The Shopify API requires that an OrderId be specified when retrieving transactions. Therefore to retrieve all the transactions, the driver will first retrieve all the OrderIds from the Orders table (essentially performing the query: SELECT Id FROM Orders). Once the OrderId values have been retrieved, the driver will issue individual requests to the Shopify API to retrieve all the transactions for each OrderId to build the result set.

SELECT * FROM OrderTransactions

SELECT * FROM OrderTransactions WHERE Kind='Capture'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false. Other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name	Type	References	Description
Id [KEY]	String		Globally unique identifier.
OrderId	String		The Id of the associated order.
AccountNumber	String		The masked account number associated with the payment method.
AmountSetPresentmentMoneyAmount	Decimal		The amount of the transaction in presentment currency.
AmountSetPresentmentMoneyCurrencyCode	String		The currency of the transaction in presentment currency.
AmountSetShopMoneyAmount	Decimal		The amount of the transaction in shop currency.
AmountSetShopMoneyCurrencyCode	String		The currency of the transaction in shop currency.
AuthorizationCode	String		Authorization code associated with the transaction.
CreatedAt	Datetime		Date and time when the transaction was created.
ErrorCode	String		A standardized error code, independent of the payment provider.
FormattedGateway	String		The human-readable payment gateway name used to process the transaction.
Gateway	String		The payment gateway used to process the transaction.
Kind	String		The kind of transaction.
ManuallyCapturable	Boolean		Whether the transaction can be manually captured.
MaximumRefundableMoneyAmount	Decimal		The available amount with currency to refund on the gateway.
MaximumRefundableMoneyCurrencyCode	String		The currency of the refund on the gateway.
ParentTransactionId	String		The associated parent transaction, for example the authorization of a capture.
ProcessedAt	Datetime		Date and time when the transaction was processed.
Status	String		The status of this transaction.
Test	Boolean		Whether the transaction is a test transaction.
TotalUnsettledSetPresentmentMoneyAmount	Decimal		The available amount to capture on the gateway in presentment currency.
TotalUnsettledSetPresentmentMoneyCurrencyCode	String		The available money currency to capture on the gateway in presentment currency.
TotalUnsettledSetShopMoneyAmount	Decimal		The available amount to capture on the gateway in shop currency.
TotalUnsettledSetShopMoneyCurrencyCode	String		The available money currency to capture on the gateway in shop currency.