API for browsing, adding, editing and deleting Rate Schedules.
GET /rateschedules
Return a list of Rate Schedules.
GET /rateschedules/{Id}
Return a specific Rate Schedule.
POST /rateschedules
Create a new Rate Schedule.
PUT /rateschedules
Update an existing Rate Schedule.
DELETE /rateschedules/{Id}
Delete the specified Rate Schedule.
GET /ratescheduleitems
Return a list of Rate Schedule Items.
GET /rateschedules/{RateScheduleId}/ratescheduleitems
Return a list of Rate Schedule Items assigned to the specified Rate Schedule.
GET /ratescheduleitems/{Id}
Return a specific Rate Schedule Item.
POST /ratescheduleitems
Create a new Rate Schedule Item.
PUT /ratescheduleitems/{Id}
Update an existing Rate Schedule Item.
DELETE /ratescheduleitems/{Id}
Delete the specified Rate Schedule Item.
Looking up a Resource (single objects, lists and tabular data)
Creating a Resource
Copying a Resource
Updating a Resource
Deleting a Resource
{
"RateScheduleId": 1,
"NewRateScheduleName": ""
}
{
"RateScheduleId": 0,
"RateSchedule": "",
"Description": "",
"BillingPackageId": 0,
"BillingPackageName": "",
"MobileChargeScheduleId": 0,
"MobileChargeScheduleName": ""
}
{
"RateScheduleItemId": 0,
"RateScheduleId": 0,
"RateScheduleName": "",
"MobileChargeScheduleId": 0,
"MobileChargeScheduleName": "",
"Description": "",
"Origin": "",
"CallType": "ctAny",
"MobileProfileId": 0,
"MobileProfileName": "",
"Dnis": "",
"Ani": "",
"StartDate": "",
"EndDate": "",
"DayRange": "",
"StartTime": "",
"EndTime": "",
"Priority": 0,
"Enabled": false,
"RatePlanId": 0,
"RatePlanName": "",
"OverrideGracePeriod": false,
"GracePeriod": 0,
"OverrideMinSecsBilled": false,
"MinSecsBilled": 0,
"OverrideShortestCallAllowed": false,
"ShortestCallAllowed": 0,
"OverrideBillingDelay": false,
"BillingDelay": 0,
"OverrideRateInterval": false,
"RateInterval": 0,
"OverrideSpeakRateInterval": false,
"SpeakRateInterval": false,
"OverrideDisconnectCharge": false,
"DisconnectCharge": 0,
"DisconnectChargeType": "dctFixedAmount",
"OverrideDisconnectChargeCallEnd": false,
"DisconnectChargeCallEnd": false,
"OverrideSpeakDisconnectCharge": false,
"SpeakDisconnectCharge": false,
"ThresholdType": "ttCalls",
"ThresholdValue": 0
}
Rate Schedules allow you to assign one or more Rate Schedule Items that consist of a rate plan that is scheduled based on time of day, day of week, call origination and call termination so that different plans become active depending on certain criteria being met. Through the use of Rate Schedules and Rate Schedule Items you can create peak, off peak, weekend and holiday rates with the server application managing when the various underlying rate plans become
effective.
Field Name | Type | Size | Description |
---|---|---|---|
RATE_SCHEDULE_ID | smallint | 2 | Primary key. |
RATE_SCHEDULE | varchar | 40 | Unique name identifying this rate schedule. |
DESCRIPTION | varchar | 40 | Description of this entry. |
BILLING_PACKAGE_ID | bigint | 8 | Foreign key into the BILLING_PACKAGES table. |
MOBILE_CHARGE_SCHEDULE_ID | smallint | 8 | Foreign key into the MOBILE_CHARGE_SCHEDULES table. |
Rate Schedule Items consist of a rate plan that is scheduled based on time of day, day of week, call origination and call termination so that different plans become active depending on certain criteria being met. Through the use of Rate Schedules and Rate Schedule Items you can create peak, off peak, weekend and holiday rates with the server application managing when the various underlying rate plans become effective.
Field Name | Type | Size | Description |
---|---|---|---|
RATE_SCHEDULE_ITEM_ID | smallint | 2 | Primary key. |
RATE_SCHEDULE_ID | smallint | 2 | Foreign key into the RATE_SCHEDULES table that references the Rate Schedule associated with this item. |
DESCRIPTION | varchar | 40 | Description of this entry. |
ORIGIN | varchar | 40 | Specifies the Inbound Node that this Rate Schedule entry will apply to. |
ANI | varchar | 40 | Specifies the ANI this entry applies to. |
DNIS | varchar | 40 | Specifies the DNIS this entry applies to. |
START_DATE | smalldatetime | 4 | Specifies the start of the date range for which this entry is valid. |
END_DATE | smalldatetime | 4 | Specifies the end of the date range for which this entry is valid. |
DAY_RANGE | char | 7 | Specifies the day range for which this entry is valid. Days are specified as a bitmap, where the first bit represents Monday and the last bit represents Sunday. |
START_TIME | varchar | 8 | Specifies the start of the time range for which this entry is valid. |
END_TIME | varchar | 8 | Specifies the end of the time range for which this entry is valid. |
THRESHOLD_TYPE | tinyint | 1 | Threshold type from THRESHOLD_TYPES table (e.g. ‘Calls’ or ‘Minutes’) |
THRESHOLD_VALUE | int | 4 | Value of threshold (e.g. 10 calls) |
CALL_TYPE | tinyint | 1 | Foreign key into the CALL_TYPES table. |
MOBILE_PROFILE_ID | smallint | 2 | Foreign key into the MOBILE_PROFILES table. |
PRIORITY | tinyint | 1 | When utilizing Rate Schedules with more than one member it is possible that two Rate Schedule entries are active and valid at the same time. By assigning one entry a higher priority you can ensure that it will take precedence over an equally valid Rate Schedule with a lower priority. |
ENABLED | bit | 1 | Specifies whether or not this Rate Schedule is an active member of the list of Rate Schedule entries or should be temporarily removed from the Rate Schedule during call processing. 0 – Disabled 1 – Enabled |
RATE_PLAN_ID | int | 4 | Foreign key into the RATE_PLANS table that references the Rate Plan associated with this entry. |
OVERRIDE_GRACE_PERIOD | bit | 1 | Specifies whether or not the GRACE_PERIOD in this entry will be used instead of the one in the RATE_PLANS table. |
GRACE_PERIOD | smallint | 2 | Specifies the duration (in seconds) threshold under which the user will not be Charged. |
OVERRIDE_MIN_SECS_BILLED | bit | 1 | Specifies whether or not the MIN_SECS_BILLED in this entry will be used instead of the one in the RATE_PLANS table. |
MIN_SECS_BILLED | smallint | 2 | Specifies the minimum duration (in seconds) that a user will be billed for a call. |
OVERRIDE_SHORTEST_CALL_ALLOWED | bit | 1 | Specifies whether or not the SHORTEST_CALL_ALLOWED in this entry will be used instead of the one in the RATE_PLANS table. |
SHORTEST_CALL_ALLOWED | smallint | 2 | Specifies the amount of time (in seconds) that the caller must be able to afford, or the call will not be allowed. |
OVERRIDE_BILLING_DELAY | bit | 1 | Specifies whether or not the BILLING_DELAY in this entry will be used instead of the one in the RATE_PLANS table. |
BILLING_DELAY | smallint | 2 | Specifies the amount of time (in seconds) after, which the billing will be started. |
OVERRIDE_RATE_INTERVAL | bit | 1 | Determine whether the Rate Plan’s rate interval should be overridden. |
RATE_INTERVAL | tinyint | 1 | Rate interval to use for billing purposes (default: 60 seconds). |
OVERRIDE_SPEAK_RATE_INTERVAL | bit | 1 | Determine whether the Rate Plan’s speak rate interval setting should be overridden. |
SPEAK_RATE_INTERVAL | bit | 1 | Sets whether the rate interval is to be used when calculating the number of minutes available to speak to the caller. |
OVERRIDE_DISCONNECT_CHARGE | bit | 1 | Determine whether the Rate Plan’s disconnect charge setting should be overridden. |
DISCONNECT_CHARGE | decimal | (15,4) | The disconnect charge (amount or percentage) to bill the caller. |
DISCONNECT_CHARGE_TYPE | tinyint | 1 | Sets how the disconnect charge is applied (i.e. 0=Fixed amount, 1=Percentage (%)). |
OVERRIDE_DISCONNECT_CHARGE_END | bit | 1 | Determine whether the Rate Plan’s disconnect charge end should be overridden. |
DISCONNECT_CHARGE_CALL_END | bit | 1 | Sets whether the disconnect charge is applied at the end of the call. |
OVERRIDE_SPEAK_DISCONNECT_CHARGE | bit | 1 | Determine whether the Rate Plan’s speak disconnect charge setting should be overridden. |
SPEAK_DISCONNECT_CHARGE | bit | 1 | Sets whether the disconnect charge is used when calculating the number of minutes available to speak to the caller. |