ORDITPROMOCD

This contains promotion codes that were captured with an order for the order items in the order. This table is intended for customization and is not used by default implementation.

Column Descriptions:

NameTypeDescription
IDBIGINT NOT NULLThe primary key of the table.
ORDERITEMS_IDBIGINT NOT NULLForeign key to the ORDERITEMS table.
CODEVARCHAR (128) NOT NULLThe promotion code that is associated with the orderitem.
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>IDPrimary Key
I0000419ORDERITEMS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1077ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade