AvailableBalance
Query the Available Balance in Stripe.
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 本製品.
- AccountId support the following operator: =.
You can select from Authorizations with the following queries:
SELECT * FROM AvailableBalance WHERE AccountId = 'acct_1Gqj58Ly0qyl5A' SELECT * FROM AvailableBalance WHERE Currency = 'usd' SELECT * FROM AvailableBalance WHERE Livemode = true SELECT * FROM AvailableBalance WHERE Amount > 10000
Columns
Name | Type | References | Description |
Currency | String | The currency of the available balance. | |
Amount | Long | The available amount. | |
SourceTypesCard | Long | The source cards. | |
SourceTypesBankAccount | Long | Amount for bank account. | |
SourceTypesBitcoinReceiver | Long | Amount for Bitcoin Receiver. | |
Livemode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description | |
AccountId | String | The Id of the connected account to get available balance for |