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 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 Name | Indexed Column Names | Index Type |
---|---|---|
I0000221 | CODE+STOREENT_ID | Unique Index |
SQL050212031308500 | RTNREASON_ID | Primary Key |
I0000753 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_728 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign 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 |