Each row contains information about the quantity required for this backordered order item and the amount of available inventory allocated to this item.
Column Name | Column Type | Column Description |
---|---|---|
BKORDNUM | INTEGER NOT NULL |
A number that uniquely identifies this backorder allocation along with its specified OrderItem. |
ITEMSPC_ID | BIGINT NOT NULL |
If the OrderItem is a kit, then the ITEMSPC_ID will be for the kit component. If the OrderItem is not a kit, then ITEMSPC_ID is the same as the ORDERITEMS.ITEMSPC_ID. |
LASTUPDATE | TIMESTAMP NULL |
Timestamp of the last update to this order allocation. |
ORDERITEMS_ID | BIGINT NOT NULL |
The OrderItem that is backordered. |
QTYALLOCATED | INTEGER NULL |
The quantity of available inventory that has been allocated to the backorder. |
QTYAVAILABLE | INTEGER NULL |
The quantity of inventory available for this item, or QTYNEEDED, whichever is smaller. |
QTYNEEDED | INTEGER NULL |
The quantity required for this component to fulfill the line item. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034844160 | ORDERITEMS_ID, BKORDNUM | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_124 | ITEMSPC_ID | ITEMSPC | ITEMSPC_ID | Cascade |
F_125 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|