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 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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_731 | RMAITEMCMP_ID | RTNRECEIPT | RMAITEMCMP_ID | Cascade |