Table Cm_Call_Details

Entity

Entity: Applications.Telephony.CallDetails

Contains call detail records. Calls are phone calls, video calls and SMS messages. Entity: Cm_Call_Details

Summary

Name	Type	Description
Call_Detail_Record_Id	`uniqueidentifier` `PK`
Call_Type	`nvarchar(1)` Allowed: `P`, `V`, `M`	P=Phone; V=Video; M=Message/SMS
Call_Unique_Id	`nvarchar(32)`	The unique id of the call, as reported by the telephone central. NULL when the central did not report unique Id. Used for integration purposes
Called_Party_Id	`uniqueidentifier`	The party, which received the call. NULL when the party was not determined successfully
Called_Party_Number	`nvarchar(80)`	The voice number of the party, which received the call
Calling_Party_Id	`uniqueidentifier`	The party, which originated the call. NULL when the party was not determined successfully
Calling_Party_Number	`nvarchar(80)`	The voice number of the originating party of the call
Duration_Seconds	`int`	The duration of the call (in seconds)
External_Company_Id	`uniqueidentifier`	The company of the external party. It can be the party itself, or the parent party, whichever is company. NULL when the company cannot be determined
External_Party_Id	`uniqueidentifier`	It is either the From or the To party - depending of the direction of the call. Only calls with at least one external party participating are usually logged. NULL when the respective party was null, or when no external party participated in the call
Row_Version	`timestamp`
Start_Time	`datetime`	The starting date and time of the call

Columns

Call_Detail_Record_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Call_Detail_Record_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	yes

Call_Type

P=Phone; V=Video; M=Message/SMS

Property	Value
Allowed Values	`P`, `V`, `M`
Auto Complete	no
Data Filter	no
Default Value	P
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Call_Type - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Call_Unique_Id

The unique id of the call, as reported by the telephone central. NULL when the central did not report unique Id. Used for integration purposes

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	32
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(32) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Called_Party_Id

The party, which received the call. NULL when the party was not determined successfully

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Parties
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Called_Party_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Called_Party_Number

The voice number of the party, which received the call

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	80
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(80)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Called_Party_Number - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
Like	None	no	no

Calling_Party_Id

The party, which originated the call. NULL when the party was not determined successfully

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Parties
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Calling_Party_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Calling_Party_Number

The voice number of the originating party of the call

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	80
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(80)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Calling_Party_Number - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
Like	None	no	no

Duration_Seconds

The duration of the call (in seconds)

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	int
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Duration_Seconds - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	no	no

External_Company_Id

The company of the external party. It can be the party itself, or the parent party, whichever is company. NULL when the company cannot be determined

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Cm_Companies
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

External_Company_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

External_Party_Id

It is either the From or the To party - depending of the direction of the call. Only calls with at least one external party participating are usually logged. NULL when the respective party was null, or when no external party participated in the call

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Parties
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

External_Party_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Start_Time

The starting date and time of the call

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Start_Time - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	no	no

Table of Contents