ITEMSPC

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:

NameTypeDescription
ITEMSPC_IDBIGINT NOT NULLGenerated unique key.
LASTUPDATETIMESTAMPTimestamp of last update.
MEMBER_IDBIGINT NOT NULLThe owner of this specified item.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates 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_IDBIGINT NOT NULLThe product BaseItem.
DISCONTINUEDCHAR (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.
PARTNUMBERVARCHAR (64) NOT NULLUniquely identifies an item for a particular owner. It may be different with the one in the catentry table.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ITEMSPC_IDPrimary Key
I0000138PARTNUMBER+MEMBER_IDUnique Index
I0000139BASEITEM_ID+ITEMSPC_IDNon-Unique Index
I0000361ITEMSPC_ID+BASEITEM_ID+PARTNUMBERNon-Unique Index
I0000599MEMBER_IDNon-Unique Index
I800140DISCONTINUEDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_406MEMBER_IDMEMBERMEMBER_IDCascade
F_407BASEITEM_IDBASEITEMBASEITEM_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1229ITEMSPC_IDOICOMPRELITEMSPC_IDCascade
F_124ITEMSPC_IDBKORDALLOCITEMSPC_IDCascade
F_201ITEMSPC_IDCATENTRYITEMSPC_IDCascade
F_405ITEMSPC_IDITEMFFMCTRITEMSPC_IDCascade
F_474ITEMSPC_IDOICOMPLISTITEMSPC_IDCascade
F_502ITEMSPC_IDORDERITEMSITEMSPC_IDCascade
F_653ITEMSPC_IDRABACKALLOITEMSPC_IDCascade
F_656ITEMSPC_IDRADETAILITEMSPC_IDCascade
F_711ITEMSPC_IDRMAITEMITEMSPC_IDCascade
F_715ITEMSPC_IDRMAITEMCMPITEMSPC_IDCascade
F_905ITEMSPC_IDVERSIONSPCITEMSPC_IDCascade