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 本製品.
You can select from CashBalance with the following queries:
SELECT * FROM CashBalance WHERE CustomerId = 'cus_qwew123' SELECT * FROM CashBalance WHERE Livemode = true SELECT * FROM CashBalance WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'
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 |