Database Table: ICTPRICES

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

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

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