RTNREASON

Reason for customer dissatisfaction with a product.

Column Descriptions:

Name	Type	Description
REASONTYPE	CHAR (1) NOT NULL DEFAULT 'B'	The way in which the return reason can 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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	RTNREASON_ID	Primary Key
I0000221	CODE+STOREENT_ID	Unique Index
I0000753	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_728	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	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 - receipt and disposition data model
Order management - RMAitem data model