Outbound CDR CSV Explained
- Scott D Child
Field | Header | Sample Value | Description |
1 | Time Start (UTC) | 2020-01-01 11:22:33 | Date and time of the call made in (UTC) |
2 | Source | 12345678901 | Telephone number associated with the SIPTrunk on the Dialler |
3 | CLI | 44123456789 | CLI associated with the Campaign on the Dialler |
4 | Destination | 44123456789 | Telephone number dialed from the Dialler to the Telephone Network |
5 | Duration (secs) | 321 | Duration of the connect call in seconds. For non-connected calls, 0 is shown |
6 | Disconnect Code | 200 | The outcome of the call i.e. 200 is connected call and completed by either party finishing the call (BYE) or 487 where a call has failed to connect as it has been rejected by the dialler (Request terminated (Cancel) |
7 | Disconnect Reason | Bye | As Above - friendly reason to accompany code i.e.Bye (200) |
8 | Rate ($USD per minute) | 0.012 | Rate per minute for the call placed |
9 | Charged (USD) | 0.0642 | Billable amount for the call placed |
10 | CDR Type* | Local | Call type: International/Local/Origin based International – A call originating from one country and destination is another i.e. United Kingdom to the United States of America will be treated as an international call Local – A call originating from one country and destination is the same i.e. United Kingdom to the United Kingdom will be treated as an Local call Origin based – A call originating from within the European Economic Area (excluding United Kingdom) and destination is the same i.e. France to France may have lower pricing. |
11 | Country Name | United Kingdom | Called destination country name. Badly formatted Telephone numbers will often be shown as a country not dialled. Our equipment will attempt to place a call based on the number provided |
12 | Network Name | United Kingdom T-Mobile | As above but categorised to a local carrier i.e. T-Mobile in the United Kingdom |
13 | Trunk Name | INVADE TESTING | Name given to the SIP Trunk on the INVADE Provisioning Portal & Billing Platform for identification and billing purposes. |
Due to the row limitation of Microsoft Excel (and other similar software) CDR’s reports are split by 1 million rows and you will see multiple CDR URL's in the invoice.
It has been also noted that Microsoft Excel may show columns B - D as numbers and characters due to default 2 decimal places, this can be resolved by
Highlight Rows B - D
Right Click and select format cells
Select Numbers & select 0 decimal places
