Release

Search

An administrator can browse summary information for all xDRs for a selected date and time range. You can browse the xDR summary for customers, accounts, vendors, resellers and distributors. The xDR summary includes the following information:

  • Total number of xDRs filtered;
  • Totals by services;
  • Total sum of payments and credits;
  • Total sum of taxes.

xDR summary

An administrator can download the xDRs for a specific period for further analysis, statistics purposes, etc. The output file is in the .csv format.

The data in the xDR file differs depending on the type of entity (e.g., customer, vendor) and the selected service. An administrator can select a specific service (e.g., voice call) or download xDRs for all available services including subscriptions, payments, taxes, DID usage, etc.

Customer xDRs

Link copied to clipboard

This is an example of the output file with the customer xDRs for voice calls service:

The output file with the customer xDRs

The following data is available:

  • Account ID
  • From (CLI or ANI)
  • To (CLD or DNIS)
  • Country
  • Description
  • Last hunting group
  • Last extension
  • Connect time
  • Disconnect time
  • Charged time (in hours:minutes:seconds)
  • Amount (USD)
  • Status
The call duration shown in the file is based on the charged duration of the call, not the actual call duration. So if, for instance, you bill by 6-second intervals, the total call duration will be higher than the actual duration of the calls.

Vendor xDRs

Link copied to clipboard

It is very useful to have a detailed list of xDRs for a specific vendor in case of disputes over the amount of terminated traffic.

This is an example of the output file with vendor xDRs for voice calls service:

The output file with the vendor xDRs

The following data is available:

  • Account ID
  • From (CLI or ANI)
  • To (CLD or DNIS)
  • Country
  • Description
  • Connect time
  • Disconnect time
  • Disconnect reason
  • Charged time (in hours:minutes:seconds)
  • Amount (USD)
  • Status

xDR cleanup procedure

Link copied to clipboard

xDRs are stored in the Main database and replicated to the Replica database. In order to prevent system overgrowth, xDRs are periodically cleaned up. This means that a special “Cleanup” xDR exists which accumulates charged amounts and times from all xDRs that are cleaned up for each account/customer/vendor. This xDR shows up as a “Cleaned up transaction” on the xDR history page of the web interface.

By default, the Cleanup procedure occurs during each off-peak period (every night) for all xDRs that are more than 2 months old, though these options are configurable to meet special requirements via the Configurator.

Configurator options

Although all the statistics/invoices are calculated up to the moment of the specified xDRs’ Cleanup, you can increase the period for keeping old xDRs according to your needs.

Setting longer storage period for payment xDRs

Link copied to clipboard

You can set a separate storage period for payment xDRs (for e-commerce, manual, and automatic credit card payments, as well as refunds). For instance, payment xDRs can be stored for 12 months, while other transactions, such as voice call charges, are cleaned up after 2 months.

Configuration
Link copied to clipboard

To set a longer storage period for payment xDRs, perform the following steps on the Configuration server web interface:

  1. Set the EnablePaymentXDRsProlongedStorage option to Yes.
  2. Specify the number of months for storing the payment xDRs in the KeepPaymentXDRs option.
    The value of the KeepPaymentXDRs option must be greater than the Keep_month value (for other xDRs).

     

    Setting longer storage period for payment data

On this page

Release
What's new
Admin manuals
Handbooks
API
UI help
Search