Inbound CDR CSV Explained
Field | Header | Sample Value | Description |
1 | Date/Time (UTC) | 2020-01-01 11:22:33 | Date and time of the call received in (UTC) |
2 | Source | 12345678901 | Calling party’s Caller ID (calling number) |
3 | DID | 44123456789 | Inbound Telephone number associated with the SIPTrunk on the Dialler |
4 | Destination | Destination URI (Uniform Resource Identifier) | |
5 | Duration (secs) | 321 | Duration of the connect call in seconds. For non-connected calls, 0 is shown |
6 | Disconnect Initiator | Origination/Destination | Side which initiated the disconnection |
7 | Disconnect Code | 487 | SIP Disconnect code |
8 | Disconnect Response | Request Terminated | SIP Disconnect code response |
9 | Toll-free Amount (USD) | 0.99 | Total amount charged for the toll-free service |
10 | Termination Amount (USD) | 0.66 | Total amount charged for the PSTN termination service |
11 | Metered Channels Amount (USD) | 0.33 | Total amount charged for metered capacity service |
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 - C as numbers and characters due to default 2 decimal places, this can be resolved by
Highlight Rows B - C
Right Click and select format cells
Select Numbers & select 0 decimal places
