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 Description(s):
Column Name | Column Type | Description |
RTNRECEIPT_ID |
BIGINT NOT NULL |
Generated unique key. |
RMA_ID |
BIGINT NOT NULL |
The RMA that to which this return receipt belongs. |
VERSIONSPC_ID |
BIGINT NOT NULL |
Reserved for IBM internal use. |
RMAITEMCMP_ID |
BIGINT NOT NULL |
The RMA item component to which this return receipt refers. |
LASTUPDATE |
TIMESTAMP NOT NULL |
The timestamp at which this record was last changed. |
QUANTITY |
INTEGER NOT NULL |
Quantity in inventory units. |
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. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031308700 |
RTNRECEIPT_ID |
Primary Key |
I0000222 |
RMAITEMCMP_ID+RTNRECEIPT_ID+DATERECEIVED |
Non-Unique Index |
I0000754 |
VERSIONSPC_ID |
Non-Unique Index |
I0000755 |
RMA_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_730 |
RMA_ID |
RMA |
RMA_ID |
Cascade |
F_731 |
RMAITEMCMP_ID |
RMAITEMCMP |
RMAITEMCMP_ID |
Cascade |
F_729 |
VERSIONSPC_ID |
VERSIONSPC |
VERSIONSPC_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_727 |
RTNRECEIPT_ID |
RTNRCPTDSP |
RTNRECEIPT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.