This table contains procurement system specific order information.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031247110 |
ORDERS_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_532 |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.