WebSphere Commerce database table: RLDISCOUNT

Reference > Database > WebSphere Commerce database tables > R

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 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
SQL100520030423220 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

Related reference

E-promotions data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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.