UFN_REVENUE_RECEIPTAMOUNTVALID

Validates that the receipt amount against gift amount.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@RECEIPTAMOUNT	money	IN
@TRANSACTIONAMOUNT	money	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEAMOUNT	money	IN
@BASECURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@ORGANIZATIONAMOUNT	money	IN
@ORGANIZATIONEXCHANGERATEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUE_RECEIPTAMOUNTVALID
            (
                @RECEIPTAMOUNT money,
                @TRANSACTIONAMOUNT money,
                @TRANSACTIONCURRENCYID uniqueidentifier,
                @BASEAMOUNT money,
                @BASECURRENCYID uniqueidentifier,
                @BASEEXCHANGERATEID uniqueidentifier,
                @ORGANIZATIONAMOUNT money,
                @ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )
            returns bit
            with execute as caller
            as
            begin
                declare @VALID bit = 0;

                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(); 

                if @ORGANIZATIONEXCHANGERATEID is null
                    and @BASEEXCHANGERATEID is null
                    and (@BASECURRENCYID is null or @BASECURRENCYID = @ORGANIZATIONCURRENCYID)
                    and (@TRANSACTIONCURRENCYID is null or @TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID)
                    and (@ORGANIZATIONAMOUNT <> @BASEAMOUNT or @TRANSACTIONAMOUNT <> @BASEAMOUNT)
                begin
                    if @RECEIPTAMOUNT <= @BASEAMOUNT
                        set @VALID = 1
                end
                else
                begin
                    if @RECEIPTAMOUNT <= @TRANSACTIONAMOUNT
                        set @VALID = 1
                end

                return @VALID;

            end