Keeps serial numbers for products and components of an order that has been shipped. Serial numbers stored here are retrieved from the Shipping Confirmation message sent by an external fulfillment center.
Column Description(s):
Column Name | Column Type | Description |
SERIAL_ID |
BIGINT NOT NULL |
The generated serial number identifier. |
ORDERS_ID |
BIGINT NOT NULL |
The identifier of the order associated with this serial number. This column stores the CMR relationship with the ORDERS 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. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031249990 |
SERIAL_ID |
Primary Key |
I0000949 |
SERIALNUMBER |
Non-Unique Index |
I0000950 |
ORDERS_ID+CATENTRY_ID |
Non-Unique Index |
I0000951 |
CATENTRY_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1189 |
CATENTRY_ID |
CATENTRY |
CATENTRY_ID |
Cascade |
F_1190 |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.