WebSphere Commerce database table: RABACKALLO

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031303630 ORDERITEMS_ID+RABACKALLONUM Primary Key
I0000710 ITEMSPC_ID Non-Unique Index
I0000711 RADETAIL_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Feedback