ORDMEEXTN

This table contains procurement system specific order information.

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ORDERS_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_532	ORDERS_ID	ORDERS	ORDERS_ID	Cascade