UFN_AUCTIONPACKAGE_CONVERTTOORGANIZATIONCURRENCY_UNROUNDED
Converts an amount from one currency to another without rounding using the given exchange rate ID.
Return
Return Type |
---|
money |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@BASEAMOUNT | money | IN | |
@CURRENCYEXCHANGERATEID | uniqueidentifier | IN | |
@TRANSACTIONAMOUNT | money | IN |
Definition
Copy
create function dbo.UFN_AUCTIONPACKAGE_CONVERTTOORGANIZATIONCURRENCY_UNROUNDED
(
@BASEAMOUNT money,
@CURRENCYEXCHANGERATEID uniqueidentifier = null,
@TRANSACTIONAMOUNT money = null
)
returns money
as begin
declare @RATE decimal(20,8);
if @CURRENCYEXCHANGERATEID is null
return 0;
-- if the system organization amount source currency is transaction currency, use the @TRANSACTIONAMOUNT parameter in the conversion
if (@TRANSACTIONAMOUNT is not null) and ((select top 1 ORGANIZATIONAMOUNTORIGINCODE from dbo.MULTICURRENCYCONFIGURATION) = 1)
set @BASEAMOUNT = @TRANSACTIONAMOUNT;
select
@RATE = CURRENCYEXCHANGERATE.RATE
from
dbo.CURRENCYEXCHANGERATE
inner join dbo.CURRENCY on CURRENCY.ID = CURRENCYEXCHANGERATE.TOCURRENCYID
where
CURRENCYEXCHANGERATE.ID = @CURRENCYEXCHANGERATEID;
return dbo.UFN_AUCTIONPACKAGE_APPLYRATE(@BASEAMOUNT, @RATE);
end