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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035047800 | ORDERITEMS_ID, RABACKALLONUM | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|