UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDED2
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @NAMEFORMATPARAMETERID | uniqueidentifier | IN | |
| @ADDRESSPROCESSINGOPTIONID | uniqueidentifier | IN | |
| @PARAMETERSETID | uniqueidentifier | IN | |
| @SEASONALDATE | datetime | IN | |
| @INDUSESEASONALADDRESS | bit | IN | |
| @ORGMAILINGPREFERENCE | tinyint | IN | |
| @INDALTADDRESS1TYPECODEID | uniqueidentifier | IN | |
| @INDALTADDRESS1ISPRIMARY | bit | IN | |
| @INDALTADDRESS2TYPECODEID | uniqueidentifier | IN | |
| @INDALTADDRESS2ISPRIMARY | bit | IN | |
| @ORGALTADDRESS1TYPECODEID | uniqueidentifier | IN | |
| @ORGALTADDRESS1ISPRIMARY | bit | IN | |
| @ORGALTADDRESS2TYPECODEID | uniqueidentifier | IN | |
| @ORGALTADDRESS2ISPRIMARY | bit | IN | |
| @INDINCLUDEWITHNOADDRESS | bit | IN | |
| @ORGINCLUDEWITHNOADDRESS | bit | IN | |
| @ORGINCLUDEWITHNOCONTACT | bit | IN | |
| @ORGSENDTOALLCONTACTS | bit | IN | |
| @INDUSECONSTITUENTPREFS | bit | IN | |
| @ORGUSECONSTITUENTPREFS | bit | IN | |
| @GROUPALTADDRESS1TYPECODEID | uniqueidentifier | IN | |
| @GROUPALTADDRESS1ISPRIMARY | bit | IN | |
| @GROUPALTADDRESS2TYPECODEID | uniqueidentifier | IN | |
| @GROUPALTADDRESS2ISPRIMARY | bit | IN | |
| @GROUPINCLUDEWITHNOADDRESS | bit | IN | |
| @GROUPUSECONSTITUENTPREFS | bit | IN | |
| @INDIVIDUALADDRESSEES | xml | IN | |
| @ADDRESSEEFUNCTIONID | uniqueidentifier | IN | |
| @INDIVIDUALSALUTATIONS | xml | IN | |
| @SALUTATIONFUNCTIONID | uniqueidentifier | IN | |
| @ORGADDRESSEES | xml | IN | |
| @CONTACTADDRESSEEFUNCTIONID | uniqueidentifier | IN | |
| @ORGSALUTATIONCODE | tinyint | IN | |
| @ORGSALUTATIONS | xml | IN | |
| @CONTACTSALUTATIONFUNCTIONID | uniqueidentifier | IN | |
| @CONTACTSALUTATIONOPTIONCODE | tinyint | IN | |
| @CUSTOMNAME | nvarchar(100) | IN | |
| @GROUPADDRESSEES | xml | IN | |
| @GROUPADDRESSEEFUNCTIONID | uniqueidentifier | IN | |
| @GROUPSALUTATIONCODE | tinyint | IN | |
| @GROUPSALUTATIONS | xml | IN | |
| @GROUPSALUTATIONFUNCTIONID | uniqueidentifier | IN | |
| @GROUPNOCONTACTOPTIONCODE | bit | IN | |
| @GROUPNOCONTACTCUSTOMNAME | nvarchar(100) | IN | |
| @JOINTRULETYPECODE | tinyint | IN | |
| @JOINTSELECTIONID | uniqueidentifier | IN | |
| @JOINTSELECTIONBOTHRULETYPECODE | tinyint | IN | |
| @JOINTSELECTIONNEITHERRULETYPECODE | tinyint | IN |
Definition
Copy
CREATE function dbo.UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDED2
(
@REVENUEID uniqueidentifier,
@NAMEFORMATPARAMETERID uniqueidentifier,
@ADDRESSPROCESSINGOPTIONID uniqueidentifier,
@PARAMETERSETID uniqueidentifier,
@SEASONALDATE datetime,
@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
DETAIL.REVENUEID,
SUMMARY.CONSTITUENTNAME,
SUMMARY.CONSTITUENTLOOKUPID,
SUMMARY.ADDRESSEE,
SUMMARY.SALUTATION,
SUMMARY.CONTACTADDRESSEE,
SUMMARY.POSITION,
SUMMARY.ADDRESSBLOCK,
SUMMARY.CITY,
SUMMARY.STATE,
SUMMARY.POSTCODE,
SUMMARY.COUNTRY,
DETAIL.TOTALPLEDGEAMOUNT,
DETAIL.GIVENANONYMOUSLY,
DETAIL.PLEDGEDATE,
DETAIL.PLEDGEBALANCE,
DETAIL.AMOUNTPAID,
DETAIL.APPEALNAME,
DETAIL.LASTPAYMENTDATE,
DETAIL.LASTPAYMENTAMOUNT,
DETAIL.DESIGNATION1NAME,
DETAIL.DESIGNATION1PUBLICNAME,
DETAIL.DESIGNATION1AMOUNT,
DETAIL.DESIGNATION1LOOKUPID,
DETAIL.SPLIT1RECOGNITIONCREDIT1RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT1AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT1TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT1EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT2RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT2AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT2TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT2EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT3RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT3AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT3TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT3EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT4RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT4AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT4TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT4EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT5RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT5AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT5TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT5EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT6RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT6AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT6TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT6EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT7RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT7AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT7TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT7EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT8RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT8AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT8TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT8EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT9RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT9AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT9TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT9EFFECTIVEDATE,
DETAIL.SPLIT1RECOGNITIONCREDIT10RECIPIENT,
DETAIL.SPLIT1RECOGNITIONCREDIT10AMOUNT,
DETAIL.SPLIT1RECOGNITIONCREDIT10TYPE,
DETAIL.SPLIT1RECOGNITIONCREDIT10EFFECTIVEDATE,
DETAIL.DESIGNATION2NAME,
DETAIL.DESIGNATION2PUBLICNAME,
DETAIL.DESIGNATION2AMOUNT,
DETAIL.DESIGNATION2LOOKUPID,
DETAIL.SPLIT2RECOGNITIONCREDIT1RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT1AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT1TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT1EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT2RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT2AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT2TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT2EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT3RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT3AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT3TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT3EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT4RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT4AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT4TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT4EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT5RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT5AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT5TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT5EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT6RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT6AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT6TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT6EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT7RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT7AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT7TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT7EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT8RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT8AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT8TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT8EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT9RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT9AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT9TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT9EFFECTIVEDATE,
DETAIL.SPLIT2RECOGNITIONCREDIT10RECIPIENT,
DETAIL.SPLIT2RECOGNITIONCREDIT10AMOUNT,
DETAIL.SPLIT2RECOGNITIONCREDIT10TYPE,
DETAIL.SPLIT2RECOGNITIONCREDIT10EFFECTIVEDATE,
DETAIL.DESIGNATION3NAME,
DETAIL.DESIGNATION3PUBLICNAME,
DETAIL.DESIGNATION3AMOUNT,
DETAIL.DESIGNATION3LOOKUPID,
DETAIL.SPLIT3RECOGNITIONCREDIT1RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT1AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT1TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT1EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT2RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT2AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT2TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT2EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT3RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT3AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT3TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT3EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT4RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT4AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT4TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT4EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT5RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT5AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT5TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT5EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT6RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT6AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT6TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT6EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT7RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT7AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT7TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT7EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT8RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT8AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT8TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT8EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT9RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT9AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT9TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT9EFFECTIVEDATE,
DETAIL.SPLIT3RECOGNITIONCREDIT10RECIPIENT,
DETAIL.SPLIT3RECOGNITIONCREDIT10AMOUNT,
DETAIL.SPLIT3RECOGNITIONCREDIT10TYPE,
DETAIL.SPLIT3RECOGNITIONCREDIT10EFFECTIVEDATE,
DETAIL.DESIGNATION4NAME,
DETAIL.DESIGNATION4PUBLICNAME,
DETAIL.DESIGNATION4AMOUNT,
DETAIL.DESIGNATION4LOOKUPID,
DETAIL.SPLIT4RECOGNITIONCREDIT1RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT1AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT1TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT1EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT2RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT2AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT2TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT2EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT3RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT3AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT3TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT3EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT4RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT4AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT4TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT4EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT5RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT5AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT5TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT5EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT6RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT6AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT6TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT6EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT7RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT7AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT7TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT7EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT8RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT8AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT8TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT8EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT9RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT9AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT9TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT9EFFECTIVEDATE,
DETAIL.SPLIT4RECOGNITIONCREDIT10RECIPIENT,
DETAIL.SPLIT4RECOGNITIONCREDIT10AMOUNT,
DETAIL.SPLIT4RECOGNITIONCREDIT10TYPE,
DETAIL.SPLIT4RECOGNITIONCREDIT10EFFECTIVEDATE,
DETAIL.DESIGNATION5NAME,
DETAIL.DESIGNATION5PUBLICNAME,
DETAIL.DESIGNATION5AMOUNT,
DETAIL.DESIGNATION5LOOKUPID,
DETAIL.SPLIT5RECOGNITIONCREDIT1RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT1AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT1TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT1EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT2RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT2AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT2TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT2EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT3RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT3AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT3TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT3EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT4RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT4AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT4TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT4EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT5RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT5AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT5TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT5EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT6RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT6AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT6TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT6EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT7RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT7AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT7TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT7EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT8RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT8AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT8TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT8EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT9RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT9AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT9TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT9EFFECTIVEDATE,
DETAIL.SPLIT5RECOGNITIONCREDIT10RECIPIENT,
DETAIL.SPLIT5RECOGNITIONCREDIT10AMOUNT,
DETAIL.SPLIT5RECOGNITIONCREDIT10TYPE,
DETAIL.SPLIT5RECOGNITIONCREDIT10EFFECTIVEDATE,
DETAIL.REVENUELOOKUPID,
DETAIL.TRANSACTIONCURRENCYID,
DETAIL.BASECURRENCYID,
DETAIL.TOTALPLEDGEAMOUNTCURRENCY,
DETAIL.PLEDGEBALANCECURRENCY,
DETAIL.AMOUNTPAIDCURRENCY,
DETAIL.LASTPAYMENTAMOUNTCURRENCY,
DETAIL.DESIGNATION1AMOUNTCURRENCY,
DETAIL.DESIGNATION2AMOUNTCURRENCY,
DETAIL.DESIGNATION3AMOUNTCURRENCY,
DETAIL.DESIGNATION4AMOUNTCURRENCY,
DETAIL.DESIGNATION5AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT1AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT2AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT3AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT4AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT5AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT6AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT7AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT8AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT9AMOUNTCURRENCY,
DETAIL.SPLIT1RECOGNITIONCREDIT10AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT1AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT2AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT3AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT4AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT5AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT6AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT7AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT8AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT9AMOUNTCURRENCY,
DETAIL.SPLIT2RECOGNITIONCREDIT10AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT1AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT2AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT3AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT4AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT5AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT6AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT7AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT8AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT9AMOUNTCURRENCY,
DETAIL.SPLIT3RECOGNITIONCREDIT10AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT1AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT2AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT3AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT4AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT5AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT6AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT7AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT8AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT9AMOUNTCURRENCY,
DETAIL.SPLIT4RECOGNITIONCREDIT10AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT1AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT2AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT3AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT4AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT5AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT6AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT7AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT8AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT9AMOUNTCURRENCY,
DETAIL.SPLIT5RECOGNITIONCREDIT10AMOUNTCURRENCY
from dbo.UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDEDDETAILS2 (
@REVENUEID,
@NAMEFORMATPARAMETERID,
@ADDRESSPROCESSINGOPTIONID,
@PARAMETERSETID,
@SEASONALDATE,
@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) as DETAIL
inner join dbo.FINANCIALTRANSACTION on DETAIL.REVENUEID = FINANCIALTRANSACTION.ID
cross apply
dbo.UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDEDSUMMARY2 (
FINANCIALTRANSACTION.CONSTITUENTID,
@NAMEFORMATPARAMETERID,
@ADDRESSPROCESSINGOPTIONID,
@PARAMETERSETID,
@SEASONALDATE,
@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) as SUMMARY
)