RMAITEM

This table stores item information for a return or credit for a return merchandise authorization (RMA).

Column Descriptions:

NameTypeDescription
RMAITEM_IDBIGINT NOT NULLGenerated unique key.
RMA_IDBIGINT NOT NULLThe RMA of which this RMAItem is a part.
CATENTRY_IDBIGINT NOT NULLReserved for HCL internal use.
MEMBER_IDBIGINT NOT NULLThe ID of the member who created the RMA item record.
ORDERITEMS_IDBIGINTThe OrderItem from which the ITEMSPC_ID is from.
ITEMSPC_IDBIGINT NOT NULLIdentity of the inventory item.
RTNREASON_IDINTEGER NOT NULLThe reason for the item to be returned.
REFUNDORREPLACECHAR (3) NOT NULLSpecifies 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.
CREDITAMOUNTDECIMAL (20,5) NOT NULL DEFAULT 0The amount of the credit for this item in the currency specified by CURRENCY. If this amount is NULL then the credit amount is unknown.
QUANTITYDOUBLE NOT NULLThe 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.
CREDITDATETIMESTAMPThe date that the credit was initiated.
STATUSCHAR (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.
CURRENCYCHAR (3) NOT NULLThe currency of the monetary amounts specified for this item. This is a currency code as per ISO 4217 standards.
COMMENTSVARCHAR (254)Comment that applies to the RMA item.
TAXAMOUNTDECIMAL (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.
ADJUSTMENTCREDITDECIMAL (20,5) NOT NULL DEFAULT 0The adjustment, from the original order, to be credited.
ADJUSTMENTDECIMAL (20,5) NOT NULL DEFAULT 0Any adjustment to be made to the credit amount by a Customer Service Representative.
LASTUPDATETIMESTAMPTimestamp of the last update.
TOTALCREDITDECIMAL (20,5) NOT NULL DEFAULT 0Total credit for the RMA Item.
INVQUANTITYINTEGER NOT NULL DEFAULT 0Quantity in inventory units.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RMAITEM_IDPrimary Key
I0000215RMA_ID+RMAITEM_IDNon-Unique Index
I0000747ITEMSPC_IDNon-Unique Index
I0000748MEMBER_IDNon-Unique Index
I0000749CATENTRY_IDNon-Unique Index
I0001282RTNREASON_IDNon-Unique Index
I837116ORDERITEMS_ID+RMAITEM_ID+STATUS+RMA_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_708CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_709MEMBER_IDMEMBERMEMBER_IDCascade
F_710ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_711ITEMSPC_IDITEMSPCITEMSPC_IDCascade
F_712RTNREASON_IDRTNREASONRTNREASON_IDCascade
F_713RMA_IDRMARMA_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3471RMAITEM_IDRMAITEMSERIALRMAITEM_IDCascade
F_703RMAITEM_IDRMACHARGERMAITEM_IDCascade
F_705RMAITEM_IDRMAIADJCRDRMAITEM_IDCascade
F_706RMAITEM_IDRMAIDNYRSNRMAITEM_IDCascade
F_716RMAITEM_IDRMAITEMCMPRMAITEM_IDCascade