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 Descriptions:

NameTypeDescription
BASEITEM_IDBIGINT NOT NULLGenerated unique key.
MEMBER_IDBIGINT NOT NULLThe owner of this BaseItem.
ITEMTYPE_IDCHAR (4) NOT NULLThe type of BaseItem.
QUANTITYMEASURECHAR (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).
LASTUPDATETIMESTAMPThe last time this BaseItem was updated.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates 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.
PARTNUMBERVARCHAR (72) NOT NULLUniquely identifies a BaseItem for a particular owner.
QUANTITYMULTIPLEDOUBLE NOT NULL DEFAULT 1.0Amounts 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.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>BASEITEM_IDPrimary Key
I0000040MEMBER_ID+PARTNUMBERUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_106ITEMTYPE_IDITEMTYPEITEMTYPE_IDCascade
F_107QUANTITYMEASUREQTYUNITQTYUNIT_IDCascade
F_108MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_110BASEITEM_IDBASEITMDSCBASEITEM_IDCascade
F_202BASEITEM_IDCATENTRYBASEITEM_IDCascade
F_310BASEITEM_IDDISTARRANGBASEITEM_IDCascade
F_407BASEITEM_IDITEMSPCBASEITEM_IDCascade
F_408BASEITEM_IDITEMVERSNBASEITEM_IDCascade
F_797BASEITEM_IDSTOREITEMBASEITEM_IDCascade
F_807BASEITEM_IDSTORITMFFCBASEITEM_IDCascade