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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|