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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000145 | CURRENCY, CATENTRY_ID, LISTPRICE | Non-Unique Index |
SQL030416034952960 | CURRENCY, CATENTRY_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|