Currency

The currency math variable is used to define operations that convert a value from one currency to another using specific exchange markets and dates.

Currency math variable in Palette

Currency Math Variable in Palette

Important   Currency conversion only converts other math variables. A field needs to be mapped to a math variable before it can convert to another currency.

Define the Currency Math Variable

Drag and drop the Currency math variable from the Palette window onto the Math Pane. Enter the following information for the math variable.

  • Type a name in the Name field. This is required.

  • Make sure data type is defined as Currency. This is required.

  • Make sure variable type is defined as Currency. This is required.

  • Select Yes or No from Log field. Default is No. This is an optional field.

  • Make sure the operation is defined as Convert. This is required.

  • Type the currency code that the currency is coming from in the From Currency field. Currency codes are listed in the Currency editor in Admin Explorer. This is required only if the value is not already defined as a currency.

  • Type the currency code that the currency should be converted to in the To Currency field. Currency codes are listed in the Currency editor in Admin Explorer. This is required.

  • Type a Market Maker code in the Market Maker field to identify the Market Maker to use during conversion. Market Maker codes are listed in the Market Maker editor in Admin Explorer. This is required.

  • Type the date the system will use for the currency conversion calculation in the Exchange Date field. This is optional.

    Important   If the exchange date is specified, rates must exist for that date or the exchange cannot process. If the exchange date is not specified, the system will use the exchange rates available as of the current system date when the activity processes.
  • Enter the value of the math variable. This is required.

Check-in the transaction to save the information to the database.