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. |