WebSphere Commerce database table: RTNRCPTDSP

This table describes how a returned item has been disposed.

Column Descriptions
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
SQL060903235246950 RTNRCPTDSP_ID Primary Key
I0000220 RTNRECEIPT_ID+RTNRCPTDSP_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