WebSphere Commerce database table: ICTPRICES

This table contains prices for catalog entries extracted from the LISTPRICE table.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000130 IPSGNBR Non-Unique Index
I0000131 PPPRC Non-Unique Index
I0000583 CATENTRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_378 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_377 SETCCURR SETCURR SETCCURR Cascade

Feedback