Each row contains information about inventory that has been released for fulfillment of an OrderItem.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031250300 |
ORDERITEMS_ID+ORDSHIPHSTNUM |
Primary Key |
I0000674 |
RECEIPT_ID |
Non-Unique Index |
I0000675 |
VERSIONSPC_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.