Skip to main content

%BI.CurrencyRate

persistent class %BI.CurrencyRate extends %Library.Persistent

SQL Table Name: %BI.CurrencyRate

Property Inventory

Properties

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

Storage

Storage Model: CacheStorage (%BI.CurrencyRate)

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