ORDPICKHST

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 HCL internal use.
LASTUPDATE	TIMESTAMP	Time of last update.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	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