CashBalance
Get the cash balance for the customer.
Table Specific Information
Select
The connector uses the Stripe API to filter the results by the following column and operator:
- CustomerId supports the = operator.
- AccountId supports the = operator.
The rest of the filter is executed client-side within the connector.
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:
SELECT * FROM CashBalance SELECT * FROM CashBalance WHERE CustomerId = 'cus_qwew123'
Columns
| Name | Type | References | Description |
| CustomerId [KEY] | String | The Id of the customer. | |
| Available | String | A hash of all cash balances available to this customer. | |
| Livemode | Boolean | true if the object is in live mode andfalse if in test mode. | |
| object | String | String representing the object's type. | |
| ReconciliationMode | String | The configuration for how funds that land in the customer cash balance are reconciled. | |
| UsingMerchantDefault | Boolean | A flag to indicate if reconciliation mode returned is the user?s default or is specific to this customer cash balance. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get customer discounts for |