UFN_CURRENCYEXCHANGERATE_GETLATESTBASETOORGANIZATIONRATE
Returns the most recent valid organization exchange rate from one currency to another or the provided exchange rate depending on the organization amount origin code.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BASECURRENCYID | uniqueidentifier | IN | |
| @ASOFDATE | datetime | IN | |
| @SOURCECODEID | uniqueidentifier | IN | |
| @ORGANIZATIONEXCHANGERATEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_CURRENCYEXCHANGERATE_GETLATESTBASETOORGANIZATIONRATE
(
@BASECURRENCYID uniqueidentifier,
@ASOFDATE datetime = null,
@SOURCECODEID uniqueidentifier = null,
@ORGANIZATIONEXCHANGERATEID uniqueidentifier = null
)
returns uniqueidentifier
as begin
if (@ORGANIZATIONEXCHANGERATEID is null) or ((select top 1 ORGANIZATIONAMOUNTORIGINCODE from dbo.MULTICURRENCYCONFIGURATION) = 1)
begin
declare @ORGANIZATIONCURRENCYID uniqueidentifier;
set @ORGANIZATIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
return dbo.UFN_CURRENCYEXCHANGERATE_GETLATEST(@BASECURRENCYID, @ORGANIZATIONCURRENCYID, @ASOFDATE, 0, @SOURCECODEID);
end
return @ORGANIZATIONEXCHANGERATEID;
end