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

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

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	Integer	False		The risk Level

Pseudo-Columns

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

Name	Type	Description
RecurringApplicationId	Long	The Id of the RecurringApplication Charge