WebSphere Commerce database table: RMAITEMCMP

This table describes the smallest unit of inventory items involved in a return merchandise authorization (RMA).


Column Description(s):
Column NameColumn TypeDescription
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 as follows:
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031306890 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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 NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_731 RMAITEMCMP_ID RTNRECEIPT RMAITEMCMP_ID Cascade

Feedback