PRELETEMPLATE

Each row of this table represents a price rule element template. Elements which share the same template use the same element command but different parameters for price rule evaluation at runtime. For example, customer segment condition is an element template.

Column Descriptions:

Name	Type	Description
PRELETEMPLATE_ID	BIGINT NOT NULL	Generated Key
IDENTIFIER	VARCHAR (64) NOT NULL	The identifier of the price rule element template.
STOREENT_ID	INTEGER	The store for which the price rule element template is applied. If this is null, the element template is applied for all stores.
DESCRIPTION	VARCHAR (254)	A description of the price rule element template.
PRELETPLTGRP_ID	BIGINT NOT NULL	The identifier of the price rule element template group.
RUNTIMEXML	CLOB (1000000)	The runtime XML definition of the element template.
FIELD1	VARCHAR (254)	Customizable.
FIELD2	VARCHAR (254)	Customizable.
FIELD3	VARCHAR (254)	Customizable.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	PRELETEMPLATE_ID	Primary Key
I0001343	PRELETPLTGRP_ID+IDENTIFIER+STOREENT_ID	Unique Index
I0001344	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3631	PRELETPLTGRP_ID	PRELETPLTGRP	PRELETPLTGRP_ID	Cascade
F_3632	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3634	PRELETEMPLATE_ID	PRELEMENT	PRELETEMPLATE_ID	Cascade