Columns Type Name |
Format a) |
Content |
Journal_In_Out |
Text [1] |
i=incoming, o=outgoing |
Journal_TimePoint |
Text [20] |
JJJJ-MM-TT HH:MM:SS |
Journal_TimePointNumeric |
Date/Time |
Time as a numerical value |
Journal_ConnState |
Text[4] |
Connecting state as text CONN = connected RING = Ring (incoming/outgoing) BUSY = occupied |
Journal_PhoneNumber |
Text[30] |
phone number |
Journal_Name |
Text[100] |
Name to the phone number b) |
Journal_Company |
Text[100] |
Company name to the phone number b) |
Journal_LocalPhoneNumber |
Text[30] |
own phone number (MSN) |
Journal_Redirected |
Text[30] |
The phone number about which a phone call was redirected |
Journal_RecordID |
Text[50] or Number (Long Int) |
ID of the record to the phone number b) |
Journal_RecordTable |
Text[30] |
Name of the table in which the record was found. b) |
Journal_RingTime_ms |
Number (Long Int) |
Ring duration in milliseconds |
Journal_ConnTime_sec |
Number (Long Int) |
Connecting duration in seconds |
Journal_LCR |
Text[10] |
LCR prefix (if used) |
Journal_Charge |
Number (Long Int) |
Charges in cent (only in combination with LCR) |
Journal_PSTN |
Text[4] |
The used outside line access code |
a) You can adapt the size of the single text fields if necessary, e.g. if the company name needs less then 100 characters.
b) These values are only available if a record was found to the phone number. The search for the phone number is the job of the xtelsio CTI Client.