RTNDNYRSN

This table stores denial reasons for return merchandise authorization (RMA) items. These are the reasons for which an RMA item was not automatically approved by the system.

Column Descriptions:

NameTypeDescription
RTNDNYRSN_IDINTEGER NOT NULLGenerated unique key.
STOREENT_IDINTEGER NOT NULLStore Entity of the owner.
CODECHAR (10) NOT NULLCode used to reference the denial reason across stores.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this denial reason has been marked for deletion: 0 = No. 1 = Yes, this denial reason has been marked for deletion.
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>RTNDNYRSN_IDPrimary Key
I0000218STOREENT_ID+CODEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_721STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_707RTNDNYRSN_IDRMAIDNYRSNRTNDNYRSN_IDCascade
F_720RTNDNYRSN_IDRTNDNYDESCRTNDNYRSN_IDCascade