WebSphere Commerce database table: STDPRICEVW

WebSphere Commerce database table: STDPRICEVW

This view is a proxy to the STDPRICE summary table to define the standard price (offer price) for each CatalogEntry.
Column Descriptions
Column Name Column Type Description
CATENTRY_ID BIGINT NOT NULL The 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 PRICE found in the OFFERPRICE table.
CURRENCY CHAR(3) NOT NULL The currency for the price. This is the same as the CURRENCY found in the OFFERPRICE table.

Column Name	Column Type	Description
CATENTRY_ID	BIGINT NOT NULL	The 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 PRICE found in the OFFERPRICE table.
CURRENCY	CHAR(3) NOT NULL	The currency for the price. This is the same as the CURRENCY found in the OFFERPRICE table.