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