Database Table: CALRANGE

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

Column Name Column Type Column Description
CALMETHOD_ID INTEGER
NOT NULL
The CalculationRangeMethod that determines a monetary amount from the CalculationRangeLookupResult. For example, FixedAmountCalculationRangeCmd, PerUnitAmountCalculationRangeCmd, or PercentageCalculationRangeCmd.
CALRANGE_ID INTEGER
NOT NULL
Generated unique identifier.
CALSCALE_ID INTEGER
NULL
The CalculationScale of which this CalculationRange is a part.
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)
NULL
Customizable.
FIELD2 DECIMAL (20,5)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
RANGESTART DECIMAL (20,5)
NULL
If a lookup number is greater than or equal to RANGESTART, or if RANGESTART is NULL, this row matches the lookup number.
Indexes:
Index Name Indexed Column Names Index Type
I0000056 CALSCALE_ID, RANGESTART Unique Index
SQL030416034851860 CALRANGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_165 CALSCALE_ID CALSCALE CALSCALE_ID Cascade
F_166 CALMETHOD_ID CALMETHOD CALMETHOD_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