JDBC Driver for Stripe

Build 24.0.9062

BalanceTransactions

Query Balance History in Stripe.

Table Specific Information

Select

Server-Side Query Support

The 本製品 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 本製品.

  • 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Transfer String For automatic Stripe transfers only, only returns transactions that were transferred out on the specified transfer Id.
Payout String For automatic Stripe payouts only, only returns transactions that were payed out on the specified payout ID.
AccountId String The Id of the connected account to get balance history for

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062