Reference > Database > WebSphere Commerce database tables > R

WebSphere Commerce database table: RTNDSPCODE

This table stores return disposition codes to describe how a received item is disposed.

Column Name	Column Type	Description
RTNDSPCODE_ID	INTEGER NOT NULL	Generated unique key.
RETURNTOINVENTORY	CHAR(1) NOT NULL DEFAULT 'Y'	A flag to decide if an item with this disposition code should be returned to inventory or not,... N = do not return to inventory Y = return to inventory
STOREENT_ID	INTEGER NOT NULL	Store Entity of the owner.
CODE	CHAR(10) NOT NULL	Code used to reference the disposition code.
MARKFORDELETE	INTEGER NOT NULL DEFAULT 0	Indicates if this disposition code has been marked for deletion: 0 = No. 1 = Yes, this disposition code has been marked for deletion.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000219	CODE+STOREENT_ID	Unique Index
SQL100520030425560	RTNDSPCODE_ID	Primary Key
I0000752	STOREENT_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_722	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_724	RTNDSPCODE_ID	RTNDSPDESC	RTNDSPCODE_ID	Cascade
F_725	RTNDSPCODE_ID	RTNRCPTDSP	RTNDSPCODE_ID	Cascade

Related reference

• Order management - receipt and disposition data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search