WebSphere Commerce database table: RMAIDNYRSN

A joint table which specifies reasons for denying a return merchandise authorization (RMA) item.

Column Descriptions
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
SQL060903235244970 RMAITEM_ID+RTNDNYRSN_ID Primary Key

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