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

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
Related reference