SUBSCRTMPLITEMLIST

This table stores the details of a catalog entry, with quantity and price details for a given subscription template ID. This item will be shipped as part of the child order when the subscription is to be fulfilled.

Column Descriptions:

NameTypeDescription
SUBSCRTEMPLATE_IDBIGINT NOT NULLThe subscription template ID for which the items to be shipped are defined.
CATENTRY_IDBIGINT NOT NULLThe catalog entry ID that will be fulfilled or shipped as part of this subscription template.
CATENTQUANTITYINTEGER NOT NULLThe quantity of the catalog entry that will be fulfilled as part of this subscription template.
CATENTPRICEDECIMAL (20,5)The price of the catalog entry that is to appear in the child order during fulfillment of this subscription template. NULL indicates that the price will be recalculated at the time of order.
FIELD1INTEGERCustomizable
FIELD2DECIMAL (20,5)Customizable
FIELD3VARCHAR (254)Customizable
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>SUBSCRTEMPLATE_IDPrimary Key
I0001370CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3657SUBSCRTEMPLATE_IDSUBSCRTEMPLATESUBSCRTEMPLATE_IDCascade
F_3658CATENTRY_IDCATENTRYCATENTRY_IDCascade