WebSphere Commerce database table: CALRANGE

Each row of this table represents a CalculationRange, which conceptually represents a row in a CalculationScale.

Column Descriptions
Column Name Column Type Description
CALRANGE_ID INTEGER NOT NULL Generated unique identifier.
CALSCALE_ID INTEGER The CalculationScale of which this CalculationRange is a part.
CALMETHOD_ID INTEGER NOT NULL The CalculationRangeMethod that determines a monetary amount from the CalculationRangeLookupResult. For example, FixedAmountCalculationRangeCmd, PerUnitAmountCalculationRangeCmd, or PercentageCalculationRangeCmd.
RANGESTART DECIMAL (20,5) If a lookup number is greater than or equal to RANGESTART, or if RANGESTART is NULL, this row matches the lookup number.
CUMULATIVE INTEGER NOT NULL DEFAULT 0 Valid values:
0 = only the matching CalculationRange with the highest RANGESTART value is used.
1 = all matching CalculationRanges are used. The calculated monetary amounts are summed to arrive at the final result.
FIELD1 DECIMAL (20,5) Customizable.
FIELD2 DECIMAL (20,5) Customizable.
FIELD3 VARCHAR(254) Customizable.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000056 CALSCALE_ID+RANGESTART Unique Index
SQL060903235135450 CALRANGE_ID Primary Key
I0000503 CALMETHOD_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_166 CALMETHOD_ID CALMETHOD CALMETHOD_ID Cascade
F_165 CALSCALE_ID CALSCALE CALSCALE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_168 CALRANGE_ID CALRLOOKUP CALRANGE_ID Cascade
Related reference