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 Name | Column Type | Description |
---|---|---|
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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1191 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_1193 | RMA_ID | RMA | RMA_ID | Cascade |