EMLPROMO

This table stores e-mail activities. Each row corresponds to an e-mail activity which is sent to a given customer profile.

Column Descriptions:

NameTypeDescription
EMLPROMO_IDINTEGER NOT NULLThe primary key.
STATUSINTEGER NOT NULL DEFAULT 0Represents the current state of the e-mail activity. Possible values include: 0 - unsent 1 - sent 2 - deleted
MODIFIEDBYVARCHAR (254)The logon ID of the person who last modified the e-mail activity.
MODDATETIMESTAMPThe date on which the last modification was performed.
DESCRIPTIONVARCHAR (254)The description of the e-mail activity.
NAMEVARCHAR (254) NOT NULLThe name given to the e-mail activity.
EMLMSG_IDINTEGER NOT NULLThe e-mail message template to send to the target customer segment.
STOREENT_IDINTEGER NOT NULLThe ID of the store with which the e-mail activity is associated.
SCCJOBREFNUMBIGINT NOT NULLForeign key to SCHCONFIG table.
REPLYTOVARCHAR (256)The reply-to e-mail address for the e-mail activity.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EMLPROMO_IDPrimary Key
I0000339STOREENT_IDNon-Unique Index
I0000564EMLMSG_IDNon-Unique Index
I0000565SCCJOBREFNUMNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_957EMLMSG_IDEMLMSGEMLMSG_IDCascade
F_958STOREENT_IDSTOREENTSTOREENT_IDCascade
F_959SCCJOBREFNUMSCHCONFIGSCCJOBREFNUMCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1034EMLPROMO_IDEMLBOUNCEDEMLPROMO_IDCascade
F_1040EMLPROMO_IDEMLCAMPRELEMLPROMO_IDCascade
F_960EMLPROMO_IDEMLRCPTSEMLPROMO_IDCascade
F_962EMLPROMO_IDEMLRPTEVTSEMLPROMO_IDCascade
F_963EMLPROMO_IDEMLGRPRELEMLPROMO_IDCascade