WebSphere Commerce database table: RLDISCOUNT

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

Related reference

E-promotions data model

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.