Information for the Communication

Columns

• Id (datatype: int) Required Primary Key
• Subject (datatype: nvarchar(1000)) Required Primary Key
• FutureSendDateTime (datatype: datetime) Required Primary Key
• Status (datatype: int) Required Primary Key
• ReviewedDateTime (datatype: datetime) Required Primary Key
• ReviewerNote (datatype: nvarchar(max)) Required Primary Key
• AdditionalMergeFieldsJson (datatype: nvarchar(max)) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• IsBulkCommunication (datatype: bit) Required Primary Key
• SenderPersonAliasId (datatype: int) Required Primary Key
• ReviewerPersonAliasId (datatype: int) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• EnabledLavaCommands (datatype: nvarchar(max)) Required Primary Key
• Name (datatype: nvarchar(100)) Required Primary Key
• CommunicationType (datatype: int) Required Primary Key
• UrlReferrer (datatype: nvarchar(200)) Required Primary Key
• ListGroupId (datatype: int) Required Primary Key
• Segments (datatype: nvarchar(max)) Required Primary Key
• SegmentCriteria (datatype: int) Required Primary Key
• CommunicationTemplateId (datatype: int) Required Primary Key
• FromName (datatype: nvarchar(100)) Required Primary Key
• FromEmail (datatype: nvarchar(100)) Required Primary Key
• ReplyToEmail (datatype: nvarchar(100)) Required Primary Key
• CCEmails (datatype: nvarchar(max)) Required Primary Key
• BCCEmails (datatype: nvarchar(max)) Required Primary Key
• Message (datatype: nvarchar(max)) Required Primary Key
• MessageMetaData (datatype: nvarchar(max)) Required Primary Key
• SMSFromDefinedValueId (datatype: int) Required Primary Key
• SMSMessage (datatype: nvarchar(max)) Required Primary Key
• PushTitle (datatype: nvarchar(100)) Required Primary Key
• PushMessage (datatype: nvarchar(max)) Required Primary Key
• PushSound (datatype: nvarchar(100)) Required Primary Key
• SendDateTime (datatype: datetime) Required Primary Key
• ExcludeDuplicateRecipientAddress (datatype: bit) Required Primary Key
• SendDateKey (datatype: int) Required Primary Key
• PushImageBinaryFileId (datatype: int) Required Primary Key
• PushOpenAction (datatype: int) Required Primary Key
• PushOpenMessage (datatype: nvarchar(max)) Required Primary Key
• PushData (datatype: nvarchar(max)) Required Primary Key
• SystemCommunicationId (datatype: int) Required Primary Key
• SmsFromSystemPhoneNumberId (datatype: int) Required Primary Key