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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000130 | IPSGNBR | Non-Unique Index |
I0000131 | PPPRC | Non-Unique Index |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|