Email Publication DMO

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

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

• 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.

• 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

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

• 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.

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

• 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• 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.

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

• 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.

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

• 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.

• 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.

• 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.

• 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.

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

• 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.

• 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.