System information

Callenddate: first disconnect code or CANCEL/BYE received or sent
Connectdate: first 200 OK received or ACK for 200 OK sent
Connecttime: time elapsed until call fail or call pickup (routing+ringing time)
Workenddate: used for callcenters and represents the time when the operator have finished to work with the current client (CRM updates, etc)
Realduration: speech length
Discparty: disconnect origination. 1=called or gsm, 2=caller or h323, 3=router (server)
Discreason: disconnect reason code. Explanations in tb_reasoncodes
Callerid: caller database id from tb_users
Callerip: the origination ip
Callernumber: caller phone number (or sip username)
Calledid: called database id from tb_users
Simid: called simid (if any)
Calledline: Engine (phone line) or the called proxy authorization id (from tb_proxyauth)
Calledip: the ip address of the called party
OrigCalledNumber: received called party number (not modified)
Callednumber: techprefix and the normalized called number.
If the server will block the call too early, than you may have the “origcallednumber” here (no techprefix and normalization)
DialedNumber (calleddialed): the forwarded called number
(sometimes only the “callednumber” will be insterted here)
Rtpsent: rtp packets from caller to called. 0 if no rtp routing. At least 1 if routed. If remains 1, then routing has failed
In case of sip this means rtp packets received from the called and sent to caller successfully
Rtprec: rtp packets from called to caller. 0 if no rtp routing. At least 1 if routed. If remains 1, then routing has failed
In case of sip this means rtp packets received from the caller and sent to called successfully
Rtplost: lost rtp packets
Rtpcodec: voice codec name
Rtpname: used for gateways
Rtpframes: rtp payload framed in one udp packet
Signalin: audio signal strength into the playback device
Signalout: audio signal strength received from the audio recorder device
Jittertime: used when jitter time is reported by gateways or softphones
Tpercek: hungarian specific. deprecated
Costprovider: call cost to the provider (ex. Tmobile)
Costenduser: cost for the caller in global currency (ex: a sipuser or traffic sender)
Costenduseru: cost for the caller in user currency
Costsales: sales commission if any
Costcompany: price for the reseller company
Costadditional (costother): used for reseller prices (in the main cdr)
Recfileid: if we have recorded the voice, then after this field we can found the recorded file