CALRLOOKUP

Each row in this table represents a CalculationRangeLookupResult, which is part of a CalculationRange.

Column Descriptions:

NameTypeDescription
CALRLOOKUP_IDINTEGER NOT NULLGenerated unique identifier.
SETCCURRCHAR (3)If specified, this is the currency of the monetary amount in the VALUE column. This is a currency code as per ISO 4217 standards.
CALRANGE_IDINTEGER NOT NULLThe CalculationRange of which this CalculationRangeLookupResult is a part.
VALUEDECIMAL (20,5) NOT NULL DEFAULT 0The value of the CalculationRangeLookupResult, used by the CalculationRangeMethod of the CalculationRange to determine a monetary result.
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>CALRLOOKUP_IDPrimary Key
I0000057CALRANGE_ID+SETCCURRUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_167SETCCURRSETCURRSETCCURRCascade
F_168CALRANGE_IDCALRANGECALRANGE_IDCascade