WebSphere Commerce database table: ORDIMEEXTN

This table contains procurement system specific OrderItem information.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031245120 ORDERITEMS_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_524 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Feedback