RMAITEMCMP

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

Column Descriptions:

NameTypeDescription
RMAITEMCMP_IDBIGINT NOT NULLGenerated unique key.
RMAITEM_IDBIGINT NOT NULLThe RMAItem that this component is a part of.
CATENTRY_IDBIGINTReserved for IBM internal use.
ITEMSPC_IDBIGINT NOT NULLIdentity of the inventory item.
QUANTITYDOUBLE NOT NULLThe 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.
SHOULDRECEIVECHAR (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.
INVQUANTITYINTEGER NOT NULL DEFAULT 0Quantity in inventory units of this component
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RMAITEMCMP_IDPrimary Key
I0000216RMAITEM_ID+RMAITEMCMP_ID+SHOULDRECEIVENon-Unique Index
I0000750CATENTRY_IDNon-Unique Index
I838141ITEMSPC_ID+RMAITEM_ID+INVQUANTITYNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_714CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_715ITEMSPC_IDITEMSPCITEMSPC_IDCascade
F_716RMAITEM_IDRMAITEMRMAITEM_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3472RMAITEMCMP_IDRMAITEMSERIALRMAITEMCMP_IDCascade
F_731RMAITEMCMP_IDRTNRECEIPTRMAITEMCMP_IDCascade