This table describes how a returned item has been disposed.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031308350 |
RTNRCPTDSP_ID |
Primary Key |
I0000220 |
RTNRECEIPT_ID+RTNRCPTDSP_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.