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:
| Name | Type | Description |
| SUBSCRTEMPLATE_ID | BIGINT NOT NULL | The subscription template ID for which the items
to be shipped are defined. |
| CATENTRY_ID | BIGINT NOT NULL | The catalog entry ID that will be fulfilled or
shipped as part of this subscription template. |
| CATENTQUANTITY | INTEGER NOT NULL | The quantity of the catalog entry that will be
fulfilled as part of this subscription template. |
| CATENTPRICE | DECIMAL (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. |
| FIELD1 | INTEGER | Customizable |
| FIELD2 | DECIMAL (20,5) | 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> | SUBSCRTEMPLATE_ID | Primary Key |
| I0001370 | CATENTRY_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3657 | SUBSCRTEMPLATE_ID | SUBSCRTEMPLATE | SUBSCRTEMPLATE_ID | Cascade |
| F_3658 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |