Each row of this table represents a
CalculationRange, which conceptually represents a row in a
CalculationScale.
Column Descriptions:
| Name | 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 HCL internal use. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | CALRANGE_ID | Primary Key |
| I0000056 | CALSCALE_ID+RANGESTART | Unique Index |
| I0000503 | CALMETHOD_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_165 | CALSCALE_ID | CALSCALE | CALSCALE_ID | Cascade |
| F_166 | CALMETHOD_ID | CALMETHOD | CALMETHOD_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_168 | CALRANGE_ID | CALRLOOKUP | CALRANGE_ID | Cascade |