CashBalance
Returns the cash balance for a customer, including the available balances by currency and reconciliation settings.
View-Specific Information
SELECT
The provider 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 provider.
| Column | Supported Operators |
| CustomerId | = |
| AccountId | = |
You can select from CashBalance with the following queries:
SELECT * FROM CashBalance WHERE CustomerId = 'cus_qwew123'
SELECT * FROM CashBalance WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'
Columns
| Name | Type | References | Description |
| CustomerId [KEY] | String |
Customers.Id | The Id of the customer. |
| Available | String | A set of all cash balances available to this customer. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. Returns false if the object exists in test mode. | |
| object | String | The string representing the object's type. | |
| ReconciliationMode | String | The configuration for how funds that land in the customer cash balance are reconciled. | |
| UsingMerchantDefault | Boolean | Indicates whether the reconciliation mode returned is the user's default or is specific to this customer cash balance. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account for which to retrieve the cash balance. |