•  BeoWidgets
•  Milio CRM
•  VChK Data Cleaning
•  xCast Broadcasting
•  iTelco

iTelco Billing Schema

The billing schema describes general billing rules that will be understood throughout the development of the solution

Data collection & distribution

Data collection is executed through the LAN or by FTP. Other protocols for accessing CDR files need to be analyzed case by case and are not supported in this offer.

Files may be collected on regular time intervals that depend on the equipment that generates them and user requirements. The data collection module may be set to poll the source from once per minute to once per day.

Mediation

The present offer provides support for mediating Nortel GSPv06 files. Other file formats need to be analyzed case by case and are not included in the present offer.

Tasks supported by the mediation module:

• Formatting: Format GSPv06 files into ASCII files
• Filtering: Output only Call Detail Records. Other records will not be output to the destination file unless requested before order confirmation.

• Optional filter a: Output in separate files calls with a duration >0 and calls with a duration = 0.
• Optional filter b: Create a separate file per interconnect client.

• Validation: validation rules may include conditions based on information available in the record itself only. Validation rules do not access external sources of data.

All rules need to be expressed 3 weeks at least prior to implementation

File uploading

The file uploading process is a DTS service running on the database server. It may be programed to be performed on regular time intervals.

Prior to uploading, the service verifies whether that specific file was already loaded. After loading the file in the to "rate" table, the file is archived in a folder defined by the user.

Usage charges: Rating

The rating logic is delivered in the form of a stored procedure on the database server. Source code is available to the end user and may be changed at any time by the system administrator or per request by 4Cmj at an additional charge.

The rating process includes the following tasks:

Trunk name translation:

The trunk ID imposed by the switch would be translated into a more friendly name defined by the end user.

Account identification:

Accounts are identified by the originating trunk group of the call.

Destination identification:

Call destination is identified through the analysis of the dialed number. It is assumed that dialed numbers have the following format: XXX CC NSN¹. XXX has the same length on a given trunk group and can be stripped if properly setup by the user. The list of possible destinations is account specific.

Tariff selection

Each account may have a different tariff table.

Rate application

Two rating logics are supported:

• Per second: calls are rated on a per second bases - example: a call with a duration of 3 min 25 s is rated (3+25/60) x rate assuming that the rate is a minute rate.
• Per threshold: Minimal call charge of x seconds. Calls charged in y second intervals.

Important:

• The desired rating logic is defined at the level of an account address.
• Rating is calculated in the currency assigned to the tariff.

Item discount application:

A destination discount can be applied during the rating process. The discount can be defined for a specific period of time on selected account sites.

Other charges

Recurring charges:

Recurring charges can be set to be invoiced either monthly, quarterly, 2 quarterly or yearly. A label describes the charge.

One time charges:

One time charges are added to the next invoicing run. A label describes the nature of the charge.

Re-rating

The re-rating process is launched by the system administrator according to selection rules depending on the following parameters: Start date*, End Date*, In trunk, Out trunk, Account, Site, Destination.

Recycling

The recycling process is launched by the system administrator according to selection rules depending on the following parameters: Start Date^*, End Date*, ^,In Trunk, Out Trunk, Error code.

Discounts

Item discount

Call detail discounts to selected regions can be applied within a specified time period. This discount is applied during the rating process and is not dependent on volume.

Volume discount

Volume discounts per destination can defined for each account. The discount can be calculated according to two different methods:

• The discount is applied to all the calls once a volume threshold is reached

• The discount is applied only on calls above the volume threshold.

This discount is calculated during the invoicing run.

Growth discounts

Growth discounts are applied per destination in comparison to the volume to a specific destination in the previous invoicing run.

Credit notes

Credit notes can be provided as stand alone notes or as line items in the invoice. The label associated with the credit note can be selected from an existing list or added as free text by the end user.

Invoicing

Each invoicing address is associated to an invoicing template that is stored in the database. When launching the invoicing run, the appropriate template is used. The invoicing module supports scripting which gives great flexibility in terms of calculations and presentation.

Output filters are supplied to produce the invoice in pdf, rtf or HTML formats.