PendingBalance
Query the available balance in Stripe.
Table Specific Information
Select
You can select from PendingBalance with the following queries:
SELECT * FROM PendingBalance WHERE Currency = 'usd'
SELECT * FROM PendingBalance WHERE Livemode = true
SELECT * FROM PendingBalance WHERE SourceTypesCard > 1000
SELECT * FROM PendingBalance WHERE SourceTypesBankAccount > 5000
SELECT * FROM PendingBalance WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'
Columns
| Name | Type | References | Description |
| Currency | String | The currency of the balance. | |
| Amount | Integer | The pending amount. | |
| SourceTypesAggregate | String | The source cards. | |
| SourceTypesCard | Integer | The source cards. | |
| SourceTypesBankAccount | Integer | The source Bank Account. | |
| SourceTypesBitcoinReceiver | Integer | The source 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 pending balance for. |