VERSIONSPC

Each row defines the relationship between a product version and a specified item.

Column Descriptions:

Name	Type	Description
VERSIONSPC_ID	BIGINT NOT NULL	Generated unique identifier.
ITEMSPC_ID	BIGINT NOT NULL	The specified item.
ITEMVERSN_ID	BIGINT NOT NULL	Identifies the item version.
LASTUPDATE	TIMESTAMP	Timestamp of last update.
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>	VERSIONSPC_ID	Primary Key
I0000264	ITEMSPC_ID+ITEMVERSN_ID	Unique Index
I0000363	VERSIONSPC_ID+ITEMSPC_ID	Unique Index
I0001293	ITEMVERSN_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_905	ITEMSPC_ID	ITEMSPC	ITEMSPC_ID	Cascade
F_906	ITEMVERSN_ID	ITEMVERSN	ITEMVERSN_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_543	VERSIONSPC_ID	ORDPICKHST	VERSIONSPC_ID	Cascade
F_548	VERSIONSPC_ID	ORDSHIPHST	VERSIONSPC_ID	Cascade
F_665	VERSIONSPC_ID	RECEIPT	VERSIONSPC_ID	Cascade
F_729	VERSIONSPC_ID	RTNRECEIPT	VERSIONSPC_ID	Cascade

Related reference
ATP inventory data model
ATP inventory adjustment data model
ATP inventory orders data model
Order management - receipt and disposition data model
Order item - allocated data model
Order release data model
Receipt data model