Details of the how inventory was picked from the
receipt level when available inventory is allocated to an
OrderItem.
Column Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | 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 |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 |