Database Table: RTNREASON

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

Column Name Column Type Column Description
CODE CHARACTER (30)
NOT NULL
Code used to reference the return reason.
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.
REASONTYPE CHARACTER (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.
Indexes:
Index Name Indexed Column Names Index Type
I0000221 CODE, STOREENT_ID Unique Index
SQL030416035058710 RTNREASON_ID Primary Key
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