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 |