Database Table: CALRLOOKUP

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

Column Name Column Type Column Description
CALRANGE_ID INTEGER
NOT NULL
The CalculationRange of which this CalculationRangeLookupResult is a part.
CALRLOOKUP_ID INTEGER
NOT NULL
Generated unique identifier.
SETCCURR CHARACTER (3)
NULL
If specified, this is the currency of the monetary amount in the VALUE column. This is a currency code as per ISO 4217 standards.
VALUE DECIMAL (20,5)
NOT NULL, DEFAULT 0
The value of the CalculationRangeLookupResult, used by the CalculationRangeMethod of the CalculationRange to determine a monetary result.
Indexes:
Index Name Indexed Column Names Index Type
I0000057 CALRANGE_ID, SETCCURR Unique Index
SQL030416034852160 CALRLOOKUP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_167 SETCCURR SETCURR SETCCURR Cascade
F_168 CALRANGE_ID CALRANGE CALRANGE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable