Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDITEMCONF
This table is used to check order item shipment confirmation and capture the order serial numbers
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 SQL100520030403070 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
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 _vcc_freeselect_bottom_