AvailableBalance

Query the Available Balance in Stripe.

Table Specific Information

Select

Server-Side Query Support

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

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.