WebSphere Commerce database table: CALRANGE

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000056 CALSCALE_ID+RANGESTART Unique Index
SQL050212031206500 CALRANGE_ID Primary Key
I0000503 CALMETHOD_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_166 CALMETHOD_ID CALMETHOD CALMETHOD_ID Cascade
F_165 CALSCALE_ID CALSCALE CALSCALE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_168 CALRANGE_ID CALRLOOKUP CALRANGE_ID Cascade

Feedback