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: =.
The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:
To query the CustomerBalanceTransactions we can try the below queries.
SELECT * from CustomerBalanceTransactions where Id = 'cbtxn_1OduT9SC4snQ4WkOY0nOBfpk'
SELECT * from CustomerBalanceTransactions where CustomerId = 'cbtxn_1OduT9SC4snQ4WkOY0nOBfpk'
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 |