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 | Column Description |
---|---|---|
BASEITEM_ID | BIGINT NOT NULL |
The product BaseItem. |
DISCONTINUED | CHARACTER (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. |
ITEMSPC_ID | BIGINT NOT NULL |
Generated unique key. |
LASTUPDATE | TIMESTAMP NULL |
Timestamp of last update. |
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. |
MEMBER_ID | BIGINT NOT NULL |
The owner of this specified item. |
PARTNUMBER | VARCHAR (64) NOT NULL |
Uniquely identifies an item for a particular owner. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000138 | PARTNUMBER, MEMBER_ID | Unique Index |
I0000139 | BASEITEM_ID, ITEMSPC_ID | Non-Unique Index |
I800140 | DISCONTINUED | Non-Unique Index |
SQL030416034949510 | ITEMSPC_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_406 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
F_407 | BASEITEM_ID | BASEITEM | BASEITEM_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | 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_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 |