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 Name | Column Type | Column Description |
---|---|---|
BASEITEM_ID | BIGINT NOT NULL |
Generated unique key. |
ITEMTYPE_ID | CHARACTER (4) NOT NULL |
The type of BaseItem. |
LASTUPDATE | TIMESTAMP NULL |
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. |
MEMBER_ID | BIGINT NOT NULL |
The owner of this BaseItem. |
PARTNUMBER | VARCHAR (64) NOT NULL |
Uniquely identifies a BaseItem for a particular owner. |
QUANTITYMEASURE | CHARACTER (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). |
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000040 | MEMBER_ID, PARTNUMBER | Unique Index |
SQL030416034841600 | BASEITEM_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_106 | ITEMTYPE_ID | ITEMTYPE | ITEMTYPE_ID | Cascade |
F_107 | QUANTITYMEASURE | QTYUNIT | QTYUNIT_ID | Cascade |
F_108 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_110 | BASEITEM_ID | BASEITMDSC | BASEITEM_ID | Cascade |
F_202 | BASEITEM_ID | CATENTRY | BASEITEM_ID | Cascade |
F_310 | BASEITEM_ID | DISTARRANG | BASEITEM_ID | Cascade |
F_407 | BASEITEM_ID | ITEMSPC | BASEITEM_ID | Cascade |
F_408 | BASEITEM_ID | ITEMVERSN | BASEITEM_ID | Cascade |
F_797 | BASEITEM_ID | STOREITEM | BASEITEM_ID | Cascade |
F_807 | BASEITEM_ID | STORITMFFC | BASEITEM_ID | Cascade |