Each row contains information about the quantity required for this backordered order item and the amount of available inventory allocated to this item.
Column Descriptions
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.
|