WebSphere Commerce database table: ORDIMEEXTN

This table contains procurement system specific OrderItem information.

Column Descriptions
Column Name Column Type Description
ORDERITEMS_ID BIGINT NOT NULL Foreign key to the ORDERITEMS table and the primary key.
REQUESTEDSHIPTIME TIMESTAMP Requested order item ship time.
SHIPASCOMPLETE CHAR(1) Whether partial shipment of the item will be accepted:
N = ship partial.
Y = ship complete.
COMMENTS1 VARCHAR(1024) Comment.
COMMENTS2 VARCHAR(1024) Comment.
FIELD1 VARCHAR(64) Customizable.
FIELD2 VARCHAR(64) Customizable.
FIELD3 VARCHAR(64) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

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

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