WebSphere Commerce database table: BKORDITEM

Each row contains the expected ship date of a backordered OrderItem.

Column Descriptions
Column Name Column Type Description
ORDERITEMS_ID BIGINT NOT NULL The OrderItem that is backordered.
DATEEXPECTED TIMESTAMP Expected ship date for the backordered Item.
LASTUPDATE TIMESTAMP Timestamp of the last update.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235130960 ORDERITEMS_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_126 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
Related reference