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 Related reference
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