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