RMAIDNYRSN

A joint table which specifies reasons for denying a return merchandise authorization (RMA) item. Note: There is no similar table for rejecting an RMA. If you wish to reject an entire RMA, you must reject each RMA item individually.

Column Descriptions:

NameTypeDescription
RMAITEM_IDBIGINT NOT NULLThe ID of the RMA item.
RTNDNYRSN_IDINTEGER NOT NULLThe ID of the reason to deny authorization for the RMA.
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_ID+RTNDNYRSN_IDPrimary Key
I0001281RTNDNYRSN_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_706RMAITEM_IDRMAITEMRMAITEM_IDCascade
F_707RTNDNYRSN_IDRTNDNYRSNRTNDNYRSN_IDCascade