This table stores the reason for customer dissatisfaction with a product.
Column Descriptions
| 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.
|