WebSphere Commerce database table: RMASERIAL

Keeps serial numbers for products and components of a return. Serial numbers stored here must also be associated with the products being returned and must also be present in the order(s) associated with the same return.


Column Description(s):
Column NameColumn TypeDescription
SERIAL_ID BIGINT NOT NULL The generated serial number identifier.
RMA_ID BIGINT NOT NULL The identifier of the return associated with this serial number. This column stores the CMR relationship with the RMA table.
CATENTRY_ID BIGINT NOT NULL The identifier of the catalog entry associated with this serial number. This column stores the CMR relationship with the CATENTRY table.
SERIALNUMBER VARCHAR(128) NOT NULL The string representation of the serial number.
RECEIVED CHAR(1) A flag that tells if the product with the associated serial number has already been received from the customer.
'Y' means the product has already been received
'N' means the product has not been received yet
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031307050 SERIAL_ID Primary Key
I0000929 SERIALNUMBER Non-Unique Index
I0000930 RMA_ID+CATENTRY_ID Non-Unique Index
I0000952 CATENTRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1191 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_1193 RMA_ID RMA RMA_ID Cascade

Feedback