This table stores item information for a return or credit for a return merchandise authorization (RMA).
Column Descriptions
| 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.
|