Database Table: RMAITEMCMP

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

Column Name Column Type Column Description
CATENTRY_ID BIGINT
NULL
Reserved for IBM internal use.
INVQUANTITY INTEGER
NOT NULL, DEFAULT 0
Quantity in inventory units of this component
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.
RMAITEMCMP_ID BIGINT
NOT NULL
Generated unique key.
RMAITEM_ID BIGINT
NOT NULL
The RMAItem that this component is a part of.
SHOULDRECEIVE CHARACTER (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.
Indexes:
Index Name Indexed Column Names Index Type
I0000216 RMAITEM_ID, RMAITEMCMP_ID, SHOULDRECEIVE Non-Unique Index
I838141 ITEMSPC_ID, RMAITEM_ID, INVQUANTITY Non-Unique Index
SQL030416035055600 RMAITEMCMP_ID Primary Key
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_731 RMAITEMCMP_ID RTNRECEIPT RMAITEMCMP_ID Cascade