UFN_CREDITCARDPROCESSING_ARECURRENCIESMAPPEDTOMERCHANTACCOUNTS

Checks if all currencies that will be included in the credit card process are mapped to a merchant account.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CREDITCARDPROCESSINGID	uniqueidentifier	IN
@BATCHID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CREDITCARDPROCESSING_ARECURRENCIESMAPPEDTOMERCHANTACCOUNTS
            (
                @CREDITCARDPROCESSINGID uniqueidentifier,
                @BATCHID uniqueidentifier
            )
            returns bit
            with execute as caller
            as 
            begin
                declare @ORGANIZATIONCURRENCYID uniqueidentifier;
                select @ORGANIZATIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                declare @ALLCURRENCIESMAPPED bit;
                if exists (
                    select 1
                    from dbo.UFN_CREDITCARDPROCESSING_GETCURRENCIESNOTMAPPEDTOMERCHANTACCOUNTS(@CREDITCARDPROCESSINGID, @BATCHID, @ORGANIZATIONCURRENCYID))
                    set @ALLCURRENCIESMAPPED = 0;
                else
                    set @ALLCURRENCIESMAPPED = 1;

                return @ALLCURRENCIESMAPPED;
            end