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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035022950 | ORDERITEMS_ID, ORDPICKHSTNUM | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|