ODBC Driver for Shopify

Build 24.0.9060

UsageCharges

Create or view Usage Charges for Recurring Application Charges.

Table-Specific Information

Select

The driver processes all filters client-side within the driver. The following queries are the only ones processed server-side:
SELECT * FROM UsageCharges WHERE Id = 123

SELECT * FROM UsageCharges WHERE RecurringApplicationId = 5569619

SELECT * FROM UsageCharges WHERE RecurringApplicationId = 5569619 AND Id = 123

Columns

Name Type ReadOnly References Description
Id [KEY] Long False

The ID of the usage charge.

Description String False

The name of the usage charge.

Price Decimal False

The price of the usage charge.

CreatedAt Datetime False

The date and time (ISO 8601 format) when the usage charge was created.

BalanceUsed Decimal False

The used balance

BalanceRemaining Decimal False

The remaining balance

RiskLevel Int False

The risk Level

RecurringApplicationId Long False

RecurringApplicationCharges.Id

The Id of the RecurringApplication Charge

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