JDBC Driver for Shopify

Build 23.0.8839

UsageCharges

Create or view Usage Charges for Recurring Application Charges.

Table-Specific Information

Select

The 本製品 processes all filters client-side within the 本製品. 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.

BillingOn Date False

The date and time (ISO 8601 format) when the customer is billed.

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 23.0.8839