| itValidDateFrom | date | Valid From Date (query checks if ValidDateFrom > Valid From Date) |
| iiFromCurrencyId | integer | From Currency ID |
| iiToCurrencyId | integer | To Currency ID |
| iiExchangeRateTypeId | integer | Exchange RateType Id |
| iiCompanyId | integer | Company id |
| icFromCurrencyCode | character | |
| icToCurrencyCode | character | |
| icExchangeRateTypeCode | character | |
| iiSharedSetId | integer |
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 |
|---|---|---|---|
| tcCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
| tcCurrencyCode1 | character | Currency2.CurrencyCode | Currency Code |
| 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. |
| ttExchangeRateValidDateTill | date | ExchangeRate.ExchangeRateValidDateTill | Valid to: This field specify the date after which the exchange rate type becomes inactive. |
| api annotation: | When creating a new exchange rate type, the system proposes a default validity end date based on the value you entered in the Default Validity field in Exchange Rate Type Create for the exchange rate type. However, you can overwrite the default value. | ||
| tiFromCurrency_ID | integer | ExchangeRate.FromCurrency_ID | From Currency Code |
| tiSharedSet_ID | integer | ExchangeRate.SharedSet_ID | Link to SharedSet |
| tiToCurrency_ID | integer | ExchangeRate.ToCurrency_ID | To Currency Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(ExchangeRate),rowid(Currency1),rowid(Currency2),rowid(ExchangeRateType) |
QadFinancials