This table describes the smallest unit of inventory items involved in a return merchandise authorization (RMA).
Column Descriptions
| 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 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.
|