Database Table: LISTPRICE

Each row of this table represents a ListPrice in a particular currency for a CatalogEntry.

Column Name Column Type Column Description
CATENTRY_ID BIGINT
NOT NULL
The CatalogEntry.
CURRENCY CHARACTER (3)
NOT NULL
The Currency of the ListPrice. This is a currency code as per ISO 4217 standards.
LISTPRICE DECIMAL (20,5)
NOT NULL
The amount of the ListPrice.
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000145 CURRENCY, CATENTRY_ID, LISTPRICE Non-Unique Index
SQL030416034952960 CURRENCY, CATENTRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_418 CURRENCY SETCURR SETCCURR Cascade
F_419 CATENTRY_ID CATENTRY CATENTRY_ID Cascade

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