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 Descriptions:
Name | 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. It may be different with the one in the catentry table. |
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> | ITEMSPC_ID | Primary Key |
I0000138 | PARTNUMBER+MEMBER_ID | Unique Index |
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 |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_406 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
F_407 | BASEITEM_ID | BASEITEM | BASEITEM_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_1229 | ITEMSPC_ID | OICOMPREL | ITEMSPC_ID | Cascade |
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 |