Telepo 3. SMDR/CDR data format and connection settings


This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not applicable for other software titles.

DescriptionData typeColumn name
Organization IDstringFLAG1
Customer IDstringFLAG2
Billing user IDstringEXT
Billing phone numberstringBILLING_NUMBER
Billing cost centrestringBILLING_COST_CENTRE
Billing departmentstringBILLING_DEPARTMENT
Billing rolestringBILLING_ROLE
Call timedatetimeCALL_TIME
Call typestringCALL_TYPE
DirectionstringDIRECTION
Call IDstringCALL_ID
Initial call IDstringINITIAL_CALL_ID
Call duration (s)integerCALL_DURATION_S
Call durationdatetimeCALL_DURATION
Ring duration (s)integerRING_S
RingdatetimeRING
Call resultstringFLAG3
Source user idstringCALLER_USER_ID
Source phone numberstringCALLER_PHONE
Source cost centrestringCALLER_COST_CENTRE
Source departmentstringCALLER_DEPARTMENT
Source rolestringCALLER_ROLE
Source answerplace typestringCALLER_APP
Traget user idstringTARGET_USER_ID
Target phone numberstringDIALED_PHONE
Target cost centrestringTARGET_COST_CENTRE
Target departmentstringTARGET_DEPARTMENT
Target rolestringTARGET_ROLE
Target answerplace typestringTARGET_APP
Transferred bystringTRANSFERRED_BY
Diverted bystringDIVERTED_BY
Diversion reasonstringDIVERSION_REASON
GatewaystringGATEWAY
TrunkstringTRUNK
Q850 cause codestringQ850_CAUSE_CODE
Cancel cause codestringCANCEL_CAUSE_CODE
Conference IDstringCONFERENCE_ID
SMS sizestringSMS_SIZE

Note: Products and companies mentioned here are used only for definition and identification purposes and can be trademarks and/or registered trademarks of the respective companies.