Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CALRANGE
Each row of this table represents a CalculationRange, which conceptually represents a row in a CalculationScale.
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 SQL100520030308130 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_168 CALRANGE_ID CALRLOOKUP CALRANGE_ID Cascade
Related reference
_vcc_freeselect_bottom_