PRELEMENTATTR

Each row of this table represents a price rule attribute. A price rule attribute is a name-value pair used for price rule evaluation at runtime. For example, the element of PriceList type may have an attribute with the name 'priceListId' and the value '10001'.

Column Descriptions:

NameTypeDescription
PRELEMENT_IDBIGINT NOT NULLGenerated Key
NAMEVARCHAR (64) NOT NULLThe name of the attribute.
VALUEVARCHAR (254) NOT NULLThe value of the attribute.
PROPERTIESVARCHAR (254)Properties for this attribute. For example, the type of the parameter is of String type.
SEQUENCEDOUBLEThe sequence of the attribute in which the data should be returned in the price rule element.
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>PRELEMENT_ID+NAME+VALUEPrimary Key
I0001348NAME+VALUENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3635PRELEMENT_IDPRELEMENTPRELEMENT_IDCascade