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.
|