[beaton]

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.