This table stores the receipt record that indicates that a returned item, from a return merchandise authorization. This returned item has been received and specifies information about the received items.
Column Descriptions
| 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.
|