Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RABACKALLO
Each row contains information about how backorders are allocated against expected inventory.
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 SQL100520030420750 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
- Vendor data model
- Order item - backordered data model
- ATP inventory expected data model
- ATP inventory orders data model
_vcc_freeselect_bottom_