Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDMEEXTN
This table contains procurement system specific order information.
Column Name Column Type Description ORDERS_ID BIGINT NOT NULL Order reference number. Primary key. PAYLOADID VARCHAR(128) Unique identification generated by the procurement system to track the order request. BUYERORDERID CHAR(32) The order number defined by the system of the buying organization. ORDERTYPE CHAR(2) Code to designate whether the order is a blanket or stand alone order. Valid values are BK = blanket order or SA = stand alone order. REQUESTEDTIME TIMESTAMP This is the time the order was requested by the buying organization at the procurement system. REQUESTEDSHIPTIME TIMESTAMP Requested order ship time. COMMENTS1 VARCHAR(1024) Comments. COMMENTS2 VARCHAR(1024) Comments. 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 SQL100520030403520 ORDERS_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_532 ORDERS_ID ORDERS ORDERS_ID Cascade
Related reference
_vcc_freeselect_bottom_