This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.Opens in a new window

For information on migrating to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).

%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()

Queries

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

Indexes

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

Storage Model: CacheStorage (%BI.CurrencyRate)

^BI.CurrencyRateD(ID)
=
%%CLASSNAME
CurrRate
EffectDate
FromCurr
ToCurr
FeedbackOpens in a new window