PendingBalance
Returns the pending balance, including amounts by currency and a breakdown by source type.
View-Specific Information
SELECT
The add-in 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 add-in.
| Column | Supported Operators |
| AccountId | = |
You can select from PendingBalance with the following queries:
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 breakdown of the pending balance amount by source type. | |
| SourceTypesCard | Integer | The source cards. | |
| SourceTypesBankAccount | Integer | The source Bank Account. | |
| SourceTypesBitcoinReceiver | Integer | DEPRECATED. 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. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get pending balance for. |