STDPRICE

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:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThis CatalogEntry that this standard price describes.This is the same as the CATENTRY_ID found in the OFFER table.
PRICEDECIMAL (20,5) NOT NULLThe price that this standard price describes. This is the same as the PRICCE found in the OFFERPRICE table.
CURRENCYCHAR (3) NOT NULLThe currency of price. This is the same as the CURRENCY found in the OFFERPRICE table.
C5INTEGER NOT NULLReserved for HCL internal use.

Indexes:

NameColumn NamesType
I_STDPRICEPRICE+CATENTRY_ID+CURRENCYNon-Unique Index