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