UsageCharges
Create or view Usage Charges for Recurring Application Charges.
Table-Specific Information
Select
The adapter processes all filters client-side within the adapter. 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 | Integer | False |
The risk Level |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| RecurringApplicationId | Long |
The Id of the RecurringApplication Charge |