Asterisk CDR Fields

Asterisk generates a CDR (Call Detail Record) for each call. By default, records are stored in comma-separated value file will be created in /var/log/asterisk/cdr-csv. You can specify account codes and AMA (Automated Message Accounting) flags on a per-channel (Zaptel et al) or per-user (IAX, SIP) basis to help with accounting. Look at the top of cdr/cdr_csv.c to see the format for the records.

Fields

1. accountcode: What account number to use: account, (string, 20 characters)
2. src: Caller*ID number (string, 80 characters)
3. dst: Destination extension (string, 80 characters)
4. dcontext: Destination context (string, 80 characters)
5. clid: Caller*ID with text (80 characters)
6. channel: Channel used (80 characters)
7. dstchannel: Destination channel if appropriate (80 characters)
8. lastapp: Last application if appropriate (80 characters)
9. lastdata: Last application data (arguments) (80 characters)
10. start: Start of call (date/time)
11. answer: Anwer of call (date/time)
12. end: End of call (date/time)
13. duration: Total time in system, in seconds (integer), from dial to hangup
14. billsec: Total time call is up, in seconds (integer), from answer to hangup
15. disposition: What happened to the call: ANSWERED, NO ANSWER, BUSY, FAILED (on some CDR backends, e.g. ODBC, these may be integers; note that more detailed info can be found in the dialplan variable $HANGUPCAUSE)
16. amaflags: What flags to use: see amaflags: DOCUMENTATION, BILLING, IGNORE etc, specified on a per channel basis like accountcode.
17. user field: A user-defined field, maximum 255 characters

In some cases, uniqueid is appended:

• uniqueid: Unique Channel Identifier (32 characters)

Asterisk CDR Storage Methods

• Asterisk cdr csv - Text files with comma separated values
• Asterisk cdr SQLite - CDR records to SQLite database
• Asterisk cdr pgsql - CDR records to PostgreSQL databases
• Asterisk cdr odbc - CDR records to any database that unixODBC supports
• Asterisk cdr mysql - CDR records to MySQL databases
• Asterisk cdr FreeTDS - CDR Records to MS SQL or Sybase database through FreeTDS drivers
• Asterisk cdr yada - CDR records to any database that yada supports
• Asterisk cdr manager - CDR Records to manager API
• cdr_shell - 3rd party solution that executes a script with the cdr data in its argv[] 0-18
• Asterisk cmd DBQuery - CDR Backend to store cdr data into a MySQL database by the use of a customizeable Query.

Account codes and flags are set in the various channel configuration files or in the extension definition in extensions.conf.

Applications

• Asterisk cmd SetAccount: Set account code for billing
• Asterisk cmd SetAMAFlags: Set AMAflags for this call
• Asterisk cmd NoCDR: Make sure no CDR is saved for a specific call
• Asterisk cmd ResetCDR: Reset CDR
• Asterisk cmd Authenticate - Authenticates and sets the account code
• Asterisk cmd SetCDRUserField - Set CDR user field
• Asterisk cmd AppendCDRUserField - Append data to CDR User field

Limitations

• A CDR record will not be created if you use a .call file that calls an application instead of an extension. Workaround: Use an extension that then starts the desired application. See also: Bug report 240
• You can't use exten => h, if you have any hope of getting accurate billing info. Its wise to call ResetCDR(w) in your exten => h, or not use it at all.

Least cost routing (LCR)

Especially for EU countries and small offices/home offices: Since the introduction of Call-By-Call (and Carrier Pre-selection) things have become both a lot cheaper and more complicated. The VoIP providers that offer IP-to-phone services add to the complexity of finding the cheapest route for a call. Finally there's the emerging ENUM system.
Implementing LCR functionality in Asterisk can be accomplished without too much effort using AGI and a mySQL backend

• Application LCDial Asterisk third-party add-on. Adds LCDial() command, which is just like Dial() but looks up the dialed number in a database, to find a dial-string for that destination.
• LCR tool for i4l: Collection of LCR a variety of LCR tools for Asterisk, i4l etc
• cnum.info realtime Call-by-Call rates for the german market provided as ENUM service
• ZIDial Adds ZIDial() command.Low cost routing with multiple redial (on each route), also multiple redial for multiple provider.

Pre-paid applications

If you have users that you have little or no contact with, or where fraudulent usage can be an issue, it might be worth looking at Pre-paid solutions. With the pre-paid model we need to access a users funds before the call is made in order to see how much cash is available for the call to be made. Next, once the call destination is known, we should start a timer to disconnect the call (or more userfriendly, interrupt the call with an announcement) and finally close the deal.

Some considerations when creating a calling card application:

• take care of multiple calls using the same credentials (PIN or username)
• the SIP protocol does not allow for recognition of a client that was disconnected
• cut off the call when the credit has dropped to 0
• the hard part is to correctly rate a call, e.g. attaching the correct tariff

See: Asterisk Prepaid Applications

Post-paid (billing)

The Call Detail Record
Asterisk generates CDR (Call Detail Records) that contain data about which extension made or received calls to or from which number for how long. These records are generally stored in plaintext logfiles located in /var/log/asterisk/cdr-csv, but can also be stored in PostgreSQL or (with the asterisk-addon package) MySQL databases.

Rating the CDR
Since Asterisk does not know about its location or the deals the machine has with Telco providers (your PSTN line or perhaps a VoipJet, NuFone, VoicePulse or IConnectHere account), so it cannot know the cost of each call. To solve this problem the CDR's need to be 'rated'. On each combination of parameters you could technically assign a buyers price and a sellers price. This process is generally called 'rating'.

Billing the users
Only when we have neatly rated CDR's the billing process can start, but this is now a reasonably simple process of accounting all prices linked to an account code or source or destination.

Software out there
There are probably some very decent commercial rating/billing packages out there, but only very few open source ones. Most notably there is Trabas Billing, however the Trabas company seems to be taking further development on the software back from the community.

PayPal - IPN - Subscription VoIP Billing Solutions

• Free PayPal - IPN and PayPal - IPN Subscription Starter Kit Software
• VanAbel.Com -- Free PayPal - IPN Starter Kit
• VanAbel.Com -- Free PayPal - IPN Subscription Starter Kit
• These applications, while not originally written for VoIP back in 2000-2001, can provide excellent insight into using PayPal for small to medium size VoIP businesses.
• Sorry, we can not offer support for free applications.

Important note on transfers

If you are trying to collect records on IAX to IAX calls you need to be aware that by default, IAX will attempt to transfer calls in this situation (if DTMF is not required). When the transfer is completed the call is dumped from the middle machine and thus the call detail records will report a short call time. If you want detailed records you must turn off IAX transfer, but unless your servers are very close together, you will definitely get a latency hit from doing so.

Asterisk Billing Resources

• INOVAWARE CORPORATION VOIP-Pro http://www.inovaware.com/voip/voip.htm Scalable, robust, full-featured, low-cost billing, rating, provisioning, customer care and help desk software solutions for VoIP carriers of all sizes. VOIP-Pro is pre-integrated with Asterisk platforms.
• Asterisk Billing Software

AAAVEER (BILLCALL)

• http://www.billcall.com/

complete billing solution for carrier grade telcos and teir1 and teri2 carriers with resource planning contact today

Phone: +61-290-372-182(Australia),+254-725-202-503(Africa),+91 9825500318(India), +1-818-804-2994 (USA).

Email: mahavirds@panamaxil.com

---

AstPP:

• http://www.astpp.org/

CenIP SoftSwitch:

• http://www.cenip.com.ar/

Cybex Development VoIP Billing System

• http://www.cybexdev.com

Omniware Billing System

• http://www.omniware.ca

Datatex Dynamics

• http://www.datatex.co.za

Datatex has been developing software solutions for the telephony industry since 1999.

Super Technologies - VOIP Billing Solutions

• http://www.supertec.com/solutions

See also

• VOIP Billing
• Open Source Billing Systems
• Asterisk Prepaid Applications
• CDR mediation
• Asterisk addon rate-engine: An alternative billing solution from Trollphone
• Commercial: http://www.vidanetwork.net - Asterisk turnkey solution for service providers, like Vonage.
• Asterisk CDR Areski GUI - PHP GUI for MySQL/PgSQL CDRs
• Asterisk CDR Jon - Perl GUI for CSV CDRs
• Simple Perl script for a basic calling card application
• Asterisk callingcard application by Bartosz Jozwiak (C, designed for PostgreSQL)
• Asterisk CDR csv conversion mysql
• Asterisk CDR csv mysql import
• Asterisk CDR csv handling
• AstBill - Billing, Routing and Management software for Asterisk and MySQL.
• ASTPP - Open Source VOIP Billing for Asterisk
• AsterBill - Asterisk Billing
• Aeolos Call Accounting A CDR reporting and billing tool supporting the Asterisk PBX. Targeted at SOHO and SME Asterisk setups
• CDRtool: Tool to access CDR records generated by SER, Cisco or Asterisk (RADIUS protocol) - by Adrian Georgescu, free for non-commercial use
• Asterisk administration
• Call Accounting Software
• Hotel/Call Shop Billing system - IPSwitchBoard
• Asterisk Billing Software - Alepo
• AgileVoice VoIP Billing and Provisioning - The ultimate "agile" Asterisk billing and provisioning application for VoIP providers, as it will expand to fit your needs - no matter how small your business is or how large it becomes. For Broadband phone providers, PC to Phone providers, Wholesale providers, IP Centrex, Calling Cards.
• Algorithm to parse country code out a phone number
• Asterisk VOIP AAA Software Aradial - Aradial

---

• Asterisk: config files | channels | variables | FAQ | CLI | introduction | tips & tricks