Database Table: ORDSHIPHST

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

Column Name Column Type Column Description
DATESHIPPED TIMESTAMP
NULL
The time the OrderItem was released for fulfillment.
LASTUPDATE TIMESTAMP
NULL
The time of last update.
ORDERITEMS_ID BIGINT
NOT NULL
The OrderItem.
ORDSHIPHSTNUM INTEGER
NOT NULL
Uniquely identifies this row for an OrderItem.
QTYRETURNED INTEGER
NOT NULL, DEFAULT 0
The amount returned by the customer.
QTYSHIPPED INTEGER
NULL
Quantity shipped from this receipt.
RECEIPT_ID BIGINT
NULL
The receipt for the shipped inventory.
VERSIONSPC_ID BIGINT
NOT NULL
The item that describes the shipped inventory.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035024020 ORDERITEMS_ID, ORDSHIPHSTNUM Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_548 VERSIONSPC_ID VERSIONSPC VERSIONSPC_ID Cascade
F_549 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_550 RECEIPT_ID RECEIPT RECEIPT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable