This table stores the receipt record that indicates that a returned item, from a return merchandise authorization (RMAA), has been received and specifies information about the received items.
Column Name | Column Type | Column Description |
---|---|---|
DATERECEIVED | TIMESTAMP NOT NULL |
Date that the returned item was received. |
DISPOSITIONEDQTY | INTEGER NOT NULL, DEFAULT 0 |
The quantity of this return receipt that has been disposed. |
LASTUPDATE | TIMESTAMP NOT NULL |
The timestamp at which this record was last changed. |
QUANTITY | INTEGER NOT NULL |
Quantity in inventory units. |
RMAITEMCMP_ID | BIGINT NOT NULL |
The RMA item component to which this return receipt refers. |
RMA_ID | BIGINT NOT NULL |
The RMA that to which this return receipt belongs. |
RTNRECEIPT_ID | BIGINT NOT NULL |
Generated unique key. |
VERSIONSPC_ID | BIGINT NOT NULL |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000222 | RMAITEMCMP_ID, RTNRECEIPT_ID, DATERECEIVED | Non-Unique Index |
SQL030416035059030 | RTNRECEIPT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_729 | VERSIONSPC_ID | VERSIONSPC | VERSIONSPC_ID | Cascade |
F_730 | RMA_ID | RMA | RMA_ID | Cascade |
F_731 | RMAITEMCMP_ID | RMAITEMCMP | RMAITEMCMP_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_727 | RTNRECEIPT_ID | RTNRCPTDSP | RTNRECEIPT_ID | Cascade |