USP_ORGANIZATIONEXCHANGERATELOOKUP_DATALIST

Gets currency exchange rate information for the latest organization exchange rate given transaction and base currency IDs.

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@ASOFDATE	datetime	IN	To

Definition

Copy



                create procedure dbo.USP_ORGANIZATIONEXCHANGERATELOOKUP_DATALIST
                (
                    @TRANSACTIONCURRENCYID uniqueidentifier,
                    @BASECURRENCYID uniqueidentifier,
                    @ASOFDATE datetime = null
                )
                as
                set nocount on;

                declare @ORGANIZATIONCURRENCYID uniqueidentifier;
                declare @ORGANIZATIONEXCHANGERATEID uniqueidentifier;
                declare @ORGANIZATIONAMOUNTORIGINCODE tinyint;

                set @ORGANIZATIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();
                set @ORGANIZATIONEXCHANGERATEID = dbo.UFN_CURRENCYEXCHANGERATE_GETLATESTORGANIZATIONRATE(@BASECURRENCYID, @ORGANIZATIONCURRENCYID, @ASOFDATE, null, @TRANSACTIONCURRENCYID)
                select top 1
                    @ORGANIZATIONAMOUNTORIGINCODE = ORGANIZATIONAMOUNTORIGINCODE
                from
                    dbo.MULTICURRENCYCONFIGURATION;

                select
                    @ORGANIZATIONEXCHANGERATEID [ORGANIZATIONEXCHANGERATEID],
                    @ORGANIZATIONAMOUNTORIGINCODE [ORGANIZATIONAMOUNTORIGINCODE],
                    @ORGANIZATIONCURRENCYID [ORGANIZATIONCURRENCYID];