ORDPICKHST

Details of the how inventory was picked from the receipt level when available inventory is allocated to an OrderItem.

Column Descriptions:

NameTypeDescription
ORDPICKHSTNUMINTEGER NOT NULLUniquely identifies a row for this OrderItem.
ORDERITEMS_IDBIGINT NOT NULLForeign key to the ORDERITEMS table.
VERSIONSPC_IDBIGINT NOT NULLItem identifier.
RECEIPT_IDBIGINTReceipt that was used for this allocation. This value will be NULL if the item is not tracked.
QTYPICKEDINTEGERQuantity allocated from this receipt.
DATEPICKEDTIMESTAMPThe time when inventory was allocated to the Order.
ORDERPICKINGTYPEINTEGERReserved for IBM internal use.
LASTUPDATETIMESTAMPTime of last update.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERITEMS_ID+ORDPICKHSTNUMPrimary Key
I0000362ORDERITEMS_ID+VERSIONSPC_ID+QTYPICKEDNon-Unique Index
I0000671RECEIPT_IDNon-Unique Index
I0000672VERSIONSPC_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_543VERSIONSPC_IDVERSIONSPCVERSIONSPC_IDCascade
F_544RECEIPT_IDRECEIPTRECEIPT_IDCascade
F_545ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade