CustomerBalanceTransactions
Returns a list of transactions that updated the customers balances.
View-Specific Information
SELECT
The add-in 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 add-in.
| Column | Supported Operators |
| Id | = |
| CustomerId | = |
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 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 | The date and 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 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 | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. | |
| MetadataAggregate | String | The set of key-value pairs that you can attach to an object. | |
| Object | String |