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