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 |