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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000056 | CALSCALE_ID, RANGESTART | Unique Index |
SQL030416034851860 | CALRANGE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_168 | CALRANGE_ID | CALRLOOKUP | CALRANGE_ID | Cascade |