Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RMAITEMCMP
This table describes the smallest unit of inventory items involved in a return merchandise authorization (RMA).
Column Name Column Type Description RMAITEMCMP_ID BIGINT NOT NULL Generated unique key. RMAITEM_ID BIGINT NOT NULL The RMAItem that this component is a part of. CATENTRY_ID BIGINT Reserved for IBM internal use. ITEMSPC_ID BIGINT NOT NULL Identity of the inventory item. QUANTITY DOUBLE NOT NULL The result of multiplying QUANTITY by CATENTSHIP.NOMINALQUANTITY must be a multiple of CATENTSHIP.QUANTITYMULTIPLE. And represents the actual quantity being purchased, in the unit of measurement specified by CATENTSHIP.QUANTITYMEASURE. SHOULDRECEIVE CHAR(1) NOT NULL DEFAULT 'Y' A flag that indicates whether this component will actually be received by the seller. Valid values are...
Y = Expected to be received.
N = Will not be received.
S = System forced. Will not be received.INVQUANTITY INTEGER NOT NULL DEFAULT 0 Quantity in inventory units of this component OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030424420 RMAITEMCMP_ID Primary Key I0000216 RMAITEM_ID+RMAITEMCMP_ID+SHOULDRECEIVE Non-Unique Index I0000750 CATENTRY_ID Non-Unique Index I838141 ITEMSPC_ID+RMAITEM_ID+INVQUANTITY Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_714 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_715 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade F_716 RMAITEM_ID RMAITEM RMAITEM_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3472 RMAITEMCMP_ID RMAITEMSERIAL RMAITEMCMP_ID Cascade F_731 RMAITEMCMP_ID RTNRECEIPT RMAITEMCMP_ID Cascade
Related reference
_vcc_freeselect_bottom_