Database Table: ORDPICKHST

Details of the how inventory was picked from the receipt level when available inventory is allocated to an OrderItem.

Column Name Column Type Column Description
DATEPICKED TIMESTAMP
NULL
The time when inventory was allocated to the Order.
LASTUPDATE TIMESTAMP
NULL
Time of last update.
ORDERITEMS_ID BIGINT
NOT NULL
Foreign key to the ORDERITEMS table.
ORDERPICKINGTYPE INTEGER
NULL
Reserved for IBM internal use.
ORDPICKHSTNUM INTEGER
NOT NULL
Uniquely identifies a row for this OrderItem.
QTYPICKED INTEGER
NULL
Quantity allocated from this receipt.
RECEIPT_ID BIGINT
NULL
Receipt that was used for this allocation. This value will be NULL if the item is not tracked.
VERSIONSPC_ID BIGINT
NOT NULL
Item identifier.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035022950 ORDERITEMS_ID, ORDPICKHSTNUM Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_543 VERSIONSPC_ID VERSIONSPC VERSIONSPC_ID Cascade
F_544 RECEIPT_ID RECEIPT RECEIPT_ID Cascade
F_545 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable