CustomerBalanceTransactions
Returns the transactions that updated a customer's balance, including transaction amounts, types, and related invoice and credit note details.
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 | = |
| CustomerId | = |
| Created | =, >, >=, <, <= |
| Invoice | = |
You can select from CustomerBalanceTransactions with the following queries:
SELECT * FROM CustomerBalanceTransactions WHERE Id = 'cbtxn_1OduT9SC4snQ4WkOY0nOBfpk'
SELECT * FROM CustomerBalanceTransactions WHERE CustomerId = 'cus_N8rO0qc7j1SJJ9'
SELECT * FROM CustomerBalanceTransactions WHERE Created >= '2025-11-19 01:20:01.0'
SELECT * FROM CustomerBalanceTransactions WHERE Invoice = 'in_233418784'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the transaction object. | |
| CustomerId [KEY] | String |
Customers.Id | The Id of the customer the transaction belongs to. |
| Amount | Integer | The amount of the transaction. | |
| Currency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
| Created | Datetime | The time at which the object was created. Measured in seconds since the Unix epoch. | |
| Description | String | An arbitrary string attached to the object. Often useful for displaying to users. | |
| EndingBalance | Integer | The customer's balance after the transaction was applied. | |
| Type | String | The type of the transaction. | |
| CreditNote | String | The Id of the credit note, if any, related to the transaction. | |
| Invoice | String |
Invoices.Id | The Id of the invoice, if any, related to the transaction. |
| Livemode | Boolean | Indicates whether the object exists in live mode. Returns true if the object exists in live mode and false if the object exists in test mode. | |
| MetadataAggregate | String | The set of key/value pairs that you can attach to the transaction object. | |
| Object | String | The string representing the object's type. Objects of the same type share the same value. |