WebSphere Commerce database table: ORDSERIAL

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 NameColumn TypeDescription
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 NameIndexed Column NamesIndex 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 NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1189 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_1190 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback