Database Table: RTNRECEIPT

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000222 RMAITEMCMP_ID, RTNRECEIPT_ID, DATERECEIVED Non-Unique Index
SQL030416035059030 RTNRECEIPT_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_727 RTNRECEIPT_ID RTNRCPTDSP RTNRECEIPT_ID Cascade