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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000220 | RTNRECEIPT_ID, RTNRCPTDSP_ID | Non-Unique Index |
SQL030416035058310 | RTNRCPTDSP_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|