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

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
Related reference