Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RMAITEMSERIAL
This table is used to track return serial numbers.
Column Name Column Type Description RMAITEMSERIAL_ID BIGINT NOT NULL The generated RMA items serial number identifier. RMAITEM_ID BIGINT NOT NULL The identifier of the return item associated with this serial number. RMAITEMCMP_ID BIGINT The identifier of the component of a configured RMAITEM associated with this serial number. SERIALNUMBER VARCHAR(128) The string representation of the serial number. QUANTITY DOUBLE NOT NULL The quantity of the RMA item. RECEIVEDQUANTITY DOUBLE NOT NULL The received quantity of the RMA item. CREATION_TIMESTAMP TIMESTAMP NOT NULL Time when the confirmation was recorded. LASTUPDATE TIMESTAMP NOT NULL Time when last update. OPTCOUNTER SMALLINT IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030424570 RMAITEMSERIAL_ID Primary Key I0000976 RMAITEM_ID+RMAITEMCMP_ID Non-Unique Index I0000977 SERIALNUMBER Non-Unique Index I0001283 RMAITEMCMP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3471 RMAITEM_ID RMAITEM RMAITEM_ID Cascade F_3472 RMAITEMCMP_ID RMAITEMCMP RMAITEMCMP_ID Cascade _vcc_freeselect_bottom_