RTNRCPTDSP

This table describes how a returned item has been disposed.

Column Descriptions:

NameTypeDescription
RTNDSPCODE_IDINTEGER NOT NULLDisposition code describing how the item was disposed.
RTNRECEIPT_IDBIGINT NOT NULLThe return receipt to which this disposition record refers.
RTNRCPTDSP_IDBIGINT NOT NULLGenerated unique key.
RTNREASON_IDINTEGERThe reason for the disposition.
QUANTITYINTEGER NOT NULLQuantity in inventory units.
DISPOSITIONDATETIMESTAMP NOT NULLThe timestamp at which the item was disposed.
COMMENTSVARCHAR (254)Comments for the disposition.
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>RTNRCPTDSP_IDPrimary Key
I0000220RTNRECEIPT_ID+RTNRCPTDSP_IDNon-Unique Index
I0001285RTNDSPCODE_IDNon-Unique Index
I0001286RTNREASON_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_725RTNDSPCODE_IDRTNDSPCODERTNDSPCODE_IDCascade
F_726RTNREASON_IDRTNREASONRTNREASON_IDCascade
F_727RTNRECEIPT_IDRTNRECEIPTRTNRECEIPT_IDCascade