CustomerBalanceTransactions
Returns a list of transactions that updated the customers balances.
Table Specific Information
Select
Server-Side Query Support
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.
- Id support the following operator: =.
- CustomerIdId support the following operator: =.
You can select from CustomerBalanceTransactions with the following queries:
SELECT * from CustomerBalanceTransactions where Id = 'cbtxn_1OduT9SC4snQ4WkOY0nOBfpk'
SELECT * from CustomerBalanceTransactions where CustomerId = 'cbtxn_1OduT9SC4snQ4WkOY0nOBfpk'
SELECT * FROM CustomerBalanceTransactions WHERE Amount > 5000
SELECT * FROM CustomerBalanceTransactions WHERE Currency = 'usd'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier for the object. | |
| CustomerId [KEY] | String | 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 | 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 | Transaction type | |
| CreditNote | String | The ID of the credit note (if any) related to the transaction. | |
| Invoice | String | The ID of the invoice (if any) related to the transaction. | |
| Livemode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
| MetadataAggregate | String | The set of key/value pairs that you can attach to a an object. | |
| Object | String | The object’s type. Objects of the same type share the same value. |