ORDEXTATTR

This table stores extended order attributes.

Column Descriptions:

NameTypeDescription
ORDEXTATTR_IDBIGINT NOT NULLGenerated unique key.
ORDERS_IDBIGINT NOT NULLThe order to which this attribute belongs.
NAMEVARCHAR (512) NOT NULLThe name of this attribute.
VALUEVARCHAR (4000) NOT NULLThe value of this attribute.
TYPEVARCHAR (16)The type of this attribute. This optional column is reserved for extension purpose, and it can represent data type or data usage.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
P_0037ORDEXTATTR_IDPrimary Key
I0001531NAMENon-Unique Index
I0001532ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3777ORDERS_IDORDERSORDERS_IDCascade