Table Cm_Party_Communications

Entity

Entity: General.Contacts.PartyCommunications

Party Communications. Entity: Cm_Party_Communications (Introduced in version 26.2.1.50)

Summary

Name	Type	Description
Channel	char(3) Allowed: EML, MSG, NOT	Channel
Communication_From	nvarchar(254)	From
Communication_To	nvarchar(254)	To
Conversation_Id	uniqueidentifier	Conversation
Data_Object_Id	uniqueidentifier	Data Object
Direction	char(1) Allowed: I, O	Direction
Message	nvarchar(max)	Message
Parent_Communication_Log_Id	uniqueidentifier	Parent Communication Log
Party_Communication_Id	uniqueidentifier PK	Party communication identifier
Party_Id	uniqueidentifier	Party
Row_Version	timestamp
Sub_Channel	char(3) Allowed: OUT, WHA, VBR, INT	Sub Channel
Subject	nvarchar(254)	Subject
Time_Last_Update	datetime	Time Last Update
Time_Occurred_At	datetime	Time Occurred At

Columns

Channel

Channel

Property	Value
Allowed Values	EML, MSG, NOT
Auto Complete	no
Data Filter	no
Default Value	EML
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	3
Order	5
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	char(3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Channel - Supported Filters

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

Communication_From

From

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	254
Order	10
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(254)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Communication_From - Supported Filters

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

Communication_To

To

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	254
Order	11
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(254)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Communication_To - Supported Filters

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

Conversation_Id

Conversation

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	13
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
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

Conversation_Id - Supported Filters

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

Data_Object_Id

Data Object

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	2
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Sys_Objects
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Data_Object_Id - Supported Filters

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

Direction

Direction

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

Direction - Supported Filters

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

Message

Message

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	2147483647
Order	4
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(max)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Message - Supported Filters

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

Parent_Communication_Log_Id

Parent Communication Log

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	12
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Cm_Party_Communications
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

Parent_Communication_Log_Id - Supported Filters

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

Party_Communication_Id

Party communication identifier

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	0
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

Party_Communication_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no
GreaterThanOrLessThan	None	no	yes

Party_Id

Party

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	1
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
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Party_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	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	14
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

Sub_Channel

Sub Channel

Property	Value
Allowed Values	OUT, WHA, VBR, INT
Auto Complete	no
Data Filter	no
Default Value	OUT
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	3
Order	6
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	char(3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Sub_Channel - Supported Filters

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

Subject

Subject

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	254
Order	3
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(254)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Subject - Supported Filters

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

Time_Last_Update

Time Last Update

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	9
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

Time_Last_Update - Supported Filters

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

Time_Occurred_At

Time Occurred At

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	8
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

Time_Occurred_At - Supported Filters

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