Database Table: 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 Name Column Type Column Description
CODE CHARACTER (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.
RTNDNYRSN_ID INTEGER
NOT NULL
Generated unique key.
STOREENT_ID INTEGER
NOT NULL
Store Entity of the owner.
Indexes:
Index Name Indexed Column Names Index Type
I0000218 STOREENT_ID, CODE Unique Index
SQL030416035057350 RTNDNYRSN_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_721 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_707 RTNDNYRSN_ID RMAIDNYRSN RTNDNYRSN_ID Cascade
F_720 RTNDNYRSN_ID RTNDNYDESC RTNDNYRSN_ID Cascade