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 |