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 Description(s):
Column Name | Column 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 IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I_STDPRICE |
PRICE+CATENTRY_ID+CURRENCY |
Non-Unique Index |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.