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:

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

Related reference
ATP inventory data model
ATP expected inventory data model
ATP inventory fulfillment data model
ATP inventory orders data model
ATP inventory reservations data model
Catalog entry data model
Order management - RMAitem data model
Order item - allocated data model
Order item - backordered data model
Order release data model
Vendor data model