ADO.NET Provider for Stripe

Build 24.0.9062

CustomerBalanceTransactions

Returns a list of transactions that updated the customers balances.

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 support the following operator: =.
  • CustomerIdId support the following operator: =.

You can select from CustomerBalanceTransactions with the following queries:

    SELECT * from CustomerBalanceTransactions where  Id = 'cbtxn_1OduT9SC4snQ4WkOY0nOBfpk'
    SELECT * from CustomerBalanceTransactions where  CustomerId = 'cbtxn_1OduT9SC4snQ4WkOY0nOBfpk'
    SELECT * FROM CustomerBalanceTransactions WHERE Amount > 5000
    SELECT * FROM CustomerBalanceTransactions WHERE Currency = 'usd'

Columns

Name Type References Description
Id [KEY] String Unique identifier for the object.
CustomerId [KEY] String The ID of the customer the transaction belongs to.
Amount Integer The amount of the transaction.
Currency String Three-letter ISO currency code, in lowercase. Must be a supported currency.
Created Datetime Time at which the object was created. Measured in seconds since the Unix epoch.
Description String An arbitrary string attached to the object. Often useful for displaying to users.
EndingBalance Integer The customer’s balance after the transaction was applied.
Type String Transaction type
CreditNote String The ID of the credit note (if any) related to the transaction.
Invoice String The ID of the invoice (if any) related to the transaction.
Livemode Boolean Has the value true if the object exists in live mode or the value false if the object exists in test mode.
MetadataAggregate String The set of key/value pairs that you can attach to a an object.
Object String 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