| 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
Note: If a returns request is denied, the status is then
still PND. |
| 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |