TenderTransactions
Lists tender (payment method) transactions recorded by the shop.
View-Specific Information
Select
The server uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The server processes other filters client-side within the server.
- Id supports the '=, IN' comparison operators.
- Test supports the '=, !=' comparison operators.
- ProcessedAt supports the '=, !=, <, >, >=, <=' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM TenderTransactions WHERE Id = 'Val1'
SELECT * FROM TenderTransactions WHERE Test = true
SELECT * FROM TenderTransactions WHERE ProcessedAt = '2023-01-01 11:10:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id for the tender transaction. | |
| Test | Bool | Indicates whether the transaction is a test transaction. | |
| PaymentMethod | String | Details about the payment method used for the transaction. | |
| ProcessedAt | Datetime | The date and time when the transaction was processed. | |
| RemoteReference | String | The remote gateway reference associated with the tender transaction. | |
| AmountAmount | Decimal | The transaction amount, expressed as a decimal value. | |
| AmountCurrencyCode | String | The currency code of the transaction amount. | |
| TenderTransactionCreditCardDetailsCreditCardCompany | String | The name of the company that issued the customer's credit card (for example, Visa). | |
| TenderTransactionCreditCardDetailsCreditCardNumber | String | The customer's credit card number, with all digits except the last four redacted. | |
| UserId | String | A globally unique Id for the user associated with the transaction. Available only with a Shopify Plus subscription. | |
| OrderId | String | A globally unique Id for the associated order. |