ADO.NET Provider for Stripe

Build 24.0.9062

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.

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