You are here: Transaction Rules > Transaction Elements > Math Elements > CURRENCY

CURRENCY

Description

This type allows the conversion from one currency to another. It also provides the means to cast a DECIMAL variable value to a specific CURRENCY. The text of the MathVariable element must be a valid expression that results in a DECIMAL value. All operands used in the expression must be of a numeric type or a numeric literal. Expressions range from complex arithmetic expressions to a simple assignment of one value.    

TYPE =CURRENCY

Element

Attribute

Attribute Value

Element Value

<MathVariable>

TYPE

CURRENCY

OPERATION

CONVERT

FROMCURRENCY: the currency denomination an amount of money is being converted from. The value must be a three letter currency code.

TOCURRENCY: the currency denomination an amount of money is being converted to. The value must be a three letter currency code.

MARKETMAKER: the GUID for the MarketMaker that provides the exchange rates used for the currency conversion.

EXCHANGEDATE: (Optional) the effective date of the exchange rate to be used from the AsExchangeRate table. If not specified, the last known exchange rate is used.

VALUE: The amount

XML Example

<Math>
<MathVariables>   
<MathVariable VARIABLENAME="DisbursementAmountCC" TYPE="FIELD" DATATYPE="TEXT">Activity:DisbursementAmt:CurrencyCode</MathVariable>
<MathVariable VARIABLENAME="PlanDefaultCC" TYPE="FIELD" DATATYPE="TEXT">Plan:DefaultCurrencyCode</MathVariable>      
<MathVariable VARIABLENAME="PlanMarketMakerGUID" TYPE="FIELD" DATATYPE="TEXT">Plan:MarketMakerGUID</MathVariable>      
<MathVariable VARIABLENAME="DisbursementAmountPlanCurrency" TYPE="CURRENCY" OPERATION="CONVERT" FROMCURRENCY="DisbursementAmountCC" TOCURRENCY="PlanDefaultCC" MARKETMAKER="PlanMarketMakerGUID" EXCHANGEDATE="Activity:EffectiveDate">DisbursementAmt</MathVariable>
<MathVariable VARIABLENAME="DisbursementFee" TYPE="CURRENCY" OPERATION="CONVERT" FROMCURRENCY="PlanDefaultCC" TOCURRENCY="PlanDefaultCC" MARKETMAKER="PlanMarketMakerGUID">DisbursementAmountPlanCurrency * .25</MathVariable>
</MathVariables>   
</Math>

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices