ORDERMSG

Reserved for HCL internal use.

Column Descriptions:

NameTypeDescription
OMREFNUMINTEGER NOT NULLReserved for HCL internal use.
OMORNBRBIGINT NOT NULLReserved for HCL internal use.
OMRECNAMECHAR (10)Reserved for HCL internal use.
OMRECSEQINTEGERReserved for HCL internal use.
OMRECVALUEVARCHAR (3000)Reserved 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
I0000174OMRECNAME+OMORNBR+OMRECSEQUnique Index
I0000175OMREFNUMUnique Index
I0000651OMORNBRNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_512OMORNBRORDERSORDERS_IDCascade