WebSphere Commerce database table: RTNREASON

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


Column Description(s):
Column NameColumn TypeDescription
REASONTYPE CHAR(1) NOT NULL DEFAULT 'B' The way in which the return reason may be used as follows:
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000221 CODE+STOREENT_ID Unique Index
SQL050212031308500 RTNREASON_ID Primary Key
I0000753 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_728 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback