UFN_REVENUE_GENERATEDEFAULTGIFTFEESWITHTRANSACTIONAMOUNT_2

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@PAYMENTMETHOD	tinyint	IN
@TRANSACTIONAMOUNT	money	IN
@RECEIPTAMOUNT	money	IN
@BASECURRENCYID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@ORGANIZATIONEXCHANGERATEID	uniqueidentifier	IN
@SPLITS	xml	IN

Definition

Copy



CREATE function dbo.UFN_REVENUE_GENERATEDEFAULTGIFTFEESWITHTRANSACTIONAMOUNT_2(
                    @REVENUEID uniqueidentifier,
                    @CONSTITUENTID uniqueidentifier,
                    @PAYMENTMETHOD tinyint,
                    @TRANSACTIONAMOUNT money,
                    @RECEIPTAMOUNT money,
                    @BASECURRENCYID uniqueidentifier,
                    @TRANSACTIONCURRENCYID uniqueidentifier,
                    @BASEEXCHANGERATEID uniqueidentifier,
                    @ORGANIZATIONEXCHANGERATEID uniqueidentifier,
                    @SPLITS xml)
    returns @GIFTFEES table 
        (ID uniqueidentifier, 
        FEE money,
        WAIVED bit,
        SPLITRECEIPTAMOUNT money,
        BASECURRENCYID uniqueidentifier,
        ORGANIZATIONAMOUNT money,
        ORGANIZATIONEXCHANGERATEID uniqueidentifier,
        TRANSACTIONAMOUNT money,
        TRANSACTIONCURRENCYID uniqueidentifier,
        BASEEXCHANGERATEID uniqueidentifier)

AS    
begin

insert into @GIFTFEES
                select
                        ID, 
                        FEE,
                        WAIVED,
                        SPLITRECEIPTAMOUNT,
                        BASECURRENCYID,
                        ORGANIZATIONAMOUNT,
                        ORGANIZATIONEXCHANGERATEID,
                        TRANSACTIONAMOUNT,
                        TRANSACTIONCURRENCYID,
                        BASEEXCHANGERATEID
                from dbo.UFN_REVENUE_GENERATEDEFAULTGIFTFEESWITHTRANSACTIONAMOUNT_3(@REVENUEID,
                                                  @CONSTITUENTID,
                                                  @PAYMENTMETHOD,
                                                  @TRANSACTIONAMOUNT,
                                                  @RECEIPTAMOUNT,
                                                  @BASECURRENCYID,
                                                  @TRANSACTIONCURRENCYID,
                                                  @BASEEXCHANGERATEID,
                                                  @ORGANIZATIONEXCHANGERATEID,
                                                  @SPLITS,
                                                  null); --ORGANIZATIONAMOUNT



    return;
end