WebSphere Commerce database table: RMAIDNYRSN

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031306610 RMAITEM_ID+RTNDNYRSN_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_706 RMAITEM_ID RMAITEM RMAITEM_ID Cascade
F_707 RTNDNYRSN_ID RTNDNYRSN RTNDNYRSN_ID Cascade

Feedback