WebSphere Commerce database table: RTNDNYDESC

RTNDNYDESC

This table stores the language-dependent descriptions of the reasons for denying return merchandise authorizations (RMAs).

Column Descriptions:

Name Type Description
RTNDNYRSN_ID INTEGER NOT NULL The ID of the denial reason for which this description belongs.
LANGUAGE_ID INTEGER NOT NULL The ID of the language used for the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR (384) NOT NULL Description of the denial reason in the language specified by LANGUAGE_ID.
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+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_719 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_720 RTNDNYRSN_ID RTNDNYRSN RTNDNYRSN_ID Cascade

Related reference
Order management - RMAitem data model

Name	Type	Description
RTNDNYRSN_ID	INTEGER NOT NULL	The ID of the denial reason for which this description belongs.
LANGUAGE_ID	INTEGER NOT NULL	The ID of the language used for the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION	VARCHAR (384) NOT NULL	Description of the denial reason in the language specified by LANGUAGE_ID.
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.

Constraint	Columns	Parent Table	Parent Columns	Type
F_719	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_720	RTNDNYRSN_ID	RTNDNYRSN	RTNDNYRSN_ID	Cascade