| itValidDateFrom | date | Valid Date From |
| iiFromCurrencyId | integer | From Currency ID |
| iiToCurrencyId | integer | To Currency ID |
| iiExchangeRateTypeId | integer | Exchange Rate Type Id |
| iiExchangeRateId | integer | |
| iiCompanyId | integer | Company id |
| icFromCurrencyCode | character | |
| icToCurrencyCode | character | |
| icExchangeRateTypeCode | character |
each ExchangeRate where
first Currency1 (inner-join) where
first Currency2 (inner-join) where
first ExchangeRateType (inner-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tdExchangeRate | decimal | ExchangeRate.ExchangeRate | Exchange Rate: This number is specified as the amount by which you multiply a single unit of a From Currency to reach the equivalent number of the To Currency units. |
| tiExchangeRate_ID | integer | ExchangeRate.ExchangeRate_ID | id |
| tdExchangeRateScale | decimal | ExchangeRate.ExchangeRateScale | Scale Factor: A number used in the exchange rate calculation to adjust the amount of the From Currency. Typically used in hyperinflationary environments when the differences between currency values is large. |
| api annotation: | Value for this field defaults to 1.0000000 . | ||
| tiExchangeRateType_ID | integer | ExchangeRate.ExchangeRateType_ID | Exchange Rate Type |
| tcExchangeRateTypeCode | character | ExchangeRateType.ExchangeRateTypeCode | A code identifying an exchange rate type. A number of types are predefined and required by the system. |
| ttExchangeRateValidDateFrom | date | ExchangeRate.ExchangeRateValidDateFrom | Valid from: The start date of the currency exchange relationship. The effective period of an entry cannot overlap with another entry for the same relationship. |
| tiFromCurrency_ID | integer | ExchangeRate.FromCurrency_ID | From Currency Code |
| tcFromCurrencyCode | character | Currency2.CurrencyCode | Currency Code |
| tiSharedSet_ID | integer | ExchangeRate.SharedSet_ID | Link to SharedSet |
| tiToCurrency_ID | integer | ExchangeRate.ToCurrency_ID | To Currency Code |
| tcToCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(ExchangeRate),rowid(Currency1),rowid(Currency2),rowid(ExchangeRateType) |
QadFinancials