Database View: STDPRICEVW

This view is a proxy to the STDPRICE summary table to define standard price (offer price) for each CatalogEntry.

Column Name Column Type Column Description
CATENTRY_ID BIGINT
NOT NULL
The CatalogEntry that this standard price describes. It is CATENTRY_ID found in the OFFER table.
CURRENCY CHARACTER (3)
NOT NULL
The currency of Price. It is CURRENCY found in the OFFERPRICE table.
PRICE DECIMAL (20,5)
NOT NULL
The Price that this standard price describes. It is PRICE found in the OFFERPRICE table.
Indexes:
Index Name Indexed Column Names Index Type
Not Applicable
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable