Each row contains information about the quantity required for this backordered order item and the amount of available inventory allocated to this item.
Column Description(s):
Column Name | Column Type | Description |
BKORDNUM |
INTEGER NOT NULL |
A number that uniquely identifies this backorder allocation along with its specified OrderItem. |
ORDERITEMS_ID |
BIGINT NOT NULL |
The OrderItem that is backordered. |
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. |
QTYNEEDED |
INTEGER |
The quantity required for this component to fulfill the line item. |
QTYAVAILABLE |
INTEGER |
The quantity of inventory available for this item, or QTYNEEDED, whichever is smaller. |
QTYALLOCATED |
INTEGER |
The quantity of available inventory that has been allocated to the backorder. |
LASTUPDATE |
TIMESTAMP |
Timestamp of the last update to this order allocation. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031201730 |
ORDERITEMS_ID+BKORDNUM |
Primary Key |
I0000481 |
ITEMSPC_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_124 |
ITEMSPC_ID |
ITEMSPC |
ITEMSPC_ID |
Cascade |
F_125 |
ORDERITEMS_ID |
ORDERITEMS |
ORDERITEMS_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.