Email Publication DMO

A process that sends email messages to a set of recipients.

Object Properties

Object API Name: ssot__EmailPublication__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

Relationships

• EngagementChannelTypeId has a FOREIGNKEY relationship with the Engagement Channel Type DMO Id field.
• EnagementAssetId has a FOREIGNKEY relationship with the SMS Template DMO Id field.
• EnagementAssetId has a FOREIGNKEY relationship with the Email Template DMO Id field.
• EnagementAssetId has a FOREIGNKEY relationship with the Device Application Template DMO Id field.
• ParentEngagementPublicationId has a FOREIGNKEY relationship with the SMS Publication DMO Id field.
• ParentEngagementPublicationId has a FOREIGNKEY relationship with the Email Publication DMO Id field.

Fields

• BodyTxt
• cdp_sys_record_currency
• ClickThroughPct
• ClickToOpenPct
• CreatedDate
• DataSourceId
• DataSourceObjectId
• DeliveryPct
• Description
• DurationSecondsQty
• EnagementAssetContentId
• EnagementAssetId
• EnagementPublicationTypeId
• EngagementChannelTypeId
• EngagementPublicationNbr
• EngagementPublicationStatusId
• EngagementTopicGroupId
• ErrorMessageTxt
• ExternalRecordId
• ExternalSourceId
• FailedRecordCt
• FromAddr
• FromName
• HasAttachment
• HTMLBodyTxt
• Id
• InternalOrganizationId
• IsTracked
• KQ_EnagementAssetId
• KQ_EngagementChannelTypeId
• KQ_Id
• KQ_ParentEngagementPublicationId
• LastModifiedDate
• Name
• OpenPct
• OptOutPct
• ParentEngagementPublicationId
• PublicationAttemptsNbr
• PublicationStatusDt
• ReplyToAddr
• ScheduledDt
• SendClassificationId
• SendMechanismName
• SuccessfulRecordCt
• TotalDeliveredQty
• TotalHardBounceQty
• TotalOpensQty
• TotalPublicationItemsCt
• TotalSentQty
• TotalSoftBounceQty
• TotalSpamComplaintsQty
• TotalTrackedLinkClicksQty
• UniqueClickThroughPct
• UniqueOpensQty
• UniqueOptOutsQty
• UniqueTrackedLinkClicksQty

BodyTxt

• Field API Name: ssot__BodyTxt__c
• Data Type: TEXT
• Description: Alphanumeric string representing the body txt.

cdp_sys_record_currency

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

ClickThroughPct

• Field API Name: ssot__ClickThroughPct__c
• Data Type: DOUBLE
• Description: Numeric value representing the click through pct. Do not include currency symbols or commas.

ClickToOpenPct

• Field API Name: ssot__ClickToOpenPct__c
• Data Type: DOUBLE
• Description: Numeric value representing the click to open pct. Do not include currency symbols or commas.

CreatedDate

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

DataSourceId

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DataSourceObjectId

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DeliveryPct

• Field API Name: ssot__DeliveryPct__c
• Data Type: DOUBLE
• Description: Numeric value representing the delivery pct. Do not include currency symbols or commas.

Description

• Field API Name: ssot__Description__c
• Data Type: TEXT
• Description: Description of this record.

DurationSecondsQty

• Field API Name: ssot__DurationSecondsQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the duration seconds qty. Do not include currency symbols or commas.

EnagementAssetContentId

• Field API Name: ssot__EnagementAssetContentId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

EnagementAssetId

• Field API Name: ssot__EnagementAssetId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

EnagementPublicationTypeId

• Field API Name: ssot__EnagementPublicationTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

EngagementChannelTypeId

• Field API Name: ssot__EngagementChannelTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

EngagementPublicationNbr

• Field API Name: ssot__EngagementPublicationNbr__c
• Data Type: TEXT
• Description: Alphanumeric string representing the engagement publication nbr.

EngagementPublicationStatusId

• Field API Name: ssot__EngagementPublicationStatusId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

EngagementTopicGroupId

• Field API Name: ssot__EngagementTopicGroupId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ErrorMessageTxt

• Field API Name: ssot__ErrorMessageTxt__c
• Data Type: TEXT
• Description: Alphanumeric string representing the error message txt.

ExternalRecordId

• Field API Name: ssot__ExternalRecordId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

ExternalSourceId

• Field API Name: ssot__ExternalSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

FailedRecordCt

• Field API Name: ssot__FailedRecordCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the failed record ct. Do not include currency symbols or commas.

FromAddr

• Field API Name: ssot__FromAddr__c
• Data Type: TEXT
• Description: Alphanumeric string representing the from addr.

FromName

• Field API Name: ssot__FromName__c
• Data Type: TEXT
• Description: Alphanumeric string representing the from name.

HasAttachment

• Field API Name: ssot__HasAttachment__c
• Data Type: TEXT
• Description: Alphanumeric string representing the has attachment.

HTMLBodyTxt

• Field API Name: ssot__HTMLBodyTxt__c
• Data Type: TEXT
• Description: Alphanumeric string representing the htmlbody txt.

Id

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

InternalOrganizationId

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

IsTracked

• Field API Name: ssot__IsTracked__c
• Data Type: TEXT
• Description: Alphanumeric string representing the is tracked.

KQ_EnagementAssetId

• Field API Name: KQ_EnagementAssetId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EnagementAssetId

KQ_EngagementChannelTypeId

• Field API Name: KQ_EngagementChannelTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for EngagementChannelTypeId

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_ParentEngagementPublicationId

• Field API Name: KQ_ParentEngagementPublicationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ParentEngagementPublicationId

LastModifiedDate

• Field API Name: ssot__LastModifiedDate__c
• Data Type: DATETIME
• Description: The date and time of the last modification to this record.

Name

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: The primary name or label for this record.

OpenPct

• Field API Name: ssot__OpenPct__c
• Data Type: DOUBLE
• Description: Numeric value representing the open pct. Do not include currency symbols or commas.

OptOutPct

• Field API Name: ssot__OptOutPct__c
• Data Type: DOUBLE
• Description: Numeric value representing the opt out pct. Do not include currency symbols or commas.

ParentEngagementPublicationId

• Field API Name: ssot__ParentEngagementPublicationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

PublicationAttemptsNbr

• Field API Name: ssot__PublicationAttemptsNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the publication attempts nbr. Do not include currency symbols or commas.

PublicationStatusDt

• Field API Name: ssot__PublicationStatusDt__c
• Data Type: DATETIME
• Description: The date and time of the publication status dt.

ReplyToAddr

• Field API Name: ssot__ReplyToAddr__c
• Data Type: TEXT
• Description: Alphanumeric string representing the reply to addr.

ScheduledDt

• Field API Name: ssot__ScheduledDt__c
• Data Type: DATETIME
• Description: The date and time of the scheduled dt.

SendClassificationId

• Field API Name: ssot__SendClassificationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

SendMechanismName

• Field API Name: ssot__SendMechanismName__c
• Data Type: TEXT
• Description: Alphanumeric string representing the send mechanism name.

SuccessfulRecordCt

• Field API Name: ssot__SuccessfulRecordCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the successful record ct. Do not include currency symbols or commas.

TotalDeliveredQty

• Field API Name: ssot__TotalDeliveredQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the total delivered qty. Do not include currency symbols or commas.

TotalHardBounceQty

• Field API Name: ssot__TotalHardBounceQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the total hard bounce qty. Do not include currency symbols or commas.

TotalOpensQty

• Field API Name: ssot__TotalOpensQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the total opens qty. Do not include currency symbols or commas.

TotalPublicationItemsCt

• Field API Name: ssot__TotalPublicationItemsCt__c
• Data Type: DOUBLE
• Description: Numeric value representing the total publication items ct. Do not include currency symbols or commas.

TotalSentQty

• Field API Name: ssot__TotalSentQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the total sent qty. Do not include currency symbols or commas.

TotalSoftBounceQty

• Field API Name: ssot__TotalSoftBounceQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the total soft bounce qty. Do not include currency symbols or commas.

TotalSpamComplaintsQty

• Field API Name: ssot__TotalSpamComplaintsQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the total spam complaints qty. Do not include currency symbols or commas.

TotalTrackedLinkClicksQty

• Field API Name: ssot__TotalTrackedLinkClicksQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the total tracked link clicks qty. Do not include currency symbols or commas.

UniqueClickThroughPct

• Field API Name: ssot__UniqueClickThroughPct__c
• Data Type: DOUBLE
• Description: Numeric value representing the unique click through pct. Do not include currency symbols or commas.

UniqueOpensQty

• Field API Name: ssot__UniqueOpensQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the unique opens qty. Do not include currency symbols or commas.

UniqueOptOutsQty

• Field API Name: ssot__UniqueOptOutsQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the unique opt outs qty. Do not include currency symbols or commas.

UniqueTrackedLinkClicksQty

• Field API Name: ssot__UniqueTrackedLinkClicksQty__c
• Data Type: DOUBLE
• Description: Numeric value representing the unique tracked link clicks qty. Do not include currency symbols or commas.