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 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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034844160 ORDERITEMS_ID, BKORDNUM Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable