WebSphere Commerce database table: RLDISCOUNT
This table defines the additional attributes of a promotion object for Blaze Rule Engine use. This table is being deprecated and this implementation will be replaced by px_promotion related tables since 6.0.
Column Descriptions Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL060903235244200 CALCODE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_693 CALCODE_ID CALCODE CALCODE_ID Cascade