WebSphere Commerce database table: RADETAIL

This table contains detailed information about items on an expected inventory record.

Column Descriptions
Column Name Column Type Description
RADETAIL_ID BIGINT NOT NULL Unique identifier.
RA_ID BIGINT NOT NULL Expected inventory record identifier.
FFMCENTER_ID INTEGER FulfillmentCenter identifier.
ITEMSPC_ID BIGINT NOT NULL Item identifier.
QTYORDERED INTEGER NOT NULL DEFAULT 0 Quantity ordered from vendor in this expected inventory record.
QTYRECEIVED INTEGER NOT NULL DEFAULT 0 Quantity received to date from the vendor for this expected inventory record.
QTYREMAINING INTEGER NOT NULL DEFAULT 0 Quantity still expected from vendor for this expected inventory record. This quantity should usually be equal to the quantity ordered minus the quantity received. But it could be different if the vendor is unable to ship the total quantity.
QTYALLOCATED INTEGER NOT NULL DEFAULT 0 Quantity of expected inventory that has been allocated to backorders.
EXPECTEDDATE TIMESTAMP NOT NULL Date the inventory is expected.
RADETAILCOMMENT VARCHAR(254) Comment.
LASTUPDATE TIMESTAMP Timestamp of last update.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if this row has been marked for deletion:
0 = No.
1 = Yes, this row has been marked for deletion and should not be used.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000201 RA_ID+FFMCENTER_ID+ITEMSPC_ID+EXPECTEDDATE Unique Index
SQL060903235241680 RADETAIL_ID Primary Key
I0000202 RA_ID+RADETAIL_ID+EXPECTEDDATE Non-Unique Index
I0000712 ITEMSPC_ID Non-Unique Index
I0000713 FFMCENTER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_655 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade
F_656 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_657 RA_ID RA RA_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_652 RADETAIL_ID RABACKALLO RADETAIL_ID Cascade
F_660 RADETAIL_ID RECEIPT RADETAIL_ID Cascade
Related reference