Table of Contents

Table Cm_Party_Contact_Mechanisms

Entity

Entity: General.Contacts.PartyContactMechanisms

Specifies the contact mechanisms, which are attached to the parties. Currently each contact mechanism is attached to strictly one party. Entity: Cm_Party_Contact_Mechanisms

Owner Tables Hierarchy

Summary

Name Type Description
Contact_Mechanism_Id uniqueidentifier The contact mechanism of the party
Contact_Mechanism_Purpose_Id uniqueidentifier The purpose of this contact mechanism. Unique within the party. Can be used to seek for specific contact mechanisms.
From_Date datetime The first date when the contact mechanism was valid. NULL means unknown date
Id uniqueidentifier PK Unique party contact mechanism Id
Is_Active bit True if the contact mechanism is currently active and can be used to contact the party.
Is_Default bit 1 - when this is the default contact mechanism for this party; 0 - otherwise
Line_Ord int Consecutive number of the contact information. The number is unique within the party.
Non_Solicitation bit If 1 then Don't use the mechanism for solicitation purposes
Notes nvarchar(254)
Party_Id uniqueidentifier The party, having the contact mechanism
Personal_Data_Process_Id uniqueidentifier The personal data process, which is used to process the current data. Null when the data is not personal or when the process is unknown.
Row_Version timestamp
Thru_Date datetime The last date on which the contact mechanism was valid for the party. NULL if the contact mechanism is still valid

Columns

Contact_Mechanism_Id

The contact mechanism of the 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 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Cm_Contact_Mechanisms
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

Contact_Mechanism_Id - Supported Filters

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

Contact_Mechanism_Purpose_Id

The purpose of this contact mechanism. Unique within the party. Can be used to seek for specific contact mechanisms.

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

Contact_Mechanism_Purpose_Id - Supported Filters

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

From_Date

The first date when the contact mechanism was valid. NULL means unknown date

Property Value
Auto Complete no
Data Filter no
Default Value CurrentDate
Enter Stop no
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 (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

From_Date - Supported Filters

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

Id

Unique party contact mechanism 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

Id - Supported Filters

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

Is_Active

True if the contact mechanism is currently active and can be used to contact the party.

Property Value
Auto Complete no
Data Filter no
Default Value True
Enter Stop no
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 bit
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Is_Active - Supported Filters

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

Is_Default

1 - when this is the default contact mechanism for this party; 0 - otherwise

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop no
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 bit
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Is_Default - Supported Filters

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

Line_Ord

Consecutive number of the contact information. The number is unique within the party.

Property Value
Auto Complete no
Autoincrement 1
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 int
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Non_Solicitation

If 1 then Don't use the mechanism for solicitation purposes

Property Value
Auto Complete no
Data Filter no
Default Value False
Enter Stop no
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 bit
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Non_Solicitation - Supported Filters

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

Notes

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
Ignore for Insert Order no
Is Entity Name no
Max Length 254
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(254) (Allows NULL)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Party_Id

The party, having the contact mechanism

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference yes
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 100
User Login no
Visible yes

Party_Id - Supported Filters

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

Personal_Data_Process_Id

The personal data process, which is used to process the current data. Null when the data is not personal or when the process is unknown.

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

Personal_Data_Process_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

Thru_Date

The last date on which the contact mechanism was valid for the party. NULL if the contact mechanism is still valid

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop no
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 (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Thru_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes yes
GreaterThanOrLessThan None yes no
Suggest improvement to this page