This table describes how a returned item has been
disposed.
Column Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | RTNRCPTDSP_ID | Primary Key |
| I0000220 | RTNRECEIPT_ID+RTNRCPTDSP_ID | Non-Unique Index |
| I0001285 | RTNDSPCODE_ID | Non-Unique Index |
| I0001286 | RTNREASON_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 |