WebSphere Commerce database table: 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 Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I_STDPRICE PRICE+CATENTRY_ID+CURRENCY Non-Unique Index

Feedback