Database Table: RABACKALLO

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

Column Name Column Type Column Description
ITEMSPC_ID BIGINT
NOT NULL
The backordered item.
LASTUPDATE TIMESTAMP
NULL
Timestamp of the last update.
ORDERITEMS_ID BIGINT
NOT NULL
The OrderItem that is backordered.
QTYALLOCATED INTEGER
NULL
Amount of expected inventory allocated to this backordered OrderItem.
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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035047800 ORDERITEMS_ID, RABACKALLONUM Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_652 RADETAIL_ID RADETAIL RADETAIL_ID Cascade
F_653 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_654 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable