ADO.NET Provider for Stripe

Build 23.0.8771

CashBalance

Get the cash balance for the customer.

Table Specific Information

Select

The 本製品 uses the Stripe API to filter the results by the following column and operator:

  • CustomerId supports the = operator.
  • AccountId supports the = operator.

The rest of the filter is executed client-side within the 本製品.

The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:

SELECT * FROM CashBalance
SELECT * FROM CashBalance WHERE CustomerId = 'cus_qwew123'

Columns

Name Type References Description
CustomerId [KEY] String The Id of the customer.
Available Integer A hash of all cash balances available to this customer.
Livemode Boolean true if the object is in live mode andfalse if in test mode.
object String String representing the object's type.
ReconciliationMode String The configuration for how funds that land in the customer cash balance are reconciled.
UsingMerchantDefault Boolean A flag to indicate if reconciliation mode returned is the user?s default or is specific to this customer cash balance.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AccountId String The Id of the connected account to get customer discounts for

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