Reference > Database > WebSphere Commerce database tables > B


WebSphere Commerce database table: BKORDITEM

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

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
SQL100520030303330 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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search