PX_TEMPLATE

Reserved for HCL internal use.

Column Descriptions:

NameTypeDescription
PX_TEMPLATE_IDINTEGER NOT NULLThis value identifies an invocation template in terms of participating promotion groups. This is a primary key.
STOREENT_IDINTEGER NOT NULLForeign key to the STOREENT table. This identifies the store to which this promotion invocation template belongs. Invocation templates are scoped by store.
NAMEVARCHAR (64) NOT NULLThe name of the invocation template. The STOREENT_ID, plus the name, is a unique index.
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>PX_TEMPLATE_IDPrimary Key
I0000420STOREENT_ID+NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1081STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1082PX_TEMPLATE_IDPX_TPLTGRPPX_TEMPLATE_IDCascade