This table contains procurement system specific OrderItem information.
Column Name | Column Type | Description |
---|---|---|
ORDERITEMS_ID | BIGINT NOT NULL | Foreign key to the ORDERITEMS table and the primary key. |
REQUESTEDSHIPTIME | TIMESTAMP | Requested order item ship time. |
SHIPASCOMPLETE | CHAR(1) | Whether partial shipment of the item will be accepted: N = ship partial. Y = ship complete. |
COMMENTS1 | VARCHAR(1024) | Comment. |
COMMENTS2 | VARCHAR(1024) | Comment. |
FIELD1 | VARCHAR(64) | Customizable. |
FIELD2 | VARCHAR(64) | Customizable. |
FIELD3 | VARCHAR(64) | Customizable. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031245120 | ORDERITEMS_ID | Primary Key |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_524 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |