WebSphere Commerce database table: RABACKALLO

Each row contains information about how backorders are allocated against expected inventory.

Column Descriptions
Column Name Column Type Description
RABACKALLONUM INTEGER NOT NULL Uniquely identifies this row for a backordered OrderItem.
RADETAIL_ID BIGINT NOT NULL The RADETAIL row which contributed to the allocation.
ITEMSPC_ID BIGINT NOT NULL The backordered item.
ORDERITEMS_ID BIGINT NOT NULL The OrderItem that is backordered.
QTYALLOCATED INTEGER Amount of expected inventory allocated to this backordered OrderItem.
LASTUPDATE TIMESTAMP Timestamp of the last update.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235241500 ORDERITEMS_ID+RABACKALLONUM Primary Key
I0000710 ITEMSPC_ID Non-Unique Index
I0000711 RADETAIL_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_653 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_654 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_652 RADETAIL_ID RADETAIL RADETAIL_ID Cascade
Related reference