WebSphere Commerce database table: ORDMEEXTN

This table contains procurement system specific order information.


Column Description(s):
Column NameColumn TypeDescription
ORDERS_ID BIGINT NOT NULL Order reference number. Primary key.
PAYLOADID VARCHAR(128) Unique identification generated by the procurement system like Ariba 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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031247110 ORDERS_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_532 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback