WebSphere Commerce database table: LISTPRICE
Each row of this table represents a ListPrice in a particular currency for a CatalogEntry.
Column Descriptions
| Column Name
| Column Type
| Description |
| CATENTRY_ID
| BIGINT NOT NULL
| The CatalogEntry.
|
| CURRENCY
| CHAR(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)
| Reserved for IBM internal use.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235210880
| CURRENCY+CATENTRY_ID
| Primary Key
|
| I0000145
| CURRENCY+CATENTRY_ID+LISTPRICE
| Non-Unique Index
|
| I0000604
| CATENTRY_ID
| Non-Unique Index
|
Constraints
| Constraint Name
| Column Names
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_419
| CATENTRY_ID
| CATENTRY
| CATENTRY_ID
| Cascade
|
| F_418
| CURRENCY
| SETCURR
| SETCCURR
| Cascade
|
Related reference