OrderTransactions
List of all transactions associated with the orders.
View-Specific Information
Select
The adapter uses the Shopify API to process search criteria that refer to the OrderId column. The adapter processes other filters client-side within the adapter.
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 adapter 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 adapter 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 adapter 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'
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. |