WebSphere Commerce database table: ORDSHIPHST

Each row contains information about inventory that has been released for fulfillment of an OrderItem.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031250300 ORDERITEMS_ID+ORDSHIPHSTNUM Primary Key
I0000674 RECEIPT_ID Non-Unique Index
I0000675 VERSIONSPC_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback