Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDIMEEXTN
This table contains procurement system specific OrderItem information.
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 SQL100520030402330 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
_vcc_freeselect_bottom_