Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RTNRECEIPT
This table stores the receipt record that indicates that a returned item, from a return merchandise authorization (RMAA). This returned item has been received and specifies information about the received items.
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.
Indexes Index Name Indexed Column Names Index Type SQL100520030426150 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_730 RMA_ID RMA RMA_ID Cascade F_731 RMAITEMCMP_ID RMAITEMCMP RMAITEMCMP_ID Cascade F_729 VERSIONSPC_ID VERSIONSPC VERSIONSPC_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
Related reference
- Order management - RMA data model
- Order management - RMAitem data model
- Order management - receipt and disposition data model
_vcc_freeselect_bottom_