WebSphere Commerce database table: RADETAIL

Reference > Database > WebSphere Commerce database tables > R

WebSphere Commerce database table: RADETAIL

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

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
SQL100520030420910 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

Referenced By
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

Receipt data model

Vendor data model

Order item - backordered data model

ATP inventory expected data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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.

Index Name	Indexed Column Names	Index Type
I0000201	RA_ID+FFMCENTER_ID+ITEMSPC_ID+EXPECTEDDATE	Unique Index
SQL100520030420910	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

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