CALRANGE

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

Column Descriptions:

NameTypeDescription
CALRANGE_IDINTEGER NOT NULLGenerated unique identifier.
CALSCALE_IDINTEGERThe CalculationScale of which this CalculationRange is a part.
CALMETHOD_IDINTEGER NOT NULLThe CalculationRangeMethod that determines a monetary amount from the CalculationRangeLookupResult. For example, FixedAmountCalculationRangeCmd, PerUnitAmountCalculationRangeCmd, or PercentageCalculationRangeCmd.
RANGESTARTDECIMAL (20,5)If a lookup number is greater than or equal to RANGESTART, or if RANGESTART is NULL, this row matches the lookup number.
CUMULATIVEINTEGER NOT NULL DEFAULT 0Valid 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.
FIELD1DECIMAL (20,5)Customizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CALRANGE_IDPrimary Key
I0000056CALSCALE_ID+RANGESTARTUnique Index
I0000503CALMETHOD_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_165CALSCALE_IDCALSCALECALSCALE_IDCascade
F_166CALMETHOD_IDCALMETHODCALMETHOD_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_168CALRANGE_IDCALRLOOKUPCALRANGE_IDCascade