DMEMSPOTORD

A list of ordering schemes in which to order marketing content displayed in an e-MarketingSpot.

Column Descriptions:

NameTypeDescription
DMEMSPOTORD_IDINTEGER NOT NULLThe unique identifier of the e-MarketingSpot ordering scheme.
CONTENTTYPEVARCHAR (254) NOT NULLThe type of content which can be ordered. Valid values include: CatalogGroup, CatalogEntry, MarketingContent.
ORDERINGNAMEVARCHAR (254) NOT NULLThe name of the ordering scheme.
INTERFACENAMEVARCHAR (254) NOT NULLThe command interface name.
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>DMEMSPOTORD_IDPrimary Key
I0001159CONTENTTYPE+ORDERINGNAMEUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3535DMEMSPOTORD_IDDMEMSPOTCMDDMEMSPOTORD_IDCascade