Each row in this table contains information about how a product represented by a CatalogEntry is packaged. The information can be used to determine prices, discounts, shipping charges, and taxes.
Column Description(s):
Column Name | Column Type | Description |
CATENTRY_ID |
BIGINT NOT NULL |
The CatalogEntry. |
WEIGHT |
DOUBLE |
A nominal weight associated with the product. |
WEIGHTMEASURE |
CHAR(16) |
The unit of measurement for WEIGHT. |
LENGTH |
DOUBLE |
A nominal length associated with the product. |
WIDTH |
DOUBLE |
A nominal width associated with the product. |
HEIGHT |
DOUBLE |
A nominal height associated with the product. |
SIZEMEASURE |
CHAR(16) |
The unit of measurement for LENGTH, WIDTH, and HEIGHT. |
NOMINALQUANTITY |
DOUBLE NOT NULL DEFAULT 1.0 |
A nominal quantity for a product, used for pricing. For example, if a product is priced as "3 for a dollar", then the nominal quantity of the product is 3, and the price of the product is one dollar. |
QUANTITYMULTIPLE |
DOUBLE NOT NULL DEFAULT 1.0 |
The product can be sold in quantities that are multiples of this quantity. |
QUANTITYMEASURE |
CHAR(16) NOT NULL DEFAULT 'C62' |
The unit of measurement for NOMINALQUANTITY and QUANTITYMULTIPLE. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031209220 |
CATENTRY_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_205 |
CATENTRY_ID |
CATENTRY |
CATENTRY_ID |
Cascade |
F_206 |
QUANTITYMEASURE |
QTYUNIT |
QTYUNIT_ID |
Cascade |
F_207 |
SIZEMEASURE |
QTYUNIT |
QTYUNIT_ID |
Cascade |
F_208 |
WEIGHTMEASURE |
QTYUNIT |
QTYUNIT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.