cdr Table in the PBX Database

This topic describes details of cdr table stored in the database of Yeastar P-Series PBX System.

Field Descriptions
id System internal flag
datetime Date and time
timestamp System internal flag
uid System internal flag
clid System internal flag
src Caller's number
srcname Caller's name
srcaddr System internal flag
dst Callee's number
dstname Callee's name
dcontext System internal flag
channel System internal flag
dstchannel System internal flag
srctrunk Source trunk
dsttrunk Destination trunk
lastapp System internal flag
lastdata System internal flag
duration Total duration of the call (calculates from the beginning of the call)
ringduration Ringing duration of the call
talkduration Talk duration of the call (calculates after the call is answered)
disposition Call status:
  • NO ANSWER
  • FAILED
  • BUSY
  • ANSWERED
  • VOICEMAIL
  • CONGESTION
amaflags System internal flag
calltype Communication Type
  • Internal
  • Inbound
  • Outbound
  • Callback
accountcode Pin code
uniqueid System internal flag
didnumber DID number
dodnumber DOD number
recordfile Recording file name
recordpath Recordings path (with file name)
srcchanurl Caller's SIP URI
dstchanurl Callee's SIP URI
reasonpartya System internal flag
reasonpartyb System internal flag
reasonpartyc System internal flag
reasonpartyd System internal flag
reasonpartye System internal flag
reasonpartyf System internal flag
displayonweb System internal flag
src_del_cdr System internal flag
dst_del_cdr System internal flag
src_del_recording System internal flag
dst_del_recording System internal flag
srcnameprefix System internal flag
dstnameprefix System internal flag
misscall_isread System internal flag
in2outbound System internal flag
concurrentcalls System internal flag
videocall System internal flag
rascall System internal flag
tryvideocall System internal flag