WebSphere Commerce database table: ORDITEMCONF

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

Column Descriptions
Column Name Column 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 IBM internal use

Indexes
Index Name Indexed Column Names Index Type
SQL060903235221540 ORDITEMCONF_ID Primary Key
I0000974 ORDERITEMS_ID+OICOMPLIST_ID Non-Unique Index
I0000975 SERIALNUMBER Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3475 MANIFEST_ID MANIFEST MANIFEST_ID Cascade
F_3473 OICOMPLIST_ID OICOMPLIST OICOMPLIST_ID Cascade
F_3474 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade