WebSphere Commerce database table: RTNRCPTDSP

This table describes how a returned item has been disposed.


Column Description(s):
Column NameColumn TypeDescription
RTNDSPCODE_ID INTEGER NOT NULL Disposition code describing how the item was disposed.
RTNRECEIPT_ID BIGINT NOT NULL The return receipt to which this disposition record refers.
RTNRCPTDSP_ID BIGINT NOT NULL Generated unique key.
RTNREASON_ID INTEGER The reason for the disposition.
QUANTITY INTEGER NOT NULL Quantity in inventory units.
DISPOSITIONDATE TIMESTAMP NOT NULL The timestamp at which the item was disposed.
COMMENTS VARCHAR(254) Comments for the disposition.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031308350 RTNRCPTDSP_ID Primary Key
I0000220 RTNRECEIPT_ID+RTNRCPTDSP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_725 RTNDSPCODE_ID RTNDSPCODE RTNDSPCODE_ID Cascade
F_726 RTNREASON_ID RTNREASON RTNREASON_ID Cascade
F_727 RTNRECEIPT_ID RTNRECEIPT RTNRECEIPT_ID Cascade

Feedback