BaseItems represent a general family of goods with a common name and description. BaseItems are used exclusively for fulfillment. Each CatalogEntry that represents a Product in the catalog has a corresponding BaseItem for fulfillment purposes.
Column Descriptions
| Column Name
| Column Type
| Description
|
| BASEITEM_ID
| BIGINT NOT NULL
| Generated unique key.
|
| MEMBER_ID
| BIGINT NOT NULL
| The owner of this BaseItem.
|
| ITEMTYPE_ID
| CHAR(4) NOT NULL
| The type of BaseItem.
|
| QUANTITYMEASURE
| CHAR(16) NOT NULL DEFAULT 'C62'
| The unit of measure for QUANTITYMULTIPLE. For example, to represent one quarter of an inch, QUANTITYMULTIPLE would be 0.25, and QUANTITYMEASURE would indicate the QTYUNIT that represents inches (normally INH).
|
| LASTUPDATE
| TIMESTAMP
| The last time this BaseItem was updated.
|
| MARKFORDELETE
| INTEGER NOT NULL DEFAULT 0
| Indicates whether a BaseItem has been marked for deletion:
0 = No, the BaseItem can be used.
1 = Yes, The BaseItem has been marked for deletion and cannot be used. Refer to the DBClean utility online help for more information.
|
| PARTNUMBER
| VARCHAR(72) NOT NULL
| Uniquely identifies a BaseItem for a particular owner.
|
| QUANTITYMULTIPLE
| DOUBLE NOT NULL DEFAULT 1.0
| Amounts of this BaseItem are measured in integral units. QUANTITYMULTIPLE, along with QUANTITYMEASURE, indicates how much each integral unit represents. For example, textiles might be measured in integral units each representing one quarter of an inch.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|