BalanceTransactions

Query Balance History 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.

Id, Currency, Source, Type, Payout, and AccountId support the following operator: =.
Created supports the following operators: >, >=, <, <=, =.

You can select from BalanceTransactions with the following queries:

    SELECT * FROM BalanceTransactions
    SELECT * FROM BalanceTransactions WHERE Id = 'txn_1K2M4c2eZvKYlo2C1C1A1bQq'
    SELECT * FROM BalanceTransactions WHERE Created >= '2023-01-01' AND Created <= '2023-12-31'
    SELECT * FROM BalanceTransactions WHERE Created >= '2023-01-01' AND Created <= '2023-12-31'

You can also filter balance transactions by a specified payout:

SELECT * FROM BalanceTransactions WHERE Payout = '123'

Columns


Name	Type	References	Description
Id [KEY]	String		The Id of the balance transaction.
Amount	Integer		Gross amount of the transaction, in cents.
AvailableOn	Datetime		The date the net funds of the transaction will become available in the Stripe balance.
Created	Datetime		The datetime of creation.
Currency	String		The currency of the transaction.
Description	String		The transaction description.
Fee	Integer		Fees (in cents) paid for this transaction.
FeeDetailsAggregate	String		The fee details.
Net	Integer		Net amount of the transaction, in cents.
Source	String		The Stripe object this transaction is related to.
Status	String		If the net funds of the transaction are available in the Stripe balance yet. Either available or pending.
Type	String		Transaction type.
ReportingCategory	String		reporting categories can help you understand balance transactions from an accounting perspective.
ExchangeRate	Decimal		The exchange rate used, if applicable, for this transaction.

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.