ORDSHIPHST

Each row contains information about inventory that has been released for fulfillment of an OrderItem.

Column Descriptions:

NameTypeDescription
ORDSHIPHSTNUMINTEGER NOT NULLUniquely identifies this row for an OrderItem.
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem.
VERSIONSPC_IDBIGINT NOT NULLThe item that describes the shipped inventory.
RECEIPT_IDBIGINTThe receipt for the shipped inventory.
QTYSHIPPEDINTEGERQuantity shipped from this receipt.
DATESHIPPEDTIMESTAMPThe time the OrderItem was released for fulfillment.
LASTUPDATETIMESTAMPThe time of last update.
QTYRETURNEDINTEGER NOT NULL DEFAULT 0The amount returned by the customer.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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+ORDSHIPHSTNUMPrimary Key
I0000674RECEIPT_IDNon-Unique Index
I0000675VERSIONSPC_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_548VERSIONSPC_IDVERSIONSPCVERSIONSPC_IDCascade
F_549ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_550RECEIPT_IDRECEIPTRECEIPT_IDCascade