ORDITEMCONF

This table is used to check order item shipment confirmation and capture the order serial numbers

Column Descriptions:

Name	Type	Description
ORDITEMCONF_ID	BIGINT NOT NULL	The generated order items confirmation identifier.
ORDERITEMS_ID	BIGINT NOT NULL	The identifier of the orderitem associated with this serial number.
OICOMPLIST_ID	BIGINT	The identifier of the component of a configured OrderItem associated with the serial number.
SERIALNUMBER	VARCHAR (128)	The string representation of the serial number.
MANIFEST_ID	BIGINT	The identifier of the shipping manifest during which this item was shipped.
ORDRELEASENUM	INTEGER NOT NULL	the identifier of the release.
QUANTITY	DOUBLE NOT NULL	The quantity that has been shipped within this package (same as inventory UOM)
CONFIRMTYPE	SMALLINT NOT NULL	This field indicates the confirmation type of the item. 0 - order item shipment confirmation 1 - serial number shipment confirmation 2 - order item receipt confirmation 3 - serial number receipt confirmation
CREATION_TIMESTAMP	TIMESTAMP NOT NULL	Time when the confirmation was recorded.
LASTUPDATE	TIMESTAMP NOT NULL	Time when 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>	ORDITEMCONF_ID	Primary Key
I0000974	ORDERITEMS_ID+OICOMPLIST_ID	Non-Unique Index
I0000975	SERIALNUMBER	Non-Unique Index
I0001268	OICOMPLIST_ID	Non-Unique Index
I0001269	MANIFEST_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3473	OICOMPLIST_ID	OICOMPLIST	OICOMPLIST_ID	Cascade
F_3474	ORDERITEMS_ID	ORDERITEMS	ORDERITEMS_ID	Cascade
F_3475	MANIFEST_ID	MANIFEST	MANIFEST_ID	Cascade