project QadFinancials > class BExchangeRate > business logic query ExchangeRateByCompany

Annotation

ExRateBySharedSet


Parameters


iiCompanyIdintegerCompany id


query condition


  each ExchangeRate where
ExchangeRate.SharedSet_Id = vi_EXCHANGERATE_sharedset(iiCompanyId) AND

      first Currency1 (inner-join) where
Currency1.Currency_ID = ExchangeRate.FromCurrency_ID AND

      first Currency2 (inner-join) where
Currency2.Currency_ID = ExchangeRate.ToCurrency_ID AND

      first ExchangeRateType (inner-join) where
ExchangeRateType.ExchangeRateType_ID = ExchangeRate.ExchangeRateType_ID AND


query resultset tqExchangeRateByCompany


field namedata typedb fielddescription
tcCurrencyCodecharacterCurrency1.CurrencyCodeCurrency Code
tcCurrencyCode2characterCurrency2.CurrencyCodeCurrency Code
tcExchangeRateTypeCodecharacterExchangeRateType.ExchangeRateTypeCodeA code identifying an exchange rate type. A number of types are predefined and required by the system.


Internal usage


QadFinancials
method BSharedSet.ValidateComponent