This summary table defines the standard (offer)
price for each CatalogEntry. It contains pre-computed results based
on the data existing in the underlying OFFER, OFFERPRICE, and
TRADEPOSCN tables.
Column Descriptions:
| Name | Type | Description |
| CATENTRY_ID | BIGINT NOT NULL | This CatalogEntry that this standard price
describes.This is the same as the CATENTRY_ID found in the OFFER
table. |
| PRICE | DECIMAL (20,5) NOT NULL | The price that this standard price describes.
This is the same as the PRICCE found in the OFFERPRICE table. |
| CURRENCY | CHAR (3) NOT NULL | The currency of price. This is the same as the
CURRENCY found in the OFFERPRICE table. |
| C5 | INTEGER NOT NULL | Reserved for HCL internal use. |
Indexes:
| Name | Column Names | Type |
| I_STDPRICE | PRICE+CATENTRY_ID+CURRENCY | Non-Unique Index |