This table is used to track return serial numbers.
Column Descriptions
| 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.
|