Database Table: RTNRCPTDSP

This table describes how a returned item has been disposed.

Column Name Column Type Column Description
COMMENTS VARCHAR (254)
NULL
Comments for the disposition.
DISPOSITIONDATE TIMESTAMP
NOT NULL
The timestamp at which the item was disposed.
QUANTITY INTEGER
NOT NULL
Quantity in inventory units.
RTNDSPCODE_ID INTEGER
NOT NULL
Disposition code describing how the item was disposed.
RTNRCPTDSP_ID BIGINT
NOT NULL
Generated unique key.
RTNREASON_ID INTEGER
NULL
The reason for the disposition.
RTNRECEIPT_ID BIGINT
NOT NULL
The return receipt to which this disposition record refers.
Indexes:
Index Name Indexed Column Names Index Type
I0000220 RTNRECEIPT_ID, RTNRCPTDSP_ID Non-Unique Index
SQL030416035058310 RTNRCPTDSP_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable