Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RTNDNYRSN
This table stores denial reasons for return merchandise authorization (RMA) items. These are the reasons for which an RMA item was not automatically approved by the system.
Column Name Column Type Description RTNDNYRSN_ID INTEGER NOT NULL Generated unique key. STOREENT_ID INTEGER NOT NULL Store Entity of the owner. CODE CHAR(10) NOT NULL Code used to reference the denial reason across stores. MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if this denial reason has been marked for deletion:
0 = No.
1 = Yes, this denial reason has been marked for deletion.OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000218 STOREENT_ID+CODE Unique Index SQL100520030425420 RTNDNYRSN_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_721 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_707 RTNDNYRSN_ID RMAIDNYRSN RTNDNYRSN_ID Cascade F_720 RTNDNYRSN_ID RTNDNYDESC RTNDNYRSN_ID Cascade
Related reference
_vcc_freeselect_bottom_