Transactions
Returns issuing transactions, including the transaction amount, associated card and cardholder, merchant data, and purchase details. The transactions are sorted in descending order by creation date, with the most recently created transaction appearing first.
View-Specific Information
SELECT
The connector uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the connector.
| Column | Supported Operators |
| Id | = |
| Card | = |
| Cardholder | = |
| Type | = |
| Created | =, >, >=, <, <= |
| AccountId | = |
You can select from Transactions with the following queries:
SELECT * FROM Transactions WHERE Id = 'ipi_1ODMLL2eZvKYlo2CoarGZSSp'
SELECT * FROM Transactions WHERE Card = 'card_1GhPzLJXTn'
SELECT * FROM Transactions WHERE Cardholder = 'cardholder_12345'
SELECT * FROM Transactions WHERE Type = 'purchase'
SELECT * FROM Transactions WHERE Created >= '2024-01-01'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the transaction. | |
| Amount | Integer | The transaction amount, which is reflected in your balance. | |
| AmountDetailsAtmFee | Integer | The fee charged by the ATM for the cash withdrawal. | |
| AmountDetailsCashbackAmount | Integer | The amount of cash requested by the cardholder. | |
| Authorization | String | The authorization object that led to this transaction. | |
| BalanceTransaction | String | The balance transaction that describes the impact on your account balance. | |
| Card | String | The card used to make this transaction. | |
| Cardholder | String | The cardholder to whom this transaction belongs. | |
| Currency | String | The three-letter ISO currency code, in lowercase. Must be a supported currency. | |
| MetadataAggregate | String | The set of key-value pairs that you can attach to the transaction. | |
| Type | String | The nature of the transaction. | |
| Created | Datetime | The time at which the transaction was created, measured in seconds since the Unix epoch. | |
| Dispute | String | The Id of the dispute, if you have disputed the transaction. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. Has the value true if the object exists in live mode, or the value false if the object exists in test mode. | |
| MerchantAmount | Integer | The amount that the merchant receives, denominated in merchant_currency and in the smallest currency unit. | |
| MerchantCurrency | String | The currency with which the merchant is taking payment. | |
| MerchantDataCategory | String | A categorization of the seller's type of business. | |
| MerchantDataCategoryCode | String | The merchant category code for the seller's business. | |
| MerchantDataCity | String | The city where the seller is located. | |
| MerchantDataCountry | String | The country where the seller is located. | |
| MerchantDataName | String | The name of the seller. | |
| MerchantDataNetworkId | String | The identifier assigned to the seller by the card network. | |
| MerchantDataPostalCode | String | The postal code where the seller is located. | |
| MerchantDataState | String | The state where the seller is located. | |
| MerchantDataTerminalId | String | The Id assigned by the seller to the location of the sale. | |
| MerchantDataURL | String | The URL provided by the merchant on a 3DS request. | |
| NetworkDataAuthorizationCode | String | A code created by Stripe that is shared with the merchant to validate the authorization. | |
| NetworkDataProcessingDate | String | The date the transaction was processed by the card network. | |
| NetworkDataTransactionId | String | The unique identifier for the authorization, assigned by the card network and used to match subsequent messages, disputes, and transactions. | |
| PurchaseDetailsFlight | String | Information about the flight that was purchased with this transaction. | |
| PurchaseDetailsFuel | String | Information about fuel that was purchased with this transaction. | |
| PurchaseDetailsLodging | String | Information about lodging that was purchased with this transaction. | |
| PurchaseDetailsReceipt | String | The line items in the purchase. | |
| PurchaseDetailsReference | String | A merchant-specific order number. | |
| Token | String | The token object used for this transaction. | |
| Wallet | String | The digital wallet used for this transaction. | |
| MerchantDataTaxId | String | The tax Id of the seller. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get transactions for. |