| iiFromCurrencyId | integer | From Currency ID |
| iiToCurrencyId | integer | To Currency ID |
| iiExchangeRateTypeId | integer | Exchange Rate Type Id |
| itExchRateFromValidityDate | date | From Validity Date |
| icFromCurrencyCode | character | from currency code |
| icToCurrencyCode | character | To currency code |
| icExchangeRateType | character | |
| iiCompanyId | integer | Company id |
| itExchRateToValidityDate | date | To Validity Date |
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 |
| tcCurrencyCode2 | 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. |
| 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 . | ||
| 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. |
| tiExchangeRateType_ID | integer | ExchangeRate.ExchangeRateType_ID | Exchange Rate Type |
| 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. | ||
| tiExchangeRate_ID | integer | ExchangeRate.ExchangeRate_ID | id |
| tiFromCurrency_ID | integer | ExchangeRate.FromCurrency_ID | From Currency Code |
| tiToCurrency_ID | integer | ExchangeRate.ToCurrency_ID | To Currency Code |
QadFinancials