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.
|