UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDEDDETAILS
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @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_PLEDGEREMINDEROUTPUTEXTENDEDDETAILS]
(
@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 TOP(100) PERCENT
CONSTITUENTLOOKUPID,
REVENUEID,
TOTALPLEDGEAMOUNT,
GIVENANONYMOUSLY,
PLEDGEDATE,
PLEDGEBALANCE,
AMOUNTPAID,
APPEALNAME,
LASTPAYMENTDATE,
LASTPAYMENTAMOUNT,
-- Split 1
DESIGNATION1NAME,
DESIGNATION1PUBLICNAME,
DESIGNATION1AMOUNT,
DESIGNATION1LOOKUPID,
SPLIT1RECOGNITIONCREDIT1RECIPIENT,
SPLIT1RECOGNITIONCREDIT1AMOUNT,
SPLIT1RECOGNITIONCREDIT1TYPE,
SPLIT1RECOGNITIONCREDIT1EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT2RECIPIENT,
SPLIT1RECOGNITIONCREDIT2AMOUNT,
SPLIT1RECOGNITIONCREDIT2TYPE,
SPLIT1RECOGNITIONCREDIT2EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT3RECIPIENT,
SPLIT1RECOGNITIONCREDIT3AMOUNT,
SPLIT1RECOGNITIONCREDIT3TYPE,
SPLIT1RECOGNITIONCREDIT3EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT4RECIPIENT,
SPLIT1RECOGNITIONCREDIT4AMOUNT,
SPLIT1RECOGNITIONCREDIT4TYPE,
SPLIT1RECOGNITIONCREDIT4EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT5RECIPIENT,
SPLIT1RECOGNITIONCREDIT5AMOUNT,
SPLIT1RECOGNITIONCREDIT5TYPE,
SPLIT1RECOGNITIONCREDIT5EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT6RECIPIENT,
SPLIT1RECOGNITIONCREDIT6AMOUNT,
SPLIT1RECOGNITIONCREDIT6TYPE,
SPLIT1RECOGNITIONCREDIT6EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT7RECIPIENT,
SPLIT1RECOGNITIONCREDIT7AMOUNT,
SPLIT1RECOGNITIONCREDIT7TYPE,
SPLIT1RECOGNITIONCREDIT7EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT8RECIPIENT,
SPLIT1RECOGNITIONCREDIT8AMOUNT,
SPLIT1RECOGNITIONCREDIT8TYPE,
SPLIT1RECOGNITIONCREDIT8EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT9RECIPIENT,
SPLIT1RECOGNITIONCREDIT9AMOUNT,
SPLIT1RECOGNITIONCREDIT9TYPE,
SPLIT1RECOGNITIONCREDIT9EFFECTIVEDATE,
SPLIT1RECOGNITIONCREDIT10RECIPIENT,
SPLIT1RECOGNITIONCREDIT10AMOUNT,
SPLIT1RECOGNITIONCREDIT10TYPE,
SPLIT1RECOGNITIONCREDIT10EFFECTIVEDATE,
-- Split 2
DESIGNATION2NAME,
DESIGNATION2PUBLICNAME,
DESIGNATION2AMOUNT,
DESIGNATION2LOOKUPID,
SPLIT2RECOGNITIONCREDIT1RECIPIENT,
SPLIT2RECOGNITIONCREDIT1AMOUNT,
SPLIT2RECOGNITIONCREDIT1TYPE,
SPLIT2RECOGNITIONCREDIT1EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT2RECIPIENT,
SPLIT2RECOGNITIONCREDIT2AMOUNT,
SPLIT2RECOGNITIONCREDIT2TYPE,
SPLIT2RECOGNITIONCREDIT2EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT3RECIPIENT,
SPLIT2RECOGNITIONCREDIT3AMOUNT,
SPLIT2RECOGNITIONCREDIT3TYPE,
SPLIT2RECOGNITIONCREDIT3EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT4RECIPIENT,
SPLIT2RECOGNITIONCREDIT4AMOUNT,
SPLIT2RECOGNITIONCREDIT4TYPE,
SPLIT2RECOGNITIONCREDIT4EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT5RECIPIENT,
SPLIT2RECOGNITIONCREDIT5AMOUNT,
SPLIT2RECOGNITIONCREDIT5TYPE,
SPLIT2RECOGNITIONCREDIT5EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT6RECIPIENT,
SPLIT2RECOGNITIONCREDIT6AMOUNT,
SPLIT2RECOGNITIONCREDIT6TYPE,
SPLIT2RECOGNITIONCREDIT6EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT7RECIPIENT,
SPLIT2RECOGNITIONCREDIT7AMOUNT,
SPLIT2RECOGNITIONCREDIT7TYPE,
SPLIT2RECOGNITIONCREDIT7EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT8RECIPIENT,
SPLIT2RECOGNITIONCREDIT8AMOUNT,
SPLIT2RECOGNITIONCREDIT8TYPE,
SPLIT2RECOGNITIONCREDIT8EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT9RECIPIENT,
SPLIT2RECOGNITIONCREDIT9AMOUNT,
SPLIT2RECOGNITIONCREDIT9TYPE,
SPLIT2RECOGNITIONCREDIT9EFFECTIVEDATE,
SPLIT2RECOGNITIONCREDIT10RECIPIENT,
SPLIT2RECOGNITIONCREDIT10AMOUNT,
SPLIT2RECOGNITIONCREDIT10TYPE,
SPLIT2RECOGNITIONCREDIT10EFFECTIVEDATE,
-- Split 3
DESIGNATION3NAME,
DESIGNATION3PUBLICNAME,
DESIGNATION3AMOUNT,
DESIGNATION3LOOKUPID,
SPLIT3RECOGNITIONCREDIT1RECIPIENT,
SPLIT3RECOGNITIONCREDIT1AMOUNT,
SPLIT3RECOGNITIONCREDIT1TYPE,
SPLIT3RECOGNITIONCREDIT1EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT2RECIPIENT,
SPLIT3RECOGNITIONCREDIT2AMOUNT,
SPLIT3RECOGNITIONCREDIT2TYPE,
SPLIT3RECOGNITIONCREDIT2EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT3RECIPIENT,
SPLIT3RECOGNITIONCREDIT3AMOUNT,
SPLIT3RECOGNITIONCREDIT3TYPE,
SPLIT3RECOGNITIONCREDIT3EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT4RECIPIENT,
SPLIT3RECOGNITIONCREDIT4AMOUNT,
SPLIT3RECOGNITIONCREDIT4TYPE,
SPLIT3RECOGNITIONCREDIT4EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT5RECIPIENT,
SPLIT3RECOGNITIONCREDIT5AMOUNT,
SPLIT3RECOGNITIONCREDIT5TYPE,
SPLIT3RECOGNITIONCREDIT5EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT6RECIPIENT,
SPLIT3RECOGNITIONCREDIT6AMOUNT,
SPLIT3RECOGNITIONCREDIT6TYPE,
SPLIT3RECOGNITIONCREDIT6EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT7RECIPIENT,
SPLIT3RECOGNITIONCREDIT7AMOUNT,
SPLIT3RECOGNITIONCREDIT7TYPE,
SPLIT3RECOGNITIONCREDIT7EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT8RECIPIENT,
SPLIT3RECOGNITIONCREDIT8AMOUNT,
SPLIT3RECOGNITIONCREDIT8TYPE,
SPLIT3RECOGNITIONCREDIT8EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT9RECIPIENT,
SPLIT3RECOGNITIONCREDIT9AMOUNT,
SPLIT3RECOGNITIONCREDIT9TYPE,
SPLIT3RECOGNITIONCREDIT9EFFECTIVEDATE,
SPLIT3RECOGNITIONCREDIT10RECIPIENT,
SPLIT3RECOGNITIONCREDIT10AMOUNT,
SPLIT3RECOGNITIONCREDIT10TYPE,
SPLIT3RECOGNITIONCREDIT10EFFECTIVEDATE,
-- Split 4
DESIGNATION4NAME,
DESIGNATION4PUBLICNAME,
DESIGNATION4AMOUNT,
DESIGNATION4LOOKUPID,
SPLIT4RECOGNITIONCREDIT1RECIPIENT,
SPLIT4RECOGNITIONCREDIT1AMOUNT,
SPLIT4RECOGNITIONCREDIT1TYPE,
SPLIT4RECOGNITIONCREDIT1EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT2RECIPIENT,
SPLIT4RECOGNITIONCREDIT2AMOUNT,
SPLIT4RECOGNITIONCREDIT2TYPE,
SPLIT4RECOGNITIONCREDIT2EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT3RECIPIENT,
SPLIT4RECOGNITIONCREDIT3AMOUNT,
SPLIT4RECOGNITIONCREDIT3TYPE,
SPLIT4RECOGNITIONCREDIT3EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT4RECIPIENT,
SPLIT4RECOGNITIONCREDIT4AMOUNT,
SPLIT4RECOGNITIONCREDIT4TYPE,
SPLIT4RECOGNITIONCREDIT4EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT5RECIPIENT,
SPLIT4RECOGNITIONCREDIT5AMOUNT,
SPLIT4RECOGNITIONCREDIT5TYPE,
SPLIT4RECOGNITIONCREDIT5EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT6RECIPIENT,
SPLIT4RECOGNITIONCREDIT6AMOUNT,
SPLIT4RECOGNITIONCREDIT6TYPE,
SPLIT4RECOGNITIONCREDIT6EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT7RECIPIENT,
SPLIT4RECOGNITIONCREDIT7AMOUNT,
SPLIT4RECOGNITIONCREDIT7TYPE,
SPLIT4RECOGNITIONCREDIT7EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT8RECIPIENT,
SPLIT4RECOGNITIONCREDIT8AMOUNT,
SPLIT4RECOGNITIONCREDIT8TYPE,
SPLIT4RECOGNITIONCREDIT8EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT9RECIPIENT,
SPLIT4RECOGNITIONCREDIT9AMOUNT,
SPLIT4RECOGNITIONCREDIT9TYPE,
SPLIT4RECOGNITIONCREDIT9EFFECTIVEDATE,
SPLIT4RECOGNITIONCREDIT10RECIPIENT,
SPLIT4RECOGNITIONCREDIT10AMOUNT,
SPLIT4RECOGNITIONCREDIT10TYPE,
SPLIT4RECOGNITIONCREDIT10EFFECTIVEDATE,
-- Split 5
DESIGNATION5NAME,
DESIGNATION5PUBLICNAME,
DESIGNATION5AMOUNT,
DESIGNATION5LOOKUPID,
SPLIT5RECOGNITIONCREDIT1RECIPIENT,
SPLIT5RECOGNITIONCREDIT1AMOUNT,
SPLIT5RECOGNITIONCREDIT1TYPE,
SPLIT5RECOGNITIONCREDIT1EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT2RECIPIENT,
SPLIT5RECOGNITIONCREDIT2AMOUNT,
SPLIT5RECOGNITIONCREDIT2TYPE,
SPLIT5RECOGNITIONCREDIT2EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT3RECIPIENT,
SPLIT5RECOGNITIONCREDIT3AMOUNT,
SPLIT5RECOGNITIONCREDIT3TYPE,
SPLIT5RECOGNITIONCREDIT3EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT4RECIPIENT,
SPLIT5RECOGNITIONCREDIT4AMOUNT,
SPLIT5RECOGNITIONCREDIT4TYPE,
SPLIT5RECOGNITIONCREDIT4EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT5RECIPIENT,
SPLIT5RECOGNITIONCREDIT5AMOUNT,
SPLIT5RECOGNITIONCREDIT5TYPE,
SPLIT5RECOGNITIONCREDIT5EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT6RECIPIENT,
SPLIT5RECOGNITIONCREDIT6AMOUNT,
SPLIT5RECOGNITIONCREDIT6TYPE,
SPLIT5RECOGNITIONCREDIT6EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT7RECIPIENT,
SPLIT5RECOGNITIONCREDIT7AMOUNT,
SPLIT5RECOGNITIONCREDIT7TYPE,
SPLIT5RECOGNITIONCREDIT7EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT8RECIPIENT,
SPLIT5RECOGNITIONCREDIT8AMOUNT,
SPLIT5RECOGNITIONCREDIT8TYPE,
SPLIT5RECOGNITIONCREDIT8EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT9RECIPIENT,
SPLIT5RECOGNITIONCREDIT9AMOUNT,
SPLIT5RECOGNITIONCREDIT9TYPE,
SPLIT5RECOGNITIONCREDIT9EFFECTIVEDATE,
SPLIT5RECOGNITIONCREDIT10RECIPIENT,
SPLIT5RECOGNITIONCREDIT10AMOUNT,
SPLIT5RECOGNITIONCREDIT10TYPE,
SPLIT5RECOGNITIONCREDIT10EFFECTIVEDATE,
REVENUELOOKUPID,
TRANSACTIONCURRENCYID,
BASECURRENCYID,
TOTALPLEDGEAMOUNTCURRENCY,
PLEDGEBALANCECURRENCY,
AMOUNTPAIDCURRENCY,
LASTPAYMENTAMOUNTCURRENCY,
DESIGNATION1AMOUNTCURRENCY,
DESIGNATION2AMOUNTCURRENCY,
DESIGNATION3AMOUNTCURRENCY,
DESIGNATION4AMOUNTCURRENCY,
DESIGNATION5AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT1AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT2AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT3AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT4AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT5AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT6AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT7AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT8AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT9AMOUNTCURRENCY,
SPLIT1RECOGNITIONCREDIT10AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT1AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT2AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT3AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT4AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT5AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT6AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT7AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT8AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT9AMOUNTCURRENCY,
SPLIT2RECOGNITIONCREDIT10AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT1AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT2AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT3AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT4AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT5AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT6AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT7AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT8AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT9AMOUNTCURRENCY,
SPLIT3RECOGNITIONCREDIT10AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT1AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT2AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT3AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT4AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT5AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT6AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT7AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT8AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT9AMOUNTCURRENCY,
SPLIT4RECOGNITIONCREDIT10AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT1AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT2AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT3AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT4AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT5AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT6AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT7AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT8AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT9AMOUNTCURRENCY,
SPLIT5RECOGNITIONCREDIT10AMOUNTCURRENCY
from dbo.UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDED(
@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
)
order by CONSTITUENTLOOKUPID
)