WebSphere Commerce database table: ICTPRICES
This table contains prices for catalog entries extracted from the LISTPRICE table.
Column Descriptions Column Name Column Type Description STOREID INTEGER NOT NULL Reserved for IBM internal use. CATENTRY_ID BIGINT NOT NULL The internal reference number for the catalog entry. Foreign key to the CATENTRY table. IPSGNBR INTEGER Reserved for IBM internal use. PPPRC DECIMAL (20,5) Price for the catalog entry extracted from the LISTPRICE table. SETCCURR CHAR(3) Currency of the amount. Foreign key to the SETCURR table. This is a currency code as per ISO 4217 standards. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000130 IPSGNBR Non-Unique Index I0000131 PPPRC Non-Unique Index I0000583 CATENTRY_ID Non-Unique Index Related reference
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_378 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_377 SETCCURR SETCURR SETCCURR Cascade