CashBalanceTransactions
Query Cash Balance Transactions 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 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. |