USP_CURRENCY_GETCURRENCYVALUESBYPROPORTION

Returns base and organization currency values given a transaction amount, and total amounts.

Parameters

Parameter	Parameter Type	Mode
@AMOUNT	money	IN
@TOTALAMOUNT	money	IN
@BASECURRENCYID	uniqueidentifier	IN
@TOTALBASEAMOUNT	money	IN
@BASECURRENCYDECIMALDIGITS	tinyint	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT
@BASEAMOUNT	money	INOUT
@ORGANIZATIONCURRENCYID	uniqueidentifier	INOUT
@TOTALORGANIZATIONAMOUNT	money	IN
@ORGANIZATIONCURRENCYDECIMALDIGITS	tinyint	IN
@ORGANIZATIONAMOUNT	money	INOUT

Definition

Copy



            CREATE procedure dbo.USP_CURRENCY_GETCURRENCYVALUESBYPROPORTION
            (
                @AMOUNT money,
                @TOTALAMOUNT money,
                @BASECURRENCYID uniqueidentifier,
                @TOTALBASEAMOUNT money = null,
                @BASECURRENCYDECIMALDIGITS tinyint = null,
                @TRANSACTIONCURRENCYID uniqueidentifier output,
                @BASEAMOUNT money = null output,
                @ORGANIZATIONCURRENCYID uniqueidentifier = null output,
                @TOTALORGANIZATIONAMOUNT money,
                @ORGANIZATIONCURRENCYDECIMALDIGITS tinyint = null,
                @ORGANIZATIONAMOUNT money = null output
            )
            as
                set nocount on;

                select
                    @BASEAMOUNT = BASEAMOUNT,
                    @ORGANIZATIONAMOUNT = ORGANIZATIONAMOUNT,
                    @TRANSACTIONCURRENCYID = TRANSACTIONCURRENCYID,
                    @ORGANIZATIONCURRENCYID = ORGANIZATIONCURRENCYID
                from dbo.UFN_CURRENCY_GETCURRENCYVALUESBYPROPORTION(
                    @AMOUNT,
                    @TOTALAMOUNT,
                    @BASECURRENCYID,
                    @TOTALBASEAMOUNT,
                    @BASECURRENCYDECIMALDIGITS,
                    @TRANSACTIONCURRENCYID,
                    @BASEAMOUNT,
                    @ORGANIZATIONCURRENCYID,
                    @TOTALORGANIZATIONAMOUNT,
                    @ORGANIZATIONCURRENCYDECIMALDIGITS,
                    @ORGANIZATIONAMOUNT
                );

                return;