WebSphere Commerce database table: RTNDSPCODE

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


Column Description(s):
Column NameColumn TypeDescription
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, as follows:
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000219 CODE+STOREENT_ID Unique Index
SQL050212031308060 RTNDSPCODE_ID Primary Key
I0000752 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_722 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_724 RTNDSPCODE_ID RTNDSPDESC RTNDSPCODE_ID Cascade
F_725 RTNDSPCODE_ID RTNRCPTDSP RTNDSPCODE_ID Cascade

Feedback