Each row of this table represents a CalculationRange, which conceptually represents a row in a CalculationScale.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000056 |
CALSCALE_ID+RANGESTART |
Unique Index |
SQL050212031206500 |
CALRANGE_ID |
Primary Key |
I0000503 |
CALMETHOD_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 Name(s) | Constraint Type |
F_168 |
CALRANGE_ID |
CALRLOOKUP |
CALRANGE_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.