UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDED

CREATE function dbo.[UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDED]
(
  @NAMEFORMATPARAMETERID uniqueidentifier,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
  @PARAMETERSETID uniqueidentifier = null,
  @SEASONALDATE datetime = null,
  @INDUSESEASONALADDRESS bit,    
  @ORGMAILINGPREFERENCE tinyint,
  @INDALTADDRESS1TYPECODEID uniqueidentifier,
  @INDALTADDRESS1ISPRIMARY bit,
  @INDALTADDRESS2TYPECODEID uniqueidentifier,
  @INDALTADDRESS2ISPRIMARY bit,
  @ORGALTADDRESS1TYPECODEID uniqueidentifier,
  @ORGALTADDRESS1ISPRIMARY bit,
  @ORGALTADDRESS2TYPECODEID uniqueidentifier,
  @ORGALTADDRESS2ISPRIMARY bit,
  @INDINCLUDEWITHNOADDRESS bit,
  @ORGINCLUDEWITHNOADDRESS bit,
  @ORGINCLUDEWITHNOCONTACT bit,
  @ORGSENDTOALLCONTACTS bit,
  @INDUSECONSTITUENTPREFS bit,
  @ORGUSECONSTITUENTPREFS bit,
  @GROUPALTADDRESS1TYPECODEID uniqueidentifier,
  @GROUPALTADDRESS1ISPRIMARY bit,
  @GROUPALTADDRESS2TYPECODEID uniqueidentifier,
  @GROUPALTADDRESS2ISPRIMARY bit,
  @GROUPINCLUDEWITHNOADDRESS bit,
  @GROUPUSECONSTITUENTPREFS bit,
  @INDIVIDUALADDRESSEES xml,
  @ADDRESSEEFUNCTIONID uniqueidentifier,
  @INDIVIDUALSALUTATIONS xml,
  @SALUTATIONFUNCTIONID uniqueidentifier,
  @ORGADDRESSEES xml,
  @CONTACTADDRESSEEFUNCTIONID uniqueidentifier,
  @ORGSALUTATIONCODE tinyint,
  @ORGSALUTATIONS xml,
  @CONTACTSALUTATIONFUNCTIONID uniqueidentifier,
  @CONTACTSALUTATIONOPTIONCODE tinyint,
  @CUSTOMNAME nvarchar(100),
  @GROUPADDRESSEES xml,
  @GROUPADDRESSEEFUNCTIONID uniqueidentifier,
  @GROUPSALUTATIONCODE tinyint,
  @GROUPSALUTATIONS xml,
  @GROUPSALUTATIONFUNCTIONID uniqueidentifier,
  @GROUPNOCONTACTOPTIONCODE bit,
  @GROUPNOCONTACTCUSTOMNAME nvarchar(100),
  @JOINTRULETYPECODE As tinyint,
  @JOINTSELECTIONID As uniqueidentifier,
  @JOINTSELECTIONBOTHRULETYPECODE As tinyint,
  @JOINTSELECTIONNEITHERRULETYPECODE As tinyint
)
returns table
as
return
(
  select
    FINANCIALTRANSACTION.ID as REVENUEID,
    CONSTITUENT.NAME as CONSTITUENTNAME,
    CONSTITUENT.LOOKUPID as CONSTITUENTLOOKUPID,
    A.ADDRESSEE,
    A.SALUTATION,
    A.CONTACT as CONTACTADDRESSEE,
    A.POSITION,
    A.ADDRESSBLOCK,
    A.CITY,
    A.STATE,
    A.POSTCODE,
    A.COUNTRY,
    FINANCIALTRANSACTION.TRANSACTIONAMOUNT as TOTALPLEDGEAMOUNT,
    case REVENUE_EXT.GIVENANONYMOUSLY when 1 then 'Yes' else 'No' end as GIVENANONYMOUSLY,
    cast(FINANCIALTRANSACTION.DATE as datetime) as PLEDGEDATE,
    case when FINANCIALTRANSACTION.TYPECODE= 2 then null else dbo.UFN_PLEDGE_GETBALANCE(FINANCIALTRANSACTION.ID) end as PLEDGEBALANCE,
    case when FINANCIALTRANSACTION.TYPECODE= 2 then coalesce((select sum(AMOUNT) from dbo.RECURRINGGIFTACTIVITY where SOURCEREVENUEID = FINANCIALTRANSACTION.ID and TYPECODE = 0), 0) else dbo.UFN_PLEDGE_GETAMOUNTPAID(FINANCIALTRANSACTION.ID) end as AMOUNTPAID,
    APPEAL.NAME as APPEALNAME,

    cast(LASTPAYMENT.DATE as datetime) as LASTPAYMENTDATE,
    LASTPAYMENT.AMOUNT as LASTPAYMENTAMOUNT,

    -- Split 1

    REVENUESPLIT1.DESIGNATIONNAME as DESIGNATION1NAME,
    REVENUESPLIT1.DESIGNATIONPUBLICNAME as DESIGNATION1PUBLICNAME,
    REVENUESPLIT1.AMOUNT as DESIGNATION1AMOUNT,
    REVENUESPLIT1.DESIGNATIONLOOKUPID as DESIGNATION1LOOKUPID,

    RECOGNITIONCREDITS1.RECIPIENT1 as SPLIT1RECOGNITIONCREDIT1RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT1 as SPLIT1RECOGNITIONCREDIT1AMOUNT,
    RECOGNITIONCREDITS1.TYPE1 as SPLIT1RECOGNITIONCREDIT1TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE1 as SPLIT1RECOGNITIONCREDIT1EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT2 as SPLIT1RECOGNITIONCREDIT2RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT2 as SPLIT1RECOGNITIONCREDIT2AMOUNT,
    RECOGNITIONCREDITS1.TYPE2 as SPLIT1RECOGNITIONCREDIT2TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE2 as SPLIT1RECOGNITIONCREDIT2EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT3 as SPLIT1RECOGNITIONCREDIT3RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT3 as SPLIT1RECOGNITIONCREDIT3AMOUNT,
    RECOGNITIONCREDITS1.TYPE3 as SPLIT1RECOGNITIONCREDIT3TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE3 as SPLIT1RECOGNITIONCREDIT3EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT4 as SPLIT1RECOGNITIONCREDIT4RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT4 as SPLIT1RECOGNITIONCREDIT4AMOUNT,
    RECOGNITIONCREDITS1.TYPE4 as SPLIT1RECOGNITIONCREDIT4TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE4 as SPLIT1RECOGNITIONCREDIT4EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT5 as SPLIT1RECOGNITIONCREDIT5RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT5 as SPLIT1RECOGNITIONCREDIT5AMOUNT,
    RECOGNITIONCREDITS1.TYPE5 as SPLIT1RECOGNITIONCREDIT5TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE5 as SPLIT1RECOGNITIONCREDIT5EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT6 as SPLIT1RECOGNITIONCREDIT6RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT6 as SPLIT1RECOGNITIONCREDIT6AMOUNT,
    RECOGNITIONCREDITS1.TYPE6 as SPLIT1RECOGNITIONCREDIT6TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE6 as SPLIT1RECOGNITIONCREDIT6EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT7 as SPLIT1RECOGNITIONCREDIT7RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT7 as SPLIT1RECOGNITIONCREDIT7AMOUNT,
    RECOGNITIONCREDITS1.TYPE7 as SPLIT1RECOGNITIONCREDIT7TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE7 as SPLIT1RECOGNITIONCREDIT7EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT8 as SPLIT1RECOGNITIONCREDIT8RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT8 as SPLIT1RECOGNITIONCREDIT8AMOUNT,
    RECOGNITIONCREDITS1.TYPE8 as SPLIT1RECOGNITIONCREDIT8TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE8 as SPLIT1RECOGNITIONCREDIT8EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT9 as SPLIT1RECOGNITIONCREDIT9RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT9 as SPLIT1RECOGNITIONCREDIT9AMOUNT,
    RECOGNITIONCREDITS1.TYPE9 as SPLIT1RECOGNITIONCREDIT9TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE9 as SPLIT1RECOGNITIONCREDIT9EFFECTIVEDATE,

    RECOGNITIONCREDITS1.RECIPIENT10 as SPLIT1RECOGNITIONCREDIT10RECIPIENT,
    RECOGNITIONCREDITS1.AMOUNT10 as SPLIT1RECOGNITIONCREDIT10AMOUNT,
    RECOGNITIONCREDITS1.TYPE10 as SPLIT1RECOGNITIONCREDIT10TYPE,
    RECOGNITIONCREDITS1.EFFECTIVEDATE10 as SPLIT1RECOGNITIONCREDIT10EFFECTIVEDATE,

    -- Split 2

    REVENUESPLIT2.DESIGNATIONNAME as DESIGNATION2NAME,
    REVENUESPLIT2.DESIGNATIONPUBLICNAME as DESIGNATION2PUBLICNAME,
    REVENUESPLIT2.AMOUNT as DESIGNATION2AMOUNT,
    REVENUESPLIT2.DESIGNATIONLOOKUPID as DESIGNATION2LOOKUPID,

    RECOGNITIONCREDITS2.RECIPIENT1 as SPLIT2RECOGNITIONCREDIT1RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT1 as SPLIT2RECOGNITIONCREDIT1AMOUNT,
    RECOGNITIONCREDITS2.TYPE1 as SPLIT2RECOGNITIONCREDIT1TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE1 as SPLIT2RECOGNITIONCREDIT1EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT2 as SPLIT2RECOGNITIONCREDIT2RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT2 as SPLIT2RECOGNITIONCREDIT2AMOUNT,
    RECOGNITIONCREDITS2.TYPE2 as SPLIT2RECOGNITIONCREDIT2TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE2 as SPLIT2RECOGNITIONCREDIT2EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT3 as SPLIT2RECOGNITIONCREDIT3RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT3 as SPLIT2RECOGNITIONCREDIT3AMOUNT,
    RECOGNITIONCREDITS2.TYPE3 as SPLIT2RECOGNITIONCREDIT3TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE3 as SPLIT2RECOGNITIONCREDIT3EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT4 as SPLIT2RECOGNITIONCREDIT4RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT4 as SPLIT2RECOGNITIONCREDIT4AMOUNT,
    RECOGNITIONCREDITS2.TYPE4 as SPLIT2RECOGNITIONCREDIT4TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE4 as SPLIT2RECOGNITIONCREDIT4EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT5 as SPLIT2RECOGNITIONCREDIT5RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT5 as SPLIT2RECOGNITIONCREDIT5AMOUNT,
    RECOGNITIONCREDITS2.TYPE5 as SPLIT2RECOGNITIONCREDIT5TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE5 as SPLIT2RECOGNITIONCREDIT5EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT6 as SPLIT2RECOGNITIONCREDIT6RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT6 as SPLIT2RECOGNITIONCREDIT6AMOUNT,
    RECOGNITIONCREDITS2.TYPE6 as SPLIT2RECOGNITIONCREDIT6TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE6 as SPLIT2RECOGNITIONCREDIT6EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT7 as SPLIT2RECOGNITIONCREDIT7RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT7 as SPLIT2RECOGNITIONCREDIT7AMOUNT,
    RECOGNITIONCREDITS2.TYPE7 as SPLIT2RECOGNITIONCREDIT7TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE7 as SPLIT2RECOGNITIONCREDIT7EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT8 as SPLIT2RECOGNITIONCREDIT8RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT8 as SPLIT2RECOGNITIONCREDIT8AMOUNT,
    RECOGNITIONCREDITS2.TYPE8 as SPLIT2RECOGNITIONCREDIT8TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE8 as SPLIT2RECOGNITIONCREDIT8EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT9 as SPLIT2RECOGNITIONCREDIT9RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT9 as SPLIT2RECOGNITIONCREDIT9AMOUNT,
    RECOGNITIONCREDITS2.TYPE9 as SPLIT2RECOGNITIONCREDIT9TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE9 as SPLIT2RECOGNITIONCREDIT9EFFECTIVEDATE,

    RECOGNITIONCREDITS2.RECIPIENT10 as SPLIT2RECOGNITIONCREDIT10RECIPIENT,
    RECOGNITIONCREDITS2.AMOUNT10 as SPLIT2RECOGNITIONCREDIT10AMOUNT,
    RECOGNITIONCREDITS2.TYPE10 as SPLIT2RECOGNITIONCREDIT10TYPE,
    RECOGNITIONCREDITS2.EFFECTIVEDATE10 as SPLIT2RECOGNITIONCREDIT10EFFECTIVEDATE,

    -- Split 3

    REVENUESPLIT3.DESIGNATIONNAME as DESIGNATION3NAME,
    REVENUESPLIT3.DESIGNATIONPUBLICNAME as DESIGNATION3PUBLICNAME,
    REVENUESPLIT3.AMOUNT as DESIGNATION3AMOUNT,
    REVENUESPLIT3.DESIGNATIONLOOKUPID as DESIGNATION3LOOKUPID,

    RECOGNITIONCREDITS3.RECIPIENT1 as SPLIT3RECOGNITIONCREDIT1RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT1 as SPLIT3RECOGNITIONCREDIT1AMOUNT,
    RECOGNITIONCREDITS3.TYPE1 as SPLIT3RECOGNITIONCREDIT1TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE1 as SPLIT3RECOGNITIONCREDIT1EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT2 as SPLIT3RECOGNITIONCREDIT2RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT2 as SPLIT3RECOGNITIONCREDIT2AMOUNT,
    RECOGNITIONCREDITS3.TYPE2 as SPLIT3RECOGNITIONCREDIT2TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE2 as SPLIT3RECOGNITIONCREDIT2EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT3 as SPLIT3RECOGNITIONCREDIT3RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT3 as SPLIT3RECOGNITIONCREDIT3AMOUNT,
    RECOGNITIONCREDITS3.TYPE3 as SPLIT3RECOGNITIONCREDIT3TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE3 as SPLIT3RECOGNITIONCREDIT3EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT4 as SPLIT3RECOGNITIONCREDIT4RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT4 as SPLIT3RECOGNITIONCREDIT4AMOUNT,
    RECOGNITIONCREDITS3.TYPE4 as SPLIT3RECOGNITIONCREDIT4TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE4 as SPLIT3RECOGNITIONCREDIT4EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT5 as SPLIT3RECOGNITIONCREDIT5RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT5 as SPLIT3RECOGNITIONCREDIT5AMOUNT,
    RECOGNITIONCREDITS3.TYPE5 as SPLIT3RECOGNITIONCREDIT5TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE5 as SPLIT3RECOGNITIONCREDIT5EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT6 as SPLIT3RECOGNITIONCREDIT6RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT6 as SPLIT3RECOGNITIONCREDIT6AMOUNT,
    RECOGNITIONCREDITS3.TYPE6 as SPLIT3RECOGNITIONCREDIT6TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE6 as SPLIT3RECOGNITIONCREDIT6EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT7 as SPLIT3RECOGNITIONCREDIT7RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT7 as SPLIT3RECOGNITIONCREDIT7AMOUNT,
    RECOGNITIONCREDITS3.TYPE7 as SPLIT3RECOGNITIONCREDIT7TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE7 as SPLIT3RECOGNITIONCREDIT7EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT8 as SPLIT3RECOGNITIONCREDIT8RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT8 as SPLIT3RECOGNITIONCREDIT8AMOUNT,
    RECOGNITIONCREDITS3.TYPE8 as SPLIT3RECOGNITIONCREDIT8TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE8 as SPLIT3RECOGNITIONCREDIT8EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT9 as SPLIT3RECOGNITIONCREDIT9RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT9 as SPLIT3RECOGNITIONCREDIT9AMOUNT,
    RECOGNITIONCREDITS3.TYPE9 as SPLIT3RECOGNITIONCREDIT9TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE9 as SPLIT3RECOGNITIONCREDIT9EFFECTIVEDATE,

    RECOGNITIONCREDITS3.RECIPIENT10 as SPLIT3RECOGNITIONCREDIT10RECIPIENT,
    RECOGNITIONCREDITS3.AMOUNT10 as SPLIT3RECOGNITIONCREDIT10AMOUNT,
    RECOGNITIONCREDITS3.TYPE10 as SPLIT3RECOGNITIONCREDIT10TYPE,
    RECOGNITIONCREDITS3.EFFECTIVEDATE10 as SPLIT3RECOGNITIONCREDIT10EFFECTIVEDATE,

    -- Split 4

    REVENUESPLIT4.DESIGNATIONNAME as DESIGNATION4NAME,
    REVENUESPLIT4.DESIGNATIONPUBLICNAME as DESIGNATION4PUBLICNAME,
    REVENUESPLIT4.AMOUNT as DESIGNATION4AMOUNT,
    REVENUESPLIT4.DESIGNATIONLOOKUPID as DESIGNATION4LOOKUPID,

    RECOGNITIONCREDITS4.RECIPIENT1 as SPLIT4RECOGNITIONCREDIT1RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT1 as SPLIT4RECOGNITIONCREDIT1AMOUNT,
    RECOGNITIONCREDITS4.TYPE1 as SPLIT4RECOGNITIONCREDIT1TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE1 as SPLIT4RECOGNITIONCREDIT1EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT2 as SPLIT4RECOGNITIONCREDIT2RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT2 as SPLIT4RECOGNITIONCREDIT2AMOUNT,
    RECOGNITIONCREDITS4.TYPE2 as SPLIT4RECOGNITIONCREDIT2TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE2 as SPLIT4RECOGNITIONCREDIT2EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT3 as SPLIT4RECOGNITIONCREDIT3RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT3 as SPLIT4RECOGNITIONCREDIT3AMOUNT,
    RECOGNITIONCREDITS4.TYPE3 as SPLIT4RECOGNITIONCREDIT3TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE3 as SPLIT4RECOGNITIONCREDIT3EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT4 as SPLIT4RECOGNITIONCREDIT4RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT4 as SPLIT4RECOGNITIONCREDIT4AMOUNT,
    RECOGNITIONCREDITS4.TYPE4 as SPLIT4RECOGNITIONCREDIT4TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE4 as SPLIT4RECOGNITIONCREDIT4EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT5 as SPLIT4RECOGNITIONCREDIT5RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT5 as SPLIT4RECOGNITIONCREDIT5AMOUNT,
    RECOGNITIONCREDITS4.TYPE5 as SPLIT4RECOGNITIONCREDIT5TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE5 as SPLIT4RECOGNITIONCREDIT5EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT6 as SPLIT4RECOGNITIONCREDIT6RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT6 as SPLIT4RECOGNITIONCREDIT6AMOUNT,
    RECOGNITIONCREDITS4.TYPE6 as SPLIT4RECOGNITIONCREDIT6TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE6 as SPLIT4RECOGNITIONCREDIT6EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT7 as SPLIT4RECOGNITIONCREDIT7RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT7 as SPLIT4RECOGNITIONCREDIT7AMOUNT,
    RECOGNITIONCREDITS4.TYPE7 as SPLIT4RECOGNITIONCREDIT7TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE7 as SPLIT4RECOGNITIONCREDIT7EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT8 as SPLIT4RECOGNITIONCREDIT8RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT8 as SPLIT4RECOGNITIONCREDIT8AMOUNT,
    RECOGNITIONCREDITS4.TYPE8 as SPLIT4RECOGNITIONCREDIT8TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE8 as SPLIT4RECOGNITIONCREDIT8EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT9 as SPLIT4RECOGNITIONCREDIT9RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT9 as SPLIT4RECOGNITIONCREDIT9AMOUNT,
    RECOGNITIONCREDITS4.TYPE9 as SPLIT4RECOGNITIONCREDIT9TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE9 as SPLIT4RECOGNITIONCREDIT9EFFECTIVEDATE,

    RECOGNITIONCREDITS4.RECIPIENT10 as SPLIT4RECOGNITIONCREDIT10RECIPIENT,
    RECOGNITIONCREDITS4.AMOUNT10 as SPLIT4RECOGNITIONCREDIT10AMOUNT,
    RECOGNITIONCREDITS4.TYPE10 as SPLIT4RECOGNITIONCREDIT10TYPE,
    RECOGNITIONCREDITS4.EFFECTIVEDATE10 as SPLIT4RECOGNITIONCREDIT10EFFECTIVEDATE,

    -- Split 5

    REVENUESPLIT5.DESIGNATIONNAME as DESIGNATION5NAME,
    REVENUESPLIT5.DESIGNATIONPUBLICNAME as DESIGNATION5PUBLICNAME,
    REVENUESPLIT5.AMOUNT as DESIGNATION5AMOUNT,
    REVENUESPLIT5.DESIGNATIONLOOKUPID as DESIGNATION5LOOKUPID,

    RECOGNITIONCREDITS5.RECIPIENT1 as SPLIT5RECOGNITIONCREDIT1RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT1 as SPLIT5RECOGNITIONCREDIT1AMOUNT,
    RECOGNITIONCREDITS5.TYPE1 as SPLIT5RECOGNITIONCREDIT1TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE1 as SPLIT5RECOGNITIONCREDIT1EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT2 as SPLIT5RECOGNITIONCREDIT2RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT2 as SPLIT5RECOGNITIONCREDIT2AMOUNT,
    RECOGNITIONCREDITS5.TYPE2 as SPLIT5RECOGNITIONCREDIT2TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE2 as SPLIT5RECOGNITIONCREDIT2EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT3 as SPLIT5RECOGNITIONCREDIT3RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT3 as SPLIT5RECOGNITIONCREDIT3AMOUNT,
    RECOGNITIONCREDITS5.TYPE3 as SPLIT5RECOGNITIONCREDIT3TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE3 as SPLIT5RECOGNITIONCREDIT3EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT4 as SPLIT5RECOGNITIONCREDIT4RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT4 as SPLIT5RECOGNITIONCREDIT4AMOUNT,
    RECOGNITIONCREDITS5.TYPE4 as SPLIT5RECOGNITIONCREDIT4TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE4 as SPLIT5RECOGNITIONCREDIT4EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT5 as SPLIT5RECOGNITIONCREDIT5RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT5 as SPLIT5RECOGNITIONCREDIT5AMOUNT,
    RECOGNITIONCREDITS5.TYPE5 as SPLIT5RECOGNITIONCREDIT5TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE5 as SPLIT5RECOGNITIONCREDIT5EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT6 as SPLIT5RECOGNITIONCREDIT6RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT6 as SPLIT5RECOGNITIONCREDIT6AMOUNT,
    RECOGNITIONCREDITS5.TYPE6 as SPLIT5RECOGNITIONCREDIT6TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE6 as SPLIT5RECOGNITIONCREDIT6EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT7 as SPLIT5RECOGNITIONCREDIT7RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT7 as SPLIT5RECOGNITIONCREDIT7AMOUNT,
    RECOGNITIONCREDITS5.TYPE7 as SPLIT5RECOGNITIONCREDIT7TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE7 as SPLIT5RECOGNITIONCREDIT7EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT8 as SPLIT5RECOGNITIONCREDIT8RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT8 as SPLIT5RECOGNITIONCREDIT8AMOUNT,
    RECOGNITIONCREDITS5.TYPE8 as SPLIT5RECOGNITIONCREDIT8TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE8 as SPLIT5RECOGNITIONCREDIT8EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT9 as SPLIT5RECOGNITIONCREDIT9RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT9 as SPLIT5RECOGNITIONCREDIT9AMOUNT,
    RECOGNITIONCREDITS5.TYPE9 as SPLIT5RECOGNITIONCREDIT9TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE9 as SPLIT5RECOGNITIONCREDIT9EFFECTIVEDATE,

    RECOGNITIONCREDITS5.RECIPIENT10 as SPLIT5RECOGNITIONCREDIT10RECIPIENT,
    RECOGNITIONCREDITS5.AMOUNT10 as SPLIT5RECOGNITIONCREDIT10AMOUNT,
    RECOGNITIONCREDITS5.TYPE10 as SPLIT5RECOGNITIONCREDIT10TYPE,
    RECOGNITIONCREDITS5.EFFECTIVEDATE10 as SPLIT5RECOGNITIONCREDIT10EFFECTIVEDATE,

    FINANCIALTRANSACTION.CALCULATEDUSERDEFINEDID as REVENUELOOKUPID,

    FINANCIALTRANSACTION.TRANSACTIONCURRENCYID,
    CURRENCYSET.BASECURRENCYID,
    dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) as TOTALPLEDGEAMOUNTCURRENCY,
    dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) as PLEDGEBALANCECURRENCY,
    dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) as AMOUNTPAIDCURRENCY,
    case when LASTPAYMENT.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) else null end as LASTPAYMENTAMOUNTCURRENCY,
    case when REVENUESPLIT1.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) else null end as DESIGNATION1AMOUNTCURRENCY,
    case when REVENUESPLIT2.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) else null end as DESIGNATION2AMOUNTCURRENCY,
    case when REVENUESPLIT3.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) else null end as DESIGNATION3AMOUNTCURRENCY,
    case when REVENUESPLIT4.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) else null end as DESIGNATION4AMOUNTCURRENCY,
    case when REVENUESPLIT5.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(FINANCIALTRANSACTION.TRANSACTIONCURRENCYID) else null end as DESIGNATION5AMOUNTCURRENCY,

    case when RECOGNITIONCREDITS1.AMOUNT1 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT1AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT2 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT2AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT3 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT3AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT4 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT4AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT5 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT5AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT6 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT6AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT7 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT7AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT8 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT8AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT9 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT9AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS1.AMOUNT10 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT1RECOGNITIONCREDIT10AMOUNTCURRENCY,

    case when RECOGNITIONCREDITS2.AMOUNT1 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT1AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT2 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT2AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT3 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT3AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT4 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT4AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT5 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT5AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT6 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT6AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT7 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT7AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT8 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT8AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT9 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT9AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS2.AMOUNT10 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT2RECOGNITIONCREDIT10AMOUNTCURRENCY,

    case when RECOGNITIONCREDITS3.AMOUNT1 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT1AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT2 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT2AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT3 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT3AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT4 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT4AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT5 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT5AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT6 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT6AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT7 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT7AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT8 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT8AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT9 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT9AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS3.AMOUNT10 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT3RECOGNITIONCREDIT10AMOUNTCURRENCY,

    case when RECOGNITIONCREDITS4.AMOUNT1 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT1AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT2 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT2AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT3 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT3AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT4 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT4AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT5 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT5AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT6 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT6AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT7 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT7AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT8 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT8AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT9 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT9AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS4.AMOUNT10 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT4RECOGNITIONCREDIT10AMOUNTCURRENCY,

    case when RECOGNITIONCREDITS5.AMOUNT1 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT1AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT2 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT2AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT3 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT3AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT4 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT4AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT5 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT5AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT6 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT6AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT7 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT7AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT8 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT8AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT9 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT9AMOUNTCURRENCY,
    case when RECOGNITIONCREDITS5.AMOUNT10 is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as SPLIT5RECOGNITIONCREDIT10AMOUNTCURRENCY

  from dbo.FINANCIALTRANSACTION
  inner join dbo.REVENUE_EXT on FINANCIALTRANSACTION.ID = REVENUE_EXT.ID
  inner join dbo.CONSTITUENT on FINANCIALTRANSACTION.CONSTITUENTID = CONSTITUENT.ID
  inner join dbo.PDACCOUNTSYSTEM on FINANCIALTRANSACTION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
  inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
  inner join dbo.UFN_CONTACTPREFERENCES_GETFORMATS_EXT (
    @NAMEFORMATPARAMETERID,
    @ADDRESSPROCESSINGOPTIONID,
    4,
    @PARAMETERSETID,
    @SEASONALDATE,
    0,
    @INDUSESEASONALADDRESS ,
    @ORGMAILINGPREFERENCE ,
    @INDALTADDRESS1TYPECODEID,
    @INDALTADDRESS1ISPRIMARY ,
    @INDALTADDRESS2TYPECODEID,
    @INDALTADDRESS2ISPRIMARY ,
    @ORGALTADDRESS1TYPECODEID,
    @ORGALTADDRESS1ISPRIMARY ,
    @ORGALTADDRESS2TYPECODEID,
    @ORGALTADDRESS2ISPRIMARY ,
    @INDINCLUDEWITHNOADDRESS ,
    @ORGINCLUDEWITHNOADDRESS ,
    @ORGINCLUDEWITHNOCONTACT ,
    @ORGSENDTOALLCONTACTS ,
    @INDUSECONSTITUENTPREFS ,
    @ORGUSECONSTITUENTPREFS ,
    @GROUPALTADDRESS1TYPECODEID,
    @GROUPALTADDRESS1ISPRIMARY ,
    @GROUPALTADDRESS2TYPECODEID,
    @GROUPALTADDRESS2ISPRIMARY ,
    @GROUPINCLUDEWITHNOADDRESS ,
    @GROUPUSECONSTITUENTPREFS ,
    @INDIVIDUALADDRESSEES ,
    @ADDRESSEEFUNCTIONID,
    @INDIVIDUALSALUTATIONS ,
    @SALUTATIONFUNCTIONID,
    @ORGADDRESSEES ,
    @CONTACTADDRESSEEFUNCTIONID,
    @ORGSALUTATIONCODE,
    @ORGSALUTATIONS ,
    @CONTACTSALUTATIONFUNCTIONID,
    @CONTACTSALUTATIONOPTIONCODE ,
    @CUSTOMNAME ,
    @GROUPADDRESSEES ,
    @GROUPADDRESSEEFUNCTIONID,
    @GROUPSALUTATIONCODE,
    @GROUPSALUTATIONS ,
    @GROUPSALUTATIONFUNCTIONID,
    @GROUPNOCONTACTOPTIONCODE ,
    @GROUPNOCONTACTCUSTOMNAME,
    @JOINTRULETYPECODE,
    @JOINTSELECTIONID,
    @JOINTSELECTIONBOTHRULETYPECODE,
    @JOINTSELECTIONNEITHERRULETYPECODE, 
    0) A
    on CONSTITUENT.ID = A.CONSTITUENTID  
  left join dbo.APPEAL on REVENUE_EXT.APPEALID = APPEAL.ID

  outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(FINANCIALTRANSACTION.ID, 1) as REVENUESPLIT1
  outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(FINANCIALTRANSACTION.ID, 2) as REVENUESPLIT2
  outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(FINANCIALTRANSACTION.ID, 3) as REVENUESPLIT3
  outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(FINANCIALTRANSACTION.ID, 4) as REVENUESPLIT4
  outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(FINANCIALTRANSACTION.ID, 5) as REVENUESPLIT5

  outer apply dbo.UFN_REVENUESPLIT_GETTOP10RECOGNITIONCREDITSINONEROW(REVENUESPLIT1.ID) as RECOGNITIONCREDITS1
  outer apply dbo.UFN_REVENUESPLIT_GETTOP10RECOGNITIONCREDITSINONEROW(REVENUESPLIT2.ID) as RECOGNITIONCREDITS2
  outer apply dbo.UFN_REVENUESPLIT_GETTOP10RECOGNITIONCREDITSINONEROW(REVENUESPLIT3.ID) as RECOGNITIONCREDITS3
  outer apply dbo.UFN_REVENUESPLIT_GETTOP10RECOGNITIONCREDITSINONEROW(REVENUESPLIT4.ID) as RECOGNITIONCREDITS4
  outer apply dbo.UFN_REVENUESPLIT_GETTOP10RECOGNITIONCREDITSINONEROW(REVENUESPLIT5.ID) as RECOGNITIONCREDITS5

  outer apply
  (
    select top 1
      REVLAST.DATE,
      sum(REVSPLITLAST.TRANSACTIONAMOUNT) AMOUNT
    from dbo.FINANCIALTRANSACTIONLINEITEM REVSPLITLAST
    inner join dbo.FINANCIALTRANSACTION REVLAST on REVSPLITLAST.FINANCIALTRANSACTIONID = REVLAST.ID
    where
      REVSPLITLAST.ID in (select PAYMENTID from dbo.INSTALLMENTSPLITPAYMENT where PLEDGEID = FINANCIALTRANSACTION.ID)
    group by REVLAST.ID, REVLAST.DATE, REVLAST.DATEADDED
    order by REVLAST.DATE desc, REVLAST.DATEADDED desc
  ) LASTPAYMENT
)