Database Table: BASEITEM

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000040 MEMBER_ID, PARTNUMBER Unique Index
SQL030416034841600 BASEITEM_ID Primary Key
Constraints:
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

Referenced By:
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