xDR summary

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.

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.

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

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

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 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

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.

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.

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.

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).