Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDSHIPHST
Each row contains information about inventory that has been released for fulfillment of an OrderItem.
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 SQL100520030405000 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
- Receipt data model
- Order release data model
- ATP inventory fulfillment data model
- ATP inventory orders data model
_vcc_freeselect_bottom_