This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > %BI.CurrencyRate


persistent class %BI.CurrencyRate extends %Library.Persistent

SQL Table Name: %BI.CurrencyRate

Property Inventory (Including Private)

Properties (Including Private)

property CurrRate as %String (TRUNCATE = 1);
Property methods: CurrRateDisplayToLogical(), CurrRateGet(), CurrRateGetStored(), CurrRateIsValid(), CurrRateLogicalToDisplay(), CurrRateLogicalToOdbc(), CurrRateNormalize(), CurrRateSet()
property EffectDate as %String (TRUNCATE = 1) [ Required ];
Property methods: EffectDateDisplayToLogical(), EffectDateGet(), EffectDateGetStored(), EffectDateIsValid(), EffectDateLogicalToDisplay(), EffectDateLogicalToOdbc(), EffectDateNormalize(), EffectDateSet()
property FromCurr as %String (TRUNCATE = 1) [ Required ];
Property methods: FromCurrDisplayToLogical(), FromCurrGet(), FromCurrGetStored(), FromCurrIsValid(), FromCurrLogicalToDisplay(), FromCurrLogicalToOdbc(), FromCurrNormalize(), FromCurrSet()
property ToCurr as %String (TRUNCATE = 1) [ Required ];
Property methods: ToCurrDisplayToLogical(), ToCurrGet(), ToCurrGetStored(), ToCurrIsValid(), ToCurrLogicalToDisplay(), ToCurrLogicalToOdbc(), ToCurrNormalize(), ToCurrSet()


query All()
SQL Query:
SELECT %ID,CurrRate,EffectDate,FromCurr,ToCurr FROM CurrencyRate ORDER BY EffectDate DESC


index (currIndex on FromCurr,ToCurr,EffectDate) [IdKey, Type = key, Unique];
Index methods: currIndexCheck(), currIndexDelete(), currIndexExists(), currIndexOpen(), currIndexSQLCheckUnique(), currIndexSQLExists(), currIndexSQLFindPKeyByConstraint(), currIndexSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods (Including Private)


Storage Model: CacheStorage (%BI.CurrencyRate)

FeedbackOpens in a new window