Details of the how inventory was picked from the receipt level when available inventory is allocated to an OrderItem.
Column Descriptions
| 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.
|