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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_731 | RMAITEMCMP_ID | RTNRECEIPT | RMAITEMCMP_ID | Cascade |