This table contains registered e-Marketing Spots.
Column Descriptions
| Column Name
| Column Type
| Description |
| EMSPOT_ID
| INTEGER NOT NULL
| Primary key.
|
| STOREENT_ID
| INTEGER NOT NULL
| Store to which this e-Marketing Spot belongs.
|
| NAME
| VARCHAR(64) NOT NULL
| Name of the e-Marketing Spot.
|
| DESCRIPTION
| VARCHAR(254)
| Description of the e-Marketing Spot.
|
| SUPPORTEDTYPES
| VARCHAR(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.
|
| LASTUPDATE
| TIMESTAMP
| Timestamp of the last update to the e-Marketing Spot.
|
| LASTUPDATEDBY
| VARCHAR(254)
| Logon ID of the last user to update the e-Marketing Spot.
|
| DEFAULTRULE
| VARCHAR(4000)
| Reserved for IBM internal use.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
| USAGETYPE
| VARCHAR(20) NOT NULL DEFAULT 'MARKETING'
| Defines the usagetype of EMSPOT. EMSPOT can be used to deliver marketing message or store contents. Following are the valid usagetype: MARKETING - Delivers marketing message CONTENT - Delivers store content.
|