Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BKORDALLOC
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 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030303140 ORDERITEMS_ID+BKORDNUM Primary Key I0000481 ITEMSPC_ID Non-Unique Index
Constraints 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
Related reference
_vcc_freeselect_bottom_