ORDIPROF

Reserved for HCL internal use.

Column Descriptions:

NameTypeDescription
ORDERITEMS_IDBIGINT NOT NULLReserved for HCL internal use.
PROFILENAMEVARCHAR (64) NOT NULLReserved for HCL internal use.
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_ID+PROFILENAMEPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_527ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade