RTNREASON

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

Column Descriptions:

NameTypeDescription
REASONTYPECHAR (1) NOT NULL DEFAULT 'B'The way in which the return reason can be used: C = customer M = merchant or disposition B = both
RTNREASON_IDINTEGER NOT NULLGenerated unique key.
STOREENT_IDINTEGER NOT NULLThe StoreEntity in which the return reason is used.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this return reason has been marked for deletion: 0 = No. 1 = Yes, this return reason has been marked for deletion.
CODECHAR (30) NOT NULLCode used to reference the return reason.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RTNREASON_IDPrimary Key
I0000221CODE+STOREENT_IDUnique Index
I0000753STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_728STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_712RTNREASON_IDRMAITEMRTNREASON_IDCascade
F_726RTNREASON_IDRTNRCPTDSPRTNREASON_IDCascade
F_733RTNREASON_IDRTNRSNDESCRTNREASON_IDCascade