WebSphere Commerce database table: RLDISCOUNT

This table defines the additional attributes of a promotion object for Blaze Rule Engine use.


Column Description(s):
Column NameColumn TypeDescription
PRIORITY INTEGER NOT NULL The value used to identify the promotion application sequence.
RULEXML CLOB The XML format of the discount presenation, which is used to generate Blaze Rules to evaluate the discounts for the order.
CALCODE_ID INTEGER NOT NULL The primary key of the calcode object.
TARGETSALES DECIMAL (20,5) The value of the target sales for each promotion. This value is used to generate the discount report.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031305820 CALCODE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_693 CALCODE_ID CALCODE CALCODE_ID Cascade

Feedback