Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce 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 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030404120 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
- Receipt data model
- Order item - allocated data model
- ATP inventory fulfillment data model
- ATP inventory orders data model
_vcc_freeselect_bottom_