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:

NameTypeDescription
RTNRECEIPT_IDBIGINT NOT NULLGenerated unique key.
RMA_IDBIGINT NOT NULLThe RMA that to which this return receipt belongs.
VERSIONSPC_IDBIGINT NOT NULLReserved for IBM internal use.
RMAITEMCMP_IDBIGINT NOT NULLThe RMA item component to which this return receipt refers.
LASTUPDATETIMESTAMP NOT NULLThe timestamp at which this record was last changed.
QUANTITYINTEGER NOT NULLQuantity in inventory units.
DATERECEIVEDTIMESTAMP NOT NULLDate that the returned item was received.
DISPOSITIONEDQTYINTEGER NOT NULL DEFAULT 0The quantity of this return receipt that has been disposed.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RTNRECEIPT_IDPrimary Key
I0000222RMAITEMCMP_ID+RTNRECEIPT_ID+DATERECEIVEDNon-Unique Index
I0000754VERSIONSPC_IDNon-Unique Index
I0000755RMA_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_729VERSIONSPC_IDVERSIONSPCVERSIONSPC_IDCascade
F_730RMA_IDRMARMA_IDCascade
F_731RMAITEMCMP_IDRMAITEMCMPRMAITEMCMP_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_727RTNRECEIPT_IDRTNRCPTDSPRTNRECEIPT_IDCascade