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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035021500 | ORDERS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_532 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|