Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RTNRCPTDSP
This table describes how a returned item has been disposed.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030425830 RTNRCPTDSP_ID Primary Key I0000220 RTNRECEIPT_ID+RTNRCPTDSP_ID Non-Unique Index I0001285 RTNDSPCODE_ID Non-Unique Index I0001286 RTNREASON_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference
_vcc_freeselect_bottom_