Reference > Database > WebSphere Commerce database tables > R

WebSphere Commerce database table: RTNREASON

This table stores the reason for customer dissatisfaction with a product.

Column Name	Column Type	Description
REASONTYPE	CHAR(1) NOT NULL DEFAULT 'B'	The way in which the return reason may be used... C = customer M = merchant or disposition B = both
RTNREASON_ID	INTEGER NOT NULL	Generated unique key.
STOREENT_ID	INTEGER NOT NULL	The StoreEntity in which the return reason is used.
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	Indicates if this return reason has been marked for deletion: 0 = No. 1 = Yes, this return reason has been marked for deletion.
CODE	CHAR(30) NOT NULL	Code used to reference the return reason.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000221	CODE+STOREENT_ID	Unique Index
SQL100520030426010	RTNREASON_ID	Primary Key
I0000753	STOREENT_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_728	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_712	RTNREASON_ID	RMAITEM	RTNREASON_ID	Cascade
F_726	RTNREASON_ID	RTNRCPTDSP	RTNREASON_ID	Cascade
F_733	RTNREASON_ID	RTNRSNDESC	RTNREASON_ID	Cascade

Related reference

• Order management - RMAitem data model

• Order management - receipt and disposition data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search