WebSphere Commerce database table: ORDSHIPHST
Each row contains information about inventory that has been released for fulfillment of an OrderItem.
Column Descriptions Column Name Column Type Description ORDSHIPHSTNUM INTEGER NOT NULL Uniquely identifies this row for an OrderItem. ORDERITEMS_ID BIGINT NOT NULL The OrderItem. VERSIONSPC_ID BIGINT NOT NULL The item that describes the shipped inventory. RECEIPT_ID BIGINT The receipt for the shipped inventory. QTYSHIPPED INTEGER Quantity shipped from this receipt. DATESHIPPED TIMESTAMP The time the OrderItem was released for fulfillment. LASTUPDATE TIMESTAMP The time of last update. QTYRETURNED INTEGER NOT NULL DEFAULT 0 The amount returned by the customer. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL060903235223550 ORDERITEMS_ID+ORDSHIPHSTNUM Primary Key I0000674 RECEIPT_ID Non-Unique Index I0000675 VERSIONSPC_ID Non-Unique Index Related reference
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_549 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade F_550 RECEIPT_ID RECEIPT RECEIPT_ID Cascade F_548 VERSIONSPC_ID VERSIONSPC VERSIONSPC_ID Cascade