This table stores item information for a return or credit for a return merchandise authorization (RMA).
Column Name | Column Type | Description |
---|---|---|
RMAITEM_ID | BIGINT NOT NULL | Generated unique key. |
RMA_ID | BIGINT NOT NULL | The RMA of which this RMAItem is a part. |
CATENTRY_ID | BIGINT NOT NULL | Reserved for IBM internal use. |
MEMBER_ID | BIGINT NOT NULL | The ID of the member who created the RMA item record. |
ORDERITEMS_ID | BIGINT | The OrderItem from which the ITEMSPC_ID is from. |
ITEMSPC_ID | BIGINT NOT NULL | Identity of the inventory item. |
RTNREASON_ID | INTEGER NOT NULL | The reason for the item to be returned. |
REFUNDORREPLACE | CHAR(3) NOT NULL | Specifies whether the RMA item will be refunded or replaced: REF (refund) or REP (replace). This affects whether credit is done internally or externally and whether exchange information was gathered. Only REF is valid. |
CREDITAMOUNT | DECIMAL (20,5) NOT NULL DEFAULT 0 | The amount of the credit for this item in the currency specified by CURRENCY. If this amount is NULL then the credit amount is unknown. |
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. |
CREDITDATE | TIMESTAMP | The date that the credit was initiated. |
STATUS | CHAR(3) DEFAULT 'PND' | The status of the RMAItem as follows: PND = pending APP = automatically approved MAN = manually approved |
CURRENCY | CHAR(3) NOT NULL | The currency of the monetary amounts specified for this item. This is a currency code as per ISO 4217 standards. |
COMMENTS | VARCHAR(254) | Comment that applies to the RMA item. |
TAXAMOUNT | DECIMAL (20,5) | The amount of tax to be refunded, in the currency specified by CURRENCY. If this amount is NULL then the tax amount is unknown. |
ADJUSTMENTCREDIT | DECIMAL (20,5) NOT NULL DEFAULT 0 | The adjustment, from the original order, to be credited. |
ADJUSTMENT | DECIMAL (20,5) NOT NULL DEFAULT 0 | Any adjustment to be made to the credit amount by a Customer Service Representative. |
LASTUPDATE | TIMESTAMP | Timestamp of the last update. |
TOTALCREDIT | DECIMAL (20,5) NOT NULL DEFAULT 0 | Total credit for the RMA Item. |
INVQUANTITY | INTEGER NOT NULL DEFAULT 0 | Quantity in inventory units. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031306760 | RMAITEM_ID | Primary Key |
I0000215 | RMA_ID+RMAITEM_ID | Non-Unique Index |
I0000747 | ITEMSPC_ID | Non-Unique Index |
I0000748 | MEMBER_ID | Non-Unique Index |
I0000749 | CATENTRY_ID | Non-Unique Index |
I837116 | ORDERITEMS_ID+RMAITEM_ID+STATUS+RMA_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_708 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_711 | ITEMSPC_ID | ITEMSPC | ITEMSPC_ID | Cascade |
F_709 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
F_710 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_713 | RMA_ID | RMA | RMA_ID | Cascade |
F_712 | RTNREASON_ID | RTNREASON | RTNREASON_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_703 | RMAITEM_ID | RMACHARGE | RMAITEM_ID | Cascade |
F_705 | RMAITEM_ID | RMAIADJCRD | RMAITEM_ID | Cascade |
F_706 | RMAITEM_ID | RMAIDNYRSN | RMAITEM_ID | Cascade |
F_716 | RMAITEM_ID | RMAITEMCMP | RMAITEM_ID | Cascade |