WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000218 STOREENT_ID+CODE Unique Index
SQL050212031307900 RTNDNYRSN_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_721 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_707 RTNDNYRSN_ID RMAIDNYRSN RTNDNYRSN_ID Cascade
F_720 RTNDNYRSN_ID RTNDNYDESC RTNDNYRSN_ID Cascade

Feedback