Details of the how inventory was picked from the receipt level when available inventory is allocated to an OrderItem.
Column Description(s):
Column Name | Column Type | Description |
ORDPICKHSTNUM |
INTEGER NOT NULL |
Uniquely identifies a row for this OrderItem. |
ORDERITEMS_ID |
BIGINT NOT NULL |
Foreign key to the ORDERITEMS table. |
VERSIONSPC_ID |
BIGINT NOT NULL |
Item identifier. |
RECEIPT_ID |
BIGINT |
Receipt that was used for this allocation. This value will be NULL if the item is not tracked. |
QTYPICKED |
INTEGER |
Quantity allocated from this receipt. |
DATEPICKED |
TIMESTAMP |
The time when inventory was allocated to the Order. |
ORDERPICKINGTYPE |
INTEGER |
Reserved for IBM internal use. |
LASTUPDATE |
TIMESTAMP |
Time of last update. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031248300 |
ORDERITEMS_ID+ORDPICKHSTNUM |
Primary Key |
I0000362 |
ORDERITEMS_ID+VERSIONSPC_ID+QTYPICKED |
Non-Unique Index |
I0000671 |
RECEIPT_ID |
Non-Unique Index |
I0000672 |
VERSIONSPC_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_545 |
ORDERITEMS_ID |
ORDERITEMS |
ORDERITEMS_ID |
Cascade |
F_544 |
RECEIPT_ID |
RECEIPT |
RECEIPT_ID |
Cascade |
F_543 |
VERSIONSPC_ID |
VERSIONSPC |
VERSIONSPC_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.