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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035024020 | ORDERITEMS_ID, ORDSHIPHSTNUM | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|