CashBalanceTransactions
Query Cash Balance Transactions 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 and CustomerId support the following operator: =.
You can select:
All cash balance transactions:
SELECT * FROM CashBalanceTransactions
A cash balance transaction by specifying both its Id and CustomerId:
SELECT * FROM CashBalanceTransactions WHERE Id = 'ccsbtxn_1Q0yb2ATXQzBWNrl8rqvEizC' AND CustomerId = 'cus_PwQLqslVNldED7'
Cash balance transactions associated with its associated CustomerId:
SELECT * FROM CashBalanceTransactions WHERE CustomerId = 'cus_PwQLqslVNldED7'
Cash balance transactions associated with its Id:
SELECT * FROM CashBalanceTransactions WHERE Id = 'ccsbtxn_1Q3XBhATXQzBWNrlqd5UcD8l'
Columns
Name | Type | References | Description |
Id [KEY] | String | The Id of the Cash Balance Transaction. | |
CustomerId [KEY] | String |
Customers.Id | The customer whose available cash balance changed as a result of this transaction. |
AdjustedForOverdraftBalanceTransaction | String | If this is a type=adjusted_for_overdraft transaction, contains the Balance Transaction that corresponds to funds taken out of your Stripe balance. | |
AdjustedForOverdraftLinkedTransaction | String | If this is a type=adjusted_for_overdraft transaction, contains the Cash Balance Transaction that brought the customer balance negative, triggering the clawback of funds. | |
AppliedToPaymentPaymentIntent | String | If this is a type=applied_to_payment transaction, contains the Payment Intent that funds were applied to. | |
Created | Datetime | Time at which the object was created. Measured in seconds since the Unix epoch. | |
Currency | String | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
EndingBalance | Integer | The total available cash balance for the specified currency after this transaction was applied. Represented in the smallest currency unit. | |
FundedBankTransferEuBankTransferBic | String | If this is a type=funded transaction, and the bank transfer is an EU bank transfer which funded the customer's cash balance, contains the BIC of the bank of the sender of the funding. | |
FundedBankTransferEuBankTransferIbanLast4 | Integer | If this is a type=funded transaction, and the bank transfer is an EU bank transfer which funded the customer's cash balance, contains the last 4 digits of the IBAN of the sender of the funding. | |
FundedBankTransferEuBankTransferSenderName | String | If this is a type=funded transaction, and the bank transfer is an EU bank transfer which funded the customer's cash balance, contains the full name of the sender, as supplied by the sending bank. | |
FundedBankTransferGbBankTransferAccountNumberLast4 | Integer | If this is a type=funded transaction, and the bank transfer is a UK bank transfer which funded the customer's cash balance, contains the last 4 digits of the account number of the sender of the funding. | |
FundedBankTransferGbBankTransferSenderName | String | If this is a type=funded transaction, and the bank transfer is a UK bank transfer which funded the customer's cash balance, contains the full name of the sender, as supplied by the sending bank. | |
FundedBankTransferGbBankTransferSortCode | String | If this is a type=funded transaction, and the bank transfer is a UK bank transfer which funded the customer's cash balance, contains the sort code of the bank of the sender of the funding. | |
FundedBankTransferJpBankTransferSenderBank | String | If this is a type=funded transaction, and the bank transfer is a Japan bank transfer which funded the customer's cash balance, contains the name of the bank of the sender of the funding. | |
FundedBankTransferJpBankTransferSenderBranch | String | If this is a type=funded transaction, and the bank transfer is a Japan bank transfer which funded the customer's cash balance, contains the name of the bank branch of the sender of the funding. | |
FundedBankTransferJpBankTransferSenderName | String | If this is a type=funded transaction, and the bank transfer is a Japan bank transfer which funded the customer's cash balance, contains the full name of the sender, as supplied by the sending bank. | |
FundedBankTransferReference | String | If this is a type=funded transaction, contains the user-supplied reference field on the bank transfer. | |
FundedBankTransferType | String | If this is a type=funded transaction, contains the funding method type used to fund the customer balance. Permitted values include: eu_bank_transfer, gb_bank_transfer, jp_bank_transfer, mx_bank_transfer, or us_bank_transfer. | |
FundedBankTransferUsBankTransferNetwork | String | If this is a type=funded transaction, contains US-specific banking network used for this funding. | |
FundedBankTransferUsBankTransferSenderName | String | If this is a type=funded transaction, contains US-specific full name of the sender, as supplied by the sending bank. | |
Livemode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
NetAmount | Integer | The amount by which the cash balance changed, represented in the smallest currency unit. A positive value represents funds being added to the cash balance, a negative value represents funds being removed from the cash balance. | |
RefundedFromPaymentRefund | String | If this is a type=refunded_from_payment transaction, contains the Refund that moved these funds into the customer’s cash balance. | |
TransferredToBalanceBalanceTransaction | String | If this is a type=transferred_to_balance transaction, contains the Balance Transaction that corresponds to funds transferred to your Stripe balance. | |
Type | String | The type of the cash balance transaction. New types may be added in future. | |
UnappliedFromPaymentPaymentIntent | String | If this is a type=unapplied_from_payment transaction, contains the Payment Intent that funds were unapplied from. | |
Object | String | String representing the object’s type. Objects of the same type share the same value. |