Database Table: ORDMEEXTN

This table contains procurement system specific order information.

Column Name Column Type Column Description
BUYERORDERID CHARACTER (32)
NULL
The order number defined by the system of the buying organization.
COMMENTS1 VARCHAR (1024)
NULL
Comments.
COMMENTS2 VARCHAR (1024)
NULL
Comments.
FIELD1 VARCHAR (64)
NULL
Customizable.
FIELD2 VARCHAR (64)
NULL
Customizable.
FIELD3 VARCHAR (64)
NULL
Customizable.
ORDERS_ID BIGINT
NOT NULL
Order reference number. Primary key.
ORDERTYPE CHARACTER (2)
NULL
Code to designate whether the order is a blanket or stand alone order. Valid values are BK = blanket order or SA = stand alone order.
PAYLOADID VARCHAR (128)
NULL
Unique identification generated by the procurement system like Ariba to track the order request.
REQUESTEDSHIPTIME TIMESTAMP
NULL
Requested order ship time.
REQUESTEDTIME TIMESTAMP
NULL
This is the time the order was requested by the buying organization at the procurement system.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035021500 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable