UFN_REPORT_UPGRADE_CONVERTCURRENCY
Converts amount for sponsorship upgrade report
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENCYCODE | smallint | IN | |
| @BASEAMOUNT | money | IN | |
| @SELECTEDCURRENCYID | uniqueidentifier | IN | |
| @APPLICATIONCURRENCYID | uniqueidentifier | IN | |
| @TRANSACTIONAMOUNT | money | IN | |
| @DATE | datetime | IN |
Definition
Copy
CREATE function dbo.UFN_REPORT_UPGRADE_CONVERTCURRENCY(
@CURRENCYCODE smallint = null,
@BASEAMOUNT money,
@SELECTEDCURRENCYID uniqueidentifier,
@APPLICATIONCURRENCYID uniqueidentifier,
@TRANSACTIONAMOUNT money,
@DATE datetime
)
returns money
with execute as caller
as begin
if @CURRENCYCODE = null
return @BASEAMOUNT
if @CURRENCYCODE = 4
return @BASEAMOUNT
if @SELECTEDCURRENCYID = @APPLICATIONCURRENCYID
return @TRANSACTIONAMOUNT
return dbo.UFN_CURRENCY_CONVERT(@TRANSACTIONAMOUNT, dbo.UFN_CURRENCYEXCHANGERATE_GETLATESTINCLUDEEXPIRED(@APPLICATIONCURRENCYID, @SELECTEDCURRENCYID, @DATE, 1, null))
end