Database Table: ORDIMEEXTN

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035019390 ORDERITEMS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_524 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable