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:
Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> BASEITEM_ID Primary Key I0000040 MEMBER_ID+PARTNUMBER Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns 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 Child Tables:
Constraint Columns Child Table Child Columns 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
Related reference
ATP inventory data model
ATP inventory fulfillment data model
ATP inventory orders data model
Catalog entry data model
Quantity unit - references data model