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:

Name	Type	Description
RTNDNYRSN_ID	INTEGER NOT NULL	Generated unique key.
STOREENT_ID	INTEGER NOT NULL	Store Entity of the owner.
CODE	CHAR (10) NOT NULL	Code used to reference the denial reason across stores.
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	Indicates if this denial reason has been marked for deletion: 0 = No. 1 = Yes, this denial reason has been marked for deletion.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	RTNDNYRSN_ID	Primary Key
I0000218	STOREENT_ID+CODE	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_721	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_707	RTNDNYRSN_ID	RMAIDNYRSN	RTNDNYRSN_ID	Cascade
F_720	RTNDNYRSN_ID	RTNDNYDESC	RTNDNYRSN_ID	Cascade

Related reference
Order management - RMAitem data model