project QadFinancials > class BExchangeRate > business logic query ExchangeRateByCompany
Annotation
ExRateBySharedSet
Parameters
| iiCompanyId | integer | Company 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 name | data type | db field | description |
|---|
| tcCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
| tcCurrencyCode2 | character | Currency2.CurrencyCode | Currency Code |
| tcExchangeRateTypeCode | character | ExchangeRateType.ExchangeRateTypeCode | A code identifying an exchange rate type. A number of types are predefined and required by the system. |
Internal usage
QadFinancials