Information about specified items. A specified item is a product with values for all its attributes. A specified item could correspond to a 2L bottle of milk, with 2% fat content. A specified item is the customer view of what the merchant sells.
Column Name | Column Type | Description |
---|---|---|
ITEMSPC_ID | BIGINT NOT NULL | Generated unique key. |
LASTUPDATE | TIMESTAMP | Timestamp of last update. |
MEMBER_ID | BIGINT NOT NULL | The owner of this specified item. |
MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates if the specified item is marked for deletion: 0 = No, it may be ordered. 1 = Marked for deletion and cannot be ordered or backordered. |
BASEITEM_ID | BIGINT NOT NULL | The product BaseItem. |
DISCONTINUED | CHAR(1) NOT NULL DEFAULT 'N' | Y = This item specification has been discontinued. It can be ordered if there is sufficient inventory but it cannot be backordered. N = This item specification is active and may be backordered if out of stock. |
PARTNUMBER | VARCHAR(64) NOT NULL | Uniquely identifies an item for a particular owner. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000138 | PARTNUMBER+MEMBER_ID | Unique Index |
SQL050212031235220 | ITEMSPC_ID | Primary Key |
I0000139 | BASEITEM_ID+ITEMSPC_ID | Non-Unique Index |
I0000361 | ITEMSPC_ID+BASEITEM_ID+PARTNUMBER | Non-Unique Index |
I0000599 | MEMBER_ID | Non-Unique Index |
I800140 | DISCONTINUED | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_407 | BASEITEM_ID | BASEITEM | BASEITEM_ID | Cascade |
F_406 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_124 | ITEMSPC_ID | BKORDALLOC | ITEMSPC_ID | Cascade |
F_201 | ITEMSPC_ID | CATENTRY | ITEMSPC_ID | Cascade |
F_405 | ITEMSPC_ID | ITEMFFMCTR | ITEMSPC_ID | Cascade |
F_474 | ITEMSPC_ID | OICOMPLIST | ITEMSPC_ID | Cascade |
F_1229 | ITEMSPC_ID | OICOMPREL | ITEMSPC_ID | Cascade |
F_502 | ITEMSPC_ID | ORDERITEMS | ITEMSPC_ID | Cascade |
F_653 | ITEMSPC_ID | RABACKALLO | ITEMSPC_ID | Cascade |
F_656 | ITEMSPC_ID | RADETAIL | ITEMSPC_ID | Cascade |
F_711 | ITEMSPC_ID | RMAITEM | ITEMSPC_ID | Cascade |
F_715 | ITEMSPC_ID | RMAITEMCMP | ITEMSPC_ID | Cascade |
F_905 | ITEMSPC_ID | VERSIONSPC | ITEMSPC_ID | Cascade |