WebSphere Commerce database table: ORDMEEXTN

This table contains procurement system specific order information.

Column Descriptions
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 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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235222050 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