EMSPOT

This table contains registered e-Marketing Spots.

Column Descriptions:

NameTypeDescription
EMSPOT_IDINTEGER NOT NULLPrimary key.
STOREENT_IDINTEGER NOT NULLStore to which this e-Marketing Spot belongs.
NAMEVARCHAR (256) NOT NULLName of the e-Marketing Spot.
DESCRIPTIONVARCHAR (254)Description of the e-Marketing Spot.
SUPPORTEDTYPESVARCHAR (20)The types of things that this e-Marketing Spot can display: A = Awareness ad P = Product C = Category S = Cross-sell or Up-sell on product. G = General content, which corresponds to a content spot. This value should only be used by the system.
LASTUPDATETIMESTAMPTimestamp of the last update to the e-Marketing Spot.
LASTUPDATEDBYVARCHAR (254)Logon ID of the last user to update the e-Marketing Spot.
DEFAULTRULEVARCHAR (4000)Reserved for HCL internal use.
USAGETYPEVARCHAR (20) NOT NULL DEFAULT 'MARKETING'Defines the usage type of EMSPOT. EMSPOT can be used to deliver marketing message or store contents. The following are the valid usage types: MARKETING - Delivers marketing message CONTENT - Delivers store content. LAYOUTMARKETINGSPOT - Displays Commerce Composer layouts. SEARCH - Used by search rules. STOREFEATURE - Used by store functions. STOREFILEREF - Used by store style selection.
UP_NAMEVARCHAR (256)The equivalent value of the NAME column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
UP_DESCRIPTIONVARCHAR (254)The equivalent value of the DESCRIPTION column in upper case characters. This column is used only for DB2 (LUW) database-types to enhance performance of text-based searches issued from Management Center.
UIDISPLAYABLESMALLINTIndicates if this element should be displayed in CMC. Null/1: means Yes. 0: means No.
MANAGINGTOOLSMALLINTIndicates what tools manages that element. Null/0: means Marketing tool. 1: means Page Layout.
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>EMSPOT_IDPrimary Key
I0000100NAME+STOREENT_ID+USAGETYPEUnique Index
I0000568STOREENT_IDNon-Unique Index
IPF00006UP_NAMENon-Unique Index
IPF00007UP_DESCRIPTIONNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_313STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1158EMSPOT_IDSHDCACRMESPOT_IDCascade
F_3534EMSPOT_IDDMEMSPOTPAGEEMSPOT_IDCascade
F_3536EMSPOT_IDDMEMSPOTCMDEMSPOT_IDCascade
F_3537EMSPOT_IDDMEMSPOTDEFEMSPOT_IDCascade
F_3740EMSPOT_IDDMEMSPOTCOLLDEFEMSPOT_IDCascade
F_387EMSPOT_IDINTVSCHEDEMSPOT_IDCascade