I have been studying the CDR feature built into 3CX. After searching the forms and support blogs I still have some questions. After reading the following post - http://www.3cx.com/blog/docs/cdr-call-data-records/ it was clear how the process works. I am struggling to determine what each field represents. Some fields are obvious but others are not. Here are my guesses perhaps others can help fill in the blanks? idcallhistory3 - The ID number for this record. callid - The ID number for the call within the 3CX database somewhere? starttime - The Start time of the call answertime - When the call was picked up by ext (subtract 1 second to get the ring time) endtime - The time the call was ended from_no - Phone number that initiated the call (See CallerID) to_no - Phone number that was dialed (See DialedNumber) group_no - ???? line_no - ???? is_answ - Was the call answered is_fail - Did the call fail for some reason (i.e. Busy) is_compl - Call was completed successfully is_fromoutside - Did this call originate from outside of the office CallerID - ???? - The Caller ID of the first dialed number/ext DialedNumber - ???? - The Actual number/ext of the first dialed number lastCallerID - ???? - The Caller ID of the last dialed number/ext - perhaps this shows the last location in an IVR lastDialedNumber - ???? - The Actual number/ext of the last dialed number/ext - perhaps this shows the last location in IVR mediaType - The Codec used for this call Rate - Billing rate in currency - Defined in the Billing Info table within 3CX management console TotalCost - (endtime - answertime) * Rate BillPrefix - Country code as defined in the billing info table within 3CX management console BillRateName - Country Name as defined in the billing info table within 3CX management console GrpAnswDetail - ???? NumDetails - ???? In this section you can have one or more rows per call I am still not sure why a single call can have multiple detail records - i think this is used to track a callers progression from one extension to another - for example tracking their progress through an IVR DetailNum - ???? IdCallHistory2 - ID number of this record ParentDetailNum - ???? - Perhaps the ID number of the parent which is idcallhistory3 dest_dn - ???? dest_num - Destination Number StartTime - Time this leg of the call was started Dur - Duration of this leg of the call AnswerTime - Answer Time on this leg of the call Status - ???? Perhaps there are codes for this field or it is similar to the call reporter - Answered/Not Answered? Is_Compl - Was this leg of the call was completed - what defines completion - Transfer/hangup SpecDstType - ???? is_tooutside - ???? Show that this call was sent to an outside line? I know I am asking a lot here but I think it would be beneficial to the community if we had a post that clearly defined what each of these fields represent and how they might be used in our custom CDR implementations. I think it would also be useful if someone, who understands, would share an example where you may have more than one Detail record for a call.