ORDIMEEXTN

This table contains procurement system specific OrderItem information.

Column Descriptions:

NameTypeDescription
ORDERITEMS_IDBIGINT NOT NULLForeign key to the ORDERITEMS table and the primary key.
REQUESTEDSHIPTIMETIMESTAMPRequested order item ship time.
SHIPASCOMPLETECHAR (1)Whether partial shipment of the item will be accepted: N = ship partial. Y = ship complete.
COMMENTS1VARCHAR (1024)Comment.
COMMENTS2VARCHAR (1024)Comment.
FIELD1VARCHAR (64)Customizable.
FIELD2VARCHAR (64)Customizable.
FIELD3VARCHAR (64)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERITEMS_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_524ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade