Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: 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, reject each RMA item individually.
Column Name Column Type Description RMAITEM_ID BIGINT NOT NULL The ID of the RMA item. RTNDNYRSN_ID INTEGER NOT NULL The ID of the reason to deny authorization for the RMA. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030424000 RMAITEM_ID+RTNDNYRSN_ID Primary Key I0001281 RTNDNYRSN_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_706 RMAITEM_ID RMAITEM RMAITEM_ID Cascade F_707 RTNDNYRSN_ID RTNDNYRSN RTNDNYRSN_ID Cascade
Related reference
_vcc_freeselect_bottom_