CashBalance
Get the cash balance for the customer.
Table Specific Information
Select
The 本製品 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 本製品.
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get customer discounts for |