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 Descriptions:

NameTypeDescription
BKORDNUMINTEGER NOT NULLA number that uniquely identifies this backorder allocation along with its specified OrderItem.
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem that is backordered.
ITEMSPC_IDBIGINT NOT NULLIf 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.
QTYNEEDEDINTEGERThe quantity required for this component to fulfill the line item.
QTYAVAILABLEINTEGERThe quantity of inventory available for this item, or QTYNEEDED, whichever is smaller.
QTYALLOCATEDINTEGERThe quantity of available inventory that has been allocated to the backorder.
LASTUPDATETIMESTAMPTimestamp of the last update to this order allocation.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERITEMS_ID+BKORDNUMPrimary Key
I0000481ITEMSPC_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_124ITEMSPC_IDITEMSPCITEMSPC_IDCascade
F_125ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade