currencyConversion

• Functionality

  This function will return the currency conversion rate for a conversion on a date.

• Arguments

  The function is available with several arguments:

  • currencyConversion(String aCurrencyFrom, String aCurrencyTo, Date aValidFrom)

    This funtion has as the first argument a currency and as the second argument the currency to which it will be converted. The third argument is the date for which the currency rate is valid. If the value of aCurrencyTo is not defined, then base currency is used.

  • currencyConversion(String aCurrencyFrom, Date aValidFrom)

    This funtion has as its first argument a currency. The second argument is the date for which the currency rate is valid. The currency to which it will be converted is the currency that is globally defined in Valuemation. This global currency can be found in the AMT_MAINPARAM .

  • currencyConversion(String aCurrencyFrom, String aCurrencyTo)

    This funtion has as its first argument a currency and as the second argument the currency to which it will be converted. The date for the rate will be the actual system date. If the value of aCurrencyTo is not defined the base currency is used.

  • currencyConversion(String aCurrencyFrom)

    This funtion has as first argument a currency. The currency to which it will be converted is the currency that is globally defined in Valuemation. This global currency can be found in the AMT_MAINPARAM. The date for the rate will be the actual system date.

• Return

  The currency conversion rate as a double value.

• Conditions

  The table AMT_CURCONV must be available. Here the currency conversions are stored.

• Examples

  currencyConversion('USD','EUR')

  currencyConversion(currencyFrom,currencyTo,validfrom) --> currencyFrom,currencyTo,validfrom are attributes from a BO