TenderTransactions
Returns a list of TenderTransactions associated with the shop.
View-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=,IN' comparison operators.
- Test supports the '=,!=' comparison operators.
- ProcessedAt supports the '=,!=,<,>,>=,=<' comparison operators.
The 本製品 processes other filters client-side within the 本製品.
For example, the following queries are processed server-side:
SELECT * FROM TenderTransactions WHERE Id='VALUE'
SELECT * FROM TenderTransactions WHERE Test='true'
SELECT * FROM TenderTransactions WHERE ProcessedAt<'2000-01-01 01:00:00.0'
Columns
Name | Type | References | Description |
Id [KEY] | String | A globally-unique ID. | |
Test | Bool | Whether the transaction is a test transaction. | |
PaymentMethod | String | Information about the payment method used for the transaction. | |
ProcessedAt | Datetime | Date and time when the transaction was processed. | |
RemoteReference | String | The remote gateway reference associated with the tender transaction. | |
AmountAmount | Decimal | Decimal money amount. | |
AmountCurrencyCode | String | Currency of the money. | |
TenderTransactionCreditCardDetailsCreditCardCompany | String | The name of the company that issued the customer's credit card. Example: 'Visa'. | |
TenderTransactionCreditCardDetailsCreditCardNumber | String | The customer's credit card number, with all digits except the last 4 redacted. Example: '???? ???? ???? 1234' | |
UserId | String | A globally-unique ID.(This column is available only with a ShopifyPlus subscription) |