CALRLOOKUP

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

Column Descriptions:

Name	Type	Description
CALRLOOKUP_ID	INTEGER NOT NULL	Generated unique identifier.
SETCCURR	CHAR (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_ID	INTEGER NOT NULL	The CalculationRange of which this CalculationRangeLookupResult is a part.
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.
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>	CALRLOOKUP_ID	Primary Key
I0000057	CALRANGE_ID+SETCCURR	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_167	SETCCURR	SETCURR	SETCCURR	Cascade
F_168	CALRANGE_ID	CALRANGE	CALRANGE_ID	Cascade

Related reference
Calculation scale data model