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