System information

Mark (marker): for special CDR records: EMAIL (e-mail), SMS (sms), FAX (fax calls),
FAIL (failowered), RER (rerouted), FWD (forwarded), TRANS (transferred),
CONF (conference), PRED (predictive) and to signal other important call types
Opworktime: used in callcenters to store the actual operator worktime
Opwaittime: used in callcenters to specify how much time the operator have been waiting for the current cal
Billingstep: loaded from price settings (endusercost packet)
Unitprice: loaded from price settings (endusercost packet)
Billingentry: loaded from price settings (endusercost packet)
Origduration: all original duration (because the “realduration” field can be modified on IVR 2 leg billings or when hidden charges are applied)
Resellerid: top reseller id in tb_cdrs. Actual reseller id in tb_cdrresellers.
Accessnumber: set when the call have been made trough a specified IVR access number
Origcallerid: used when the caller id have been modified during the call. For example the caller can be a “traffic sender” but after ANI or PIN authorization there is an
enduser inpersonalisation
Alegduration: used for 2 leg calls (first calleg with ivr)
Blegduration: used for 2 leg calls (second calleg from ivr after callforward)
Comment: with details about the call setup and disconnect. Can contain a shortened message exchange log.
Dirid: direction name after the called number prefix