BKORDITEM

Each row contains the expected ship date of a backordered OrderItem.

Column Descriptions:

NameTypeDescription
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem that is backordered.
DATEEXPECTEDTIMESTAMPExpected ship date for the backordered Item.
LASTUPDATETIMESTAMPTimestamp of the last update.
OPTCOUNTERSMALLINTThe 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_126ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade