CustomerBalanceTransactions
Returns a list of transactions that updated the customers balances.
Table Specific Information
Select
Server-Side Query Support
The 本製品 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 本製品.
- 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. |