RTNRECEIPT

This table stores the receipt record that indicates a returned item from a return merchandise authorization ( RMA). This returned item specifies that the item has been received. It also has information about the received items.

Column Descriptions:

Name	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	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>	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

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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 Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_727	RTNRECEIPT_ID	RTNRCPTDSP	RTNRECEIPT_ID	Cascade