V_QUERY_ACKNOWLEDGEMENTPROCESSPLEDGEOUTPUTEXTENDED
View used for pledge output for the acknowledgement process.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| REVENUEID | uniqueidentifier | System record ID | |
| CONSTITUENTNAME | nvarchar(154) | yes | Constituent name |
| CONSTITUENTLOOKUPID | nvarchar(100) | yes | Constituent lookup ID |
| PRIMARYADDRESSEE | nvarchar(700) | yes | Primary addressee |
| PRIMARYSALUTATION | nvarchar(700) | yes | Primary salutation |
| PRIMARYCONTACT | nvarchar(154) | yes | Primary contact |
| ADDRESSBLOCK | nvarchar(150) | yes | Address block |
| CITY | nvarchar(50) | yes | City |
| STATE | nvarchar(50) | yes | State |
| POSTCODE | nvarchar(12) | yes | Post code |
| COUNTRY | nvarchar(100) | yes | Country |
| EMAILADDRESS | UDT_EMAILADDRESS | yes | Email address |
| TOTALPLEDGEAMOUNT | money | Total pledge amount | |
| PLEDGEDATE | datetimeoffset | Pledge date | |
| FREQUENCY | nvarchar(18) | yes | Frequency |
| STARTDATE | datetime | yes | Start date |
| NUMBEROFINSTALLMENTS | int | yes | Number of installments |
| FIRSTDUEDATE | datetime | yes | First installment due date |
| FIRSTINSTALLMENTAMOUNT | money | yes | First installment amount |
| SENDPLEDGEREMINDER | varchar(3) | Send pledge reminder | |
| GIVENANONYMOUSLY | varchar(3) | Anonymous | |
| ISFIRSTGIFT | varchar(3) | First gift | |
| APPEALNAME | nvarchar(100) | yes | Appeal name |
| POSITION | nvarchar(100) | yes | Position |
| REVENUELETTERID | uniqueidentifier | Revenue letter ID | |
| DONORADDRESSEE | nvarchar(700) | yes | Donor primary addressee |
| DONORADDRESSBLOCK | nvarchar(150) | yes | Donor address block |
| DONORCITY | nvarchar(50) | yes | Donor city |
| DONORSTATE | nvarchar(50) | yes | Donor state |
| DONORPOSTCODE | nvarchar(12) | yes | Donor post code |
| DONORCOUNTRY | nvarchar(100) | yes | Donor country |
| DONOREMAILADDRESS | UDT_EMAILADDRESS | yes | Donor email address |
| DDIACCOUNTHOLDER | nvarchar(154) | yes | Direct debit account holder |
| DDIACCOUNTHOLDERADDRESSBLOCK | nvarchar(150) | yes | Direct debit account holder address block |
| DDIACCOUNTHOLDERCITY | nvarchar(50) | yes | Direct debit account holder city |
| DDIACCOUNTHOLDERSTATE | nvarchar(50) | yes | Direct debit account holder state |
| DDIACCOUNTHOLDERPOSTCODE | nvarchar(12) | yes | Direct debit account holder post code |
| DDIACCOUNTHOLDERCOUNTRY | nvarchar(100) | yes | Direct debit account holder country |
| DDIACCOUNTNUMBER | nvarchar(50) | yes | Direct debit account number |
| DDIACCOUNTBANK | nvarchar(100) | yes | Direct debit financial institution |
| DDIACCOUNTBRANCH | nvarchar(100) | yes | Direct debit branch |
| DDIACCOUNTBANKADDRESSBLOCK | nvarchar(150) | yes | Direct debit financial institution address block |
| DDIACCOUNTBANKCITY | nvarchar(50) | yes | Direct debit financial institution city |
| DDIACCOUNTBANKSTATE | nvarchar(50) | yes | Direct debit financial institution state |
| DDIACCOUNTBANKPOSTCODE | nvarchar(12) | yes | Direct debit financial institution post code |
| DDIACCOUNTBANKCOUNTRY | nvarchar(100) | yes | Direct debit financial institution country |
| DDINUMBEROFINSTALLMENTS | int | yes | Direct debit number of installments |
| DDIFREQUENCY | nvarchar(18) | yes | Direct debit frequency |
| DDISTARTDATE | datetime | yes | Direct debit start date |
| DDIENDDATE | date | yes | Direct debit end date |
| DDIINSTALLMENTAMOUNT | money | yes | Direct debit installment amount |
| DDINAMEONACCOUNT | nvarchar(100) | yes | Direct debit name on account |
| AMOUNTWITHGIFTAID | money | yes | Amount with Gift Aid |
| OTHERPAYMENTMETHOD | nvarchar(100) | yes | Other payment method |
| REFERENCE | nvarchar(255) | yes | Transaction reference |
| TRIBUTE1TYPE | nvarchar(100) | yes | Tribute 1 type |
| TRIBUTE1TRIBUTEE | nvarchar(154) | yes | Tribute 1 tributee |
| TRIBUTE1TRIBUTETEXT | nvarchar(255) | yes | Tribute 1 tribute text |
| TRIBUTE1DEFAULTDESIGNATION | nvarchar(512) | yes | Tribute 1 default designation |
| TRIBUTE1AMOUNT | money | yes | Tribute 1 amount |
| TRIBUTE2TYPE | nvarchar(100) | yes | Tribute 2 type |
| TRIBUTE2TRIBUTEE | nvarchar(154) | yes | Tribute 2 tributee |
| TRIBUTE2TRIBUTETEXT | nvarchar(255) | yes | Tribute 2 tribute text |
| TRIBUTE2DEFAULTDESIGNATION | nvarchar(512) | yes | Tribute 2 default designation |
| TRIBUTE2AMOUNT | money | yes | Tribute 2 amount |
| TRIBUTE3TYPE | nvarchar(100) | yes | Tribute 3 type |
| TRIBUTE3TRIBUTEE | nvarchar(154) | yes | Tribute 3 tributee |
| TRIBUTE3TRIBUTETEXT | nvarchar(255) | yes | Tribute 3 tribute text |
| TRIBUTE3DEFAULTDESIGNATION | nvarchar(512) | yes | Tribute 3 default designation |
| TRIBUTE3AMOUNT | money | yes | Tribute 3 amount |
| TRIBUTE4TYPE | nvarchar(100) | yes | Tribute 4 type |
| TRIBUTE4TRIBUTEE | nvarchar(154) | yes | Tribute 4 tributee |
| TRIBUTE4TRIBUTETEXT | nvarchar(255) | yes | Tribute 4 tribute text |
| TRIBUTE4DEFAULTDESIGNATION | nvarchar(512) | yes | Tribute 4 default designation |
| TRIBUTE4AMOUNT | money | yes | Tribute 4 amount |
| TRIBUTE5TYPE | nvarchar(100) | yes | Tribute 5 type |
| TRIBUTE5TRIBUTEE | nvarchar(154) | yes | Tribute 5 tributee |
| TRIBUTE5TRIBUTETEXT | nvarchar(255) | yes | Tribute 5 tribute text |
| TRIBUTE5DEFAULTDESIGNATION | nvarchar(512) | yes | Tribute 5 default designation |
| TRIBUTE5AMOUNT | money | yes | Tribute 5 amount |
| MATCHINGGIFT1ORGANIZATION | nvarchar(154) | yes | Matching gift 1 organization |
| MATCHINGGIFT1CONDITIONTYPE | nvarchar(100) | yes | Matching gift 1 condition type |
| MATCHINGGIFT1AMOUNT | money | yes | Matching gift 1 amount |
| MATCHINGGIFT2ORGANIZATION | nvarchar(154) | yes | Matching gift 2 organization |
| MATCHINGGIFT2CONDITIONTYPE | nvarchar(100) | yes | Matching gift 2 condition type |
| MATCHINGGIFT2AMOUNT | money | yes | Matching gift 2 amount |
| MATCHINGGIFT3ORGANIZATION | nvarchar(154) | yes | Matching gift 3 organization |
| MATCHINGGIFT3CONDITIONTYPE | nvarchar(100) | yes | Matching gift 3 condition type |
| MATCHINGGIFT3AMOUNT | money | yes | Matching gift 3 amount |
| BENEFITSWAIVED | varchar(3) | Benefit waived | |
| BENEFIT1NAME | nvarchar(100) | yes | Benefit 1 |
| BENEFIT1QUANTITY | decimal(20, 4) | yes | Benefit 1 quantity |
| BENEFIT1UNITVALUE | money | yes | Benefit 1 unit cost |
| BENEFIT1TOTALVALUE | money | yes | Benefit 1 total value |
| BENEFIT2NAME | nvarchar(100) | yes | Benefit 2 |
| BENEFIT2QUANTITY | decimal(20, 4) | yes | Benefit 2 quantity |
| BENEFIT2UNITVALUE | money | yes | Benefit 2 unit cost |
| BENEFIT2TOTALVALUE | money | yes | Benefit 2 total value |
| BENEFIT3NAME | nvarchar(100) | yes | Benefit 3 |
| BENEFIT3QUANTITY | decimal(20, 4) | yes | Benefit 3 quantity |
| BENEFIT3UNITVALUE | money | yes | Benefit 3 unit cost |
| BENEFIT3TOTALVALUE | money | yes | Benefit 3 total value |
| BENEFIT4NAME | nvarchar(100) | yes | Benefit 4 |
| BENEFIT4QUANTITY | decimal(20, 4) | yes | Benefit 4 quantity |
| BENEFIT4UNITVALUE | money | yes | Benefit 4 unit cost |
| BENEFIT4TOTALVALUE | money | yes | Benefit 4 total value |
| BENEFIT5NAME | nvarchar(100) | yes | Benefit 5 |
| BENEFIT5QUANTITY | decimal(20, 4) | yes | Benefit 5 quantity |
| BENEFIT5UNITVALUE | money | yes | Benefit 5 unit cost |
| BENEFIT5TOTALVALUE | money | yes | Benefit 5 total value |
| APPLICATION1TYPE | nvarchar(27) | yes | Application 1 type |
| DESIGNATION1NAME | nvarchar(100) | yes | Designation 1 |
| DESIGNATION1PUBLICNAME | nvarchar(512) | yes | Designation 1 public name |
| DESIGNATION1AMOUNT | money | yes | Designation 1 amount |
| DESIGNATION1ADMINISTRATOR | nvarchar(154) | yes | Application 1 designation administrator |
| DESIGNATION1LOOKUPID | nvarchar(512) | yes | Application 1 designation lookup ID |
| SPLIT1CAMPAIGN1NAME | nvarchar(100) | yes | Application 1 campaign 1 |
| SPLIT1CAMPAIGN2NAME | nvarchar(100) | yes | Application 1 campaign 2 |
| SPLIT1CAMPAIGN3NAME | nvarchar(100) | yes | Application 1 campaign 3 |
| SPLIT1CAMPAIGN4NAME | nvarchar(100) | yes | Application 1 campaign 4 |
| SPLIT1CAMPAIGN5NAME | nvarchar(100) | yes | Application 1 campaign 5 |
| SPLIT1CAMPAIGN6NAME | nvarchar(100) | yes | Application 1 campaign 6 |
| SPLIT1CAMPAIGN7NAME | nvarchar(100) | yes | Application 1 campaign 7 |
| SPLIT1CAMPAIGN8NAME | nvarchar(100) | yes | Application 1 campaign 8 |
| SPLIT1CAMPAIGN9NAME | nvarchar(100) | yes | Application 1 campaign 9 |
| SPLIT1CAMPAIGN10NAME | nvarchar(100) | yes | Application 1 campaign 10 |
| MEMBERSHIP1PROGRAM | nvarchar(100) | yes | Application 1 membership program |
| MEMBERSHIP1LEVEL | nvarchar(100) | yes | Application 1 membership level |
| MEMBERSHIP1EXPIRATIONDATE | datetime | yes | Application 1 expiration date |
| PLEDGE1CONSTITUENT | nvarchar(154) | yes | Application 1 constituent on pledge |
| PLEDGE1AMOUNT | money | yes | Application 1 pledge amount |
| PLEDGE1DATE | datetime | yes | Application 1 pledge date |
| PLEDGE1BALANCE | money | yes | Application 1 pledge balance |
| SPLIT1RECOGNITIONCREDIT1RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 1 recipient |
| SPLIT1RECOGNITIONCREDIT1AMOUNT | money | yes | Application 1 recognition credit 1 amount |
| SPLIT1RECOGNITIONCREDIT1TYPE | nvarchar(100) | yes | Application 1 recognition credit 1 type |
| SPLIT1RECOGNITIONCREDIT1EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 1 effective date |
| SPLIT1RECOGNITIONCREDIT2RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 2 recipient |
| SPLIT1RECOGNITIONCREDIT2AMOUNT | money | yes | Application 1 recognition credit 2 amount |
| SPLIT1RECOGNITIONCREDIT2TYPE | nvarchar(100) | yes | Application 1 recognition credit 2 type |
| SPLIT1RECOGNITIONCREDIT2EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 2 effective date |
| SPLIT1RECOGNITIONCREDIT3RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 3 recipient |
| SPLIT1RECOGNITIONCREDIT3AMOUNT | money | yes | Application 1 recognition credit 3 amount |
| SPLIT1RECOGNITIONCREDIT3TYPE | nvarchar(100) | yes | Application 1 recognition credit 3 type |
| SPLIT1RECOGNITIONCREDIT3EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 3 effective date |
| SPLIT1RECOGNITIONCREDIT4RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 4 recipient |
| SPLIT1RECOGNITIONCREDIT4AMOUNT | money | yes | Application 1 recognition credit 4 amount |
| SPLIT1RECOGNITIONCREDIT4TYPE | nvarchar(100) | yes | Application 1 recognition credit 4 type |
| SPLIT1RECOGNITIONCREDIT4EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 4 effective date |
| SPLIT1RECOGNITIONCREDIT5RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 5 recipient |
| SPLIT1RECOGNITIONCREDIT5AMOUNT | money | yes | Application 1 recognition credit 5 amount |
| SPLIT1RECOGNITIONCREDIT5TYPE | nvarchar(100) | yes | Application 1 recognition credit 5 type |
| SPLIT1RECOGNITIONCREDIT5EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 5 effective date |
| SPLIT1RECOGNITIONCREDIT6RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 6 recipient |
| SPLIT1RECOGNITIONCREDIT6AMOUNT | money | yes | Application 1 recognition credit 6 amount |
| SPLIT1RECOGNITIONCREDIT6TYPE | nvarchar(100) | yes | Application 1 recognition credit 6 type |
| SPLIT1RECOGNITIONCREDIT6EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 6 effective date |
| SPLIT1RECOGNITIONCREDIT7RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 7 recipient |
| SPLIT1RECOGNITIONCREDIT7AMOUNT | money | yes | Application 1 recognition credit 7 amount |
| SPLIT1RECOGNITIONCREDIT7TYPE | nvarchar(100) | yes | Application 1 recognition credit 7 type |
| SPLIT1RECOGNITIONCREDIT7EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 7 effective date |
| SPLIT1RECOGNITIONCREDIT8RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 8 recipient |
| SPLIT1RECOGNITIONCREDIT8AMOUNT | money | yes | Application 1 recognition credit 8 amount |
| SPLIT1RECOGNITIONCREDIT8TYPE | nvarchar(100) | yes | Application 1 recognition credit 8 type |
| SPLIT1RECOGNITIONCREDIT8EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 8 effective date |
| SPLIT1RECOGNITIONCREDIT9RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 9 recipient |
| SPLIT1RECOGNITIONCREDIT9AMOUNT | money | yes | Application 1 recognition credit 9 amount |
| SPLIT1RECOGNITIONCREDIT9TYPE | nvarchar(100) | yes | Application 1 recognition credit 9 type |
| SPLIT1RECOGNITIONCREDIT9EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 9 effective date |
| SPLIT1RECOGNITIONCREDIT10RECIPIENT | nvarchar(154) | yes | Application 1 recognition credit 10 recipient |
| SPLIT1RECOGNITIONCREDIT10AMOUNT | money | yes | Application 1 recognition credit 10 amount |
| SPLIT1RECOGNITIONCREDIT10TYPE | nvarchar(100) | yes | Application 1 recognition credit 10 type |
| SPLIT1RECOGNITIONCREDIT10EFFECTIVEDATE | datetime | yes | Application 1 recognition credit 10 effective date |
| APPLICATION2TYPE | nvarchar(27) | yes | Application 2 type |
| DESIGNATION2NAME | nvarchar(100) | yes | Designation 2 |
| DESIGNATION2PUBLICNAME | nvarchar(512) | yes | Designation 2 public name |
| DESIGNATION2AMOUNT | money | yes | Designation 2 amount |
| DESIGNATION2ADMINISTRATOR | nvarchar(154) | yes | Application 2 designation administrator |
| DESIGNATION2LOOKUPID | nvarchar(512) | yes | Application 2 designation lookup ID |
| SPLIT2CAMPAIGN1NAME | nvarchar(100) | yes | Application 2 campaign 1 |
| SPLIT2CAMPAIGN2NAME | nvarchar(100) | yes | Application 2 campaign 2 |
| SPLIT2CAMPAIGN3NAME | nvarchar(100) | yes | Application 2 campaign 3 |
| SPLIT2CAMPAIGN4NAME | nvarchar(100) | yes | Application 2 campaign 4 |
| SPLIT2CAMPAIGN5NAME | nvarchar(100) | yes | Application 2 campaign 5 |
| SPLIT2CAMPAIGN6NAME | nvarchar(100) | yes | Application 2 campaign 6 |
| SPLIT2CAMPAIGN7NAME | nvarchar(100) | yes | Application 2 campaign 7 |
| SPLIT2CAMPAIGN8NAME | nvarchar(100) | yes | Application 2 campaign 8 |
| SPLIT2CAMPAIGN9NAME | nvarchar(100) | yes | Application 2 campaign 9 |
| SPLIT2CAMPAIGN10NAME | nvarchar(100) | yes | Application 2 campaign 10 |
| MEMBERSHIP2PROGRAM | nvarchar(100) | yes | Application 2 membership program |
| MEMBERSHIP2LEVEL | nvarchar(100) | yes | Application 2 membership level |
| MEMBERSHIP2EXPIRATIONDATE | datetime | yes | Application 2 expiration date |
| PLEDGE2CONSTITUENT | nvarchar(154) | yes | Application 2 constituent on pledge |
| PLEDGE2AMOUNT | money | yes | Application 2 pledge amount |
| PLEDGE2DATE | datetime | yes | Application 2 pledge date |
| PLEDGE2BALANCE | money | yes | Application 2 pledge balance |
| SPLIT2RECOGNITIONCREDIT1RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 1 recipient |
| SPLIT2RECOGNITIONCREDIT1AMOUNT | money | yes | Application 2 recognition credit 1 amount |
| SPLIT2RECOGNITIONCREDIT1TYPE | nvarchar(100) | yes | Application 2 recognition credit 1 type |
| SPLIT2RECOGNITIONCREDIT1EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 1 effective date |
| SPLIT2RECOGNITIONCREDIT2RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 2 recipient |
| SPLIT2RECOGNITIONCREDIT2AMOUNT | money | yes | Application 2 recognition credit 2 amount |
| SPLIT2RECOGNITIONCREDIT2TYPE | nvarchar(100) | yes | Application 2 recognition credit 2 type |
| SPLIT2RECOGNITIONCREDIT2EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 2 effective date |
| SPLIT2RECOGNITIONCREDIT3RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 3 recipient |
| SPLIT2RECOGNITIONCREDIT3AMOUNT | money | yes | Application 2 recognition credit 3 amount |
| SPLIT2RECOGNITIONCREDIT3TYPE | nvarchar(100) | yes | Application 2 recognition credit 3 type |
| SPLIT2RECOGNITIONCREDIT3EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 3 effective date |
| SPLIT2RECOGNITIONCREDIT4RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 4 recipient |
| SPLIT2RECOGNITIONCREDIT4AMOUNT | money | yes | Application 2 recognition credit 4 amount |
| SPLIT2RECOGNITIONCREDIT4TYPE | nvarchar(100) | yes | Application 2 recognition credit 4 type |
| SPLIT2RECOGNITIONCREDIT4EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 4 effective date |
| SPLIT2RECOGNITIONCREDIT5RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 5 recipient |
| SPLIT2RECOGNITIONCREDIT5AMOUNT | money | yes | Application 2 recognition credit 5 amount |
| SPLIT2RECOGNITIONCREDIT5TYPE | nvarchar(100) | yes | Application 2 recognition credit 5 type |
| SPLIT2RECOGNITIONCREDIT5EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 5 effective date |
| SPLIT2RECOGNITIONCREDIT6RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 6 recipient |
| SPLIT2RECOGNITIONCREDIT6AMOUNT | money | yes | Application 2 recognition credit 6 amount |
| SPLIT2RECOGNITIONCREDIT6TYPE | nvarchar(100) | yes | Application 2 recognition credit 6 type |
| SPLIT2RECOGNITIONCREDIT6EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 6 effective date |
| SPLIT2RECOGNITIONCREDIT7RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 7 recipient |
| SPLIT2RECOGNITIONCREDIT7AMOUNT | money | yes | Application 2 recognition credit 7 amount |
| SPLIT2RECOGNITIONCREDIT7TYPE | nvarchar(100) | yes | Application 2 recognition credit 7 type |
| SPLIT2RECOGNITIONCREDIT7EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 7 effective date |
| SPLIT2RECOGNITIONCREDIT8RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 8 recipient |
| SPLIT2RECOGNITIONCREDIT8AMOUNT | money | yes | Application 2 recognition credit 8 amount |
| SPLIT2RECOGNITIONCREDIT8TYPE | nvarchar(100) | yes | Application 2 recognition credit 8 type |
| SPLIT2RECOGNITIONCREDIT8EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 8 effective date |
| SPLIT2RECOGNITIONCREDIT9RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 9 recipient |
| SPLIT2RECOGNITIONCREDIT9AMOUNT | money | yes | Application 2 recognition credit 9 amount |
| SPLIT2RECOGNITIONCREDIT9TYPE | nvarchar(100) | yes | Application 2 recognition credit 9 type |
| SPLIT2RECOGNITIONCREDIT9EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 9 effective date |
| SPLIT2RECOGNITIONCREDIT10RECIPIENT | nvarchar(154) | yes | Application 2 recognition credit 10 recipient |
| SPLIT2RECOGNITIONCREDIT10AMOUNT | money | yes | Application 2 recognition credit 10 amount |
| SPLIT2RECOGNITIONCREDIT10TYPE | nvarchar(100) | yes | Application 2 recognition credit 10 type |
| SPLIT2RECOGNITIONCREDIT10EFFECTIVEDATE | datetime | yes | Application 2 recognition credit 10 effective date |
| APPLICATION3TYPE | nvarchar(27) | yes | Application 3 type |
| DESIGNATION3NAME | nvarchar(100) | yes | Application 3 designation |
| DESIGNATION3PUBLICNAME | nvarchar(512) | yes | Application 3 designation public name |
| DESIGNATION3AMOUNT | money | yes | Application 3 amount |
| DESIGNATION3ADMINISTRATOR | nvarchar(154) | yes | Application 3 designation administrator |
| DESIGNATION3LOOKUPID | nvarchar(512) | yes | Application 3 designation lookup ID |
| SPLIT3CAMPAIGN1NAME | nvarchar(100) | yes | Application 3 campaign 1 |
| SPLIT3CAMPAIGN2NAME | nvarchar(100) | yes | Application 3 campaign 2 |
| SPLIT3CAMPAIGN3NAME | nvarchar(100) | yes | Application 3 campaign 3 |
| SPLIT3CAMPAIGN4NAME | nvarchar(100) | yes | Application 3 campaign 4 |
| SPLIT3CAMPAIGN5NAME | nvarchar(100) | yes | Application 3 campaign 5 |
| SPLIT3CAMPAIGN6NAME | nvarchar(100) | yes | Application 3 campaign 6 |
| SPLIT3CAMPAIGN7NAME | nvarchar(100) | yes | Application 3 campaign 7 |
| SPLIT3CAMPAIGN8NAME | nvarchar(100) | yes | Application 3 campaign 8 |
| SPLIT3CAMPAIGN9NAME | nvarchar(100) | yes | Application 3 campaign 9 |
| SPLIT3CAMPAIGN10NAME | nvarchar(100) | yes | Application 3 campaign 10 |
| MEMBERSHIP3PROGRAM | nvarchar(100) | yes | Application 3 membership program |
| MEMBERSHIP3LEVEL | nvarchar(100) | yes | Application 3 membership level |
| MEMBERSHIP3EXPIRATIONDATE | datetime | yes | Application 3 expiration date |
| PLEDGE3CONSTITUENT | nvarchar(154) | yes | Application 3 constituent on pledge |
| PLEDGE3AMOUNT | money | yes | Application 3 pledge amount |
| PLEDGE3DATE | datetime | yes | Application 3 pledge date |
| PLEDGE3BALANCE | money | yes | Application 3 pledge balance |
| SPLIT3RECOGNITIONCREDIT1RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 1 recipient |
| SPLIT3RECOGNITIONCREDIT1AMOUNT | money | yes | Application 3 recognition credit 1 amount |
| SPLIT3RECOGNITIONCREDIT1TYPE | nvarchar(100) | yes | Application 3 recognition credit 1 type |
| SPLIT3RECOGNITIONCREDIT1EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 1 effective date |
| SPLIT3RECOGNITIONCREDIT2RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 2 recipient |
| SPLIT3RECOGNITIONCREDIT2AMOUNT | money | yes | Application 3 recognition credit 2 amount |
| SPLIT3RECOGNITIONCREDIT2TYPE | nvarchar(100) | yes | Application 3 recognition credit 2 type |
| SPLIT3RECOGNITIONCREDIT2EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 2 effective date |
| SPLIT3RECOGNITIONCREDIT3RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 3 recipient |
| SPLIT3RECOGNITIONCREDIT3AMOUNT | money | yes | Application 3 recognition credit 3 amount |
| SPLIT3RECOGNITIONCREDIT3TYPE | nvarchar(100) | yes | Application 3 recognition credit 3 type |
| SPLIT3RECOGNITIONCREDIT3EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 3 effective date |
| SPLIT3RECOGNITIONCREDIT4RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 4 recipient |
| SPLIT3RECOGNITIONCREDIT4AMOUNT | money | yes | Application 3 recognition credit 4 amount |
| SPLIT3RECOGNITIONCREDIT4TYPE | nvarchar(100) | yes | Application 3 recognition credit 4 type |
| SPLIT3RECOGNITIONCREDIT4EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 4 effective date |
| SPLIT3RECOGNITIONCREDIT5RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 5 recipient |
| SPLIT3RECOGNITIONCREDIT5AMOUNT | money | yes | Application 3 recognition credit 5 amount |
| SPLIT3RECOGNITIONCREDIT5TYPE | nvarchar(100) | yes | Application 3 recognition credit 5 type |
| SPLIT3RECOGNITIONCREDIT5EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 5 effective date |
| SPLIT3RECOGNITIONCREDIT6RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 6 recipient |
| SPLIT3RECOGNITIONCREDIT6AMOUNT | money | yes | Application 3 recognition credit 6 amount |
| SPLIT3RECOGNITIONCREDIT6TYPE | nvarchar(100) | yes | Application 3 recognition credit 6 type |
| SPLIT3RECOGNITIONCREDIT6EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 6 effective date |
| SPLIT3RECOGNITIONCREDIT7RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 7 recipient |
| SPLIT3RECOGNITIONCREDIT7AMOUNT | money | yes | Application 3 recognition credit 7 amount |
| SPLIT3RECOGNITIONCREDIT7TYPE | nvarchar(100) | yes | Application 3 recognition credit 7 type |
| SPLIT3RECOGNITIONCREDIT7EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 7 effective date |
| SPLIT3RECOGNITIONCREDIT8RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 8 recipient |
| SPLIT3RECOGNITIONCREDIT8AMOUNT | money | yes | Application 3 recognition credit 8 amount |
| SPLIT3RECOGNITIONCREDIT8TYPE | nvarchar(100) | yes | Application 3 recognition credit 8 type |
| SPLIT3RECOGNITIONCREDIT8EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 8 effective date |
| SPLIT3RECOGNITIONCREDIT9RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 9 recipient |
| SPLIT3RECOGNITIONCREDIT9AMOUNT | money | yes | Application 3 recognition credit 9 amount |
| SPLIT3RECOGNITIONCREDIT9TYPE | nvarchar(100) | yes | Application 3 recognition credit 9 type |
| SPLIT3RECOGNITIONCREDIT9EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 9 effective date |
| SPLIT3RECOGNITIONCREDIT10RECIPIENT | nvarchar(154) | yes | Application 3 recognition credit 10 recipient |
| SPLIT3RECOGNITIONCREDIT10AMOUNT | money | yes | Application 3 recognition credit 10 amount |
| SPLIT3RECOGNITIONCREDIT10TYPE | nvarchar(100) | yes | Application 3 recognition credit 10 type |
| SPLIT3RECOGNITIONCREDIT10EFFECTIVEDATE | datetime | yes | Application 3 recognition credit 10 effective date |
| APPLICATION4TYPE | nvarchar(27) | yes | Application 4 type |
| DESIGNATION4NAME | nvarchar(100) | yes | Application 4 designation |
| DESIGNATION4PUBLICNAME | nvarchar(512) | yes | Application 4 designation public name |
| DESIGNATION4AMOUNT | money | yes | Application 4 amount |
| DESIGNATION4ADMINISTRATOR | nvarchar(154) | yes | Application 4 designation administrator |
| DESIGNATION4LOOKUPID | nvarchar(512) | yes | Application 4 designation lookup ID |
| SPLIT4CAMPAIGN1NAME | nvarchar(100) | yes | Application 4 campaign 1 |
| SPLIT4CAMPAIGN2NAME | nvarchar(100) | yes | Application 4 campaign 2 |
| SPLIT4CAMPAIGN3NAME | nvarchar(100) | yes | Application 4 campaign 3 |
| SPLIT4CAMPAIGN4NAME | nvarchar(100) | yes | Application 4 campaign 4 |
| SPLIT4CAMPAIGN5NAME | nvarchar(100) | yes | Application 4 campaign 5 |
| SPLIT4CAMPAIGN6NAME | nvarchar(100) | yes | Application 4 campaign 6 |
| SPLIT4CAMPAIGN7NAME | nvarchar(100) | yes | Application 4 campaign 7 |
| SPLIT4CAMPAIGN8NAME | nvarchar(100) | yes | Application 4 campaign 8 |
| SPLIT4CAMPAIGN9NAME | nvarchar(100) | yes | Application 4 campaign 9 |
| SPLIT4CAMPAIGN10NAME | nvarchar(100) | yes | Application 4 campaign 10 |
| MEMBERSHIP4PROGRAM | nvarchar(100) | yes | Application 4 membership program |
| MEMBERSHIP4LEVEL | nvarchar(100) | yes | Application 4 membership level |
| MEMBERSHIP4EXPIRATIONDATE | datetime | yes | Application 4 expiration date |
| PLEDGE4CONSTITUENT | nvarchar(154) | yes | Application 4 constituent on pledge |
| PLEDGE4AMOUNT | money | yes | Application 4 pledge amount |
| PLEDGE4DATE | datetime | yes | Application 4 pledge date |
| PLEDGE4BALANCE | money | yes | Application 4 pledge balance |
| SPLIT4RECOGNITIONCREDIT1RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 1 recipient |
| SPLIT4RECOGNITIONCREDIT1AMOUNT | money | yes | Application 4 recognition credit 1 amount |
| SPLIT4RECOGNITIONCREDIT1TYPE | nvarchar(100) | yes | Application 4 recognition credit 1 type |
| SPLIT4RECOGNITIONCREDIT1EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 1 effective date |
| SPLIT4RECOGNITIONCREDIT2RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 2 recipient |
| SPLIT4RECOGNITIONCREDIT2AMOUNT | money | yes | Application 4 recognition credit 2 amount |
| SPLIT4RECOGNITIONCREDIT2TYPE | nvarchar(100) | yes | Application 4 recognition credit 2 type |
| SPLIT4RECOGNITIONCREDIT2EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 2 effective date |
| SPLIT4RECOGNITIONCREDIT3RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 3 recipient |
| SPLIT4RECOGNITIONCREDIT3AMOUNT | money | yes | Application 4 recognition credit 3 amount |
| SPLIT4RECOGNITIONCREDIT3TYPE | nvarchar(100) | yes | Application 4 recognition credit 3 type |
| SPLIT4RECOGNITIONCREDIT3EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 3 effective date |
| SPLIT4RECOGNITIONCREDIT4RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 4 recipient |
| SPLIT4RECOGNITIONCREDIT4AMOUNT | money | yes | Application 4 recognition credit 4 amount |
| SPLIT4RECOGNITIONCREDIT4TYPE | nvarchar(100) | yes | Application 4 recognition credit 4 type |
| SPLIT4RECOGNITIONCREDIT4EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 4 effective date |
| SPLIT4RECOGNITIONCREDIT5RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 5 recipient |
| SPLIT4RECOGNITIONCREDIT5AMOUNT | money | yes | Application 4 recognition credit 5 amount |
| SPLIT4RECOGNITIONCREDIT5TYPE | nvarchar(100) | yes | Application 4 recognition credit 5 type |
| SPLIT4RECOGNITIONCREDIT5EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 5 effective date |
| SPLIT4RECOGNITIONCREDIT6RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 6 recipient |
| SPLIT4RECOGNITIONCREDIT6AMOUNT | money | yes | Application 4 recognition credit 6 amount |
| SPLIT4RECOGNITIONCREDIT6TYPE | nvarchar(100) | yes | Application 4 recognition credit 6 type |
| SPLIT4RECOGNITIONCREDIT6EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 6 effective date |
| SPLIT4RECOGNITIONCREDIT7RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 7 recipient |
| SPLIT4RECOGNITIONCREDIT7AMOUNT | money | yes | Application 4 recognition credit 7 amount |
| SPLIT4RECOGNITIONCREDIT7TYPE | nvarchar(100) | yes | Application 4 recognition credit 7 type |
| SPLIT4RECOGNITIONCREDIT7EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 7 effective date |
| SPLIT4RECOGNITIONCREDIT8RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 8 recipient |
| SPLIT4RECOGNITIONCREDIT8AMOUNT | money | yes | Application 4 recognition credit 8 amount |
| SPLIT4RECOGNITIONCREDIT8TYPE | nvarchar(100) | yes | Application 4 recognition credit 8 type |
| SPLIT4RECOGNITIONCREDIT8EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 8 effective date |
| SPLIT4RECOGNITIONCREDIT9RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 9 recipient |
| SPLIT4RECOGNITIONCREDIT9AMOUNT | money | yes | Application 4 recognition credit 9 amount |
| SPLIT4RECOGNITIONCREDIT9TYPE | nvarchar(100) | yes | Application 4 recognition credit 9 type |
| SPLIT4RECOGNITIONCREDIT9EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 9 effective date |
| SPLIT4RECOGNITIONCREDIT10RECIPIENT | nvarchar(154) | yes | Application 4 recognition credit 10 recipient |
| SPLIT4RECOGNITIONCREDIT10AMOUNT | money | yes | Application 4 recognition credit 10 amount |
| SPLIT4RECOGNITIONCREDIT10TYPE | nvarchar(100) | yes | Application 4 recognition credit 10 type |
| SPLIT4RECOGNITIONCREDIT10EFFECTIVEDATE | datetime | yes | Application 4 recognition credit 10 effective date |
| APPLICATION5TYPE | nvarchar(27) | yes | Application 5 type |
| DESIGNATION5NAME | nvarchar(100) | yes | Application 5 designation |
| DESIGNATION5PUBLICNAME | nvarchar(512) | yes | Application 5 designation public name |
| DESIGNATION5AMOUNT | money | yes | Application 5 amount |
| DESIGNATION5ADMINISTRATOR | nvarchar(154) | yes | Application 5 designation administrator |
| DESIGNATION5LOOKUPID | nvarchar(512) | yes | Application 5 designation lookup ID |
| SPLIT5CAMPAIGN1NAME | nvarchar(100) | yes | Application 5 campaign 1 |
| SPLIT5CAMPAIGN2NAME | nvarchar(100) | yes | Application 5 campaign 2 |
| SPLIT5CAMPAIGN3NAME | nvarchar(100) | yes | Application 5 campaign 3 |
| SPLIT5CAMPAIGN4NAME | nvarchar(100) | yes | Application 5 campaign 4 |
| SPLIT5CAMPAIGN5NAME | nvarchar(100) | yes | Application 5 campaign 5 |
| SPLIT5CAMPAIGN6NAME | nvarchar(100) | yes | Application 5 campaign 6 |
| SPLIT5CAMPAIGN7NAME | nvarchar(100) | yes | Application 5 campaign 7 |
| SPLIT5CAMPAIGN8NAME | nvarchar(100) | yes | Application 5 campaign 8 |
| SPLIT5CAMPAIGN9NAME | nvarchar(100) | yes | Application 5 campaign 9 |
| SPLIT5CAMPAIGN10NAME | nvarchar(100) | yes | Application 5 campaign 10 |
| MEMBERSHIP5PROGRAM | nvarchar(100) | yes | Application 5 membership program |
| MEMBERSHIP5LEVEL | nvarchar(100) | yes | Application 5 membership level |
| MEMBERSHIP5EXPIRATIONDATE | datetime | yes | Application 5 expiration date |
| PLEDGE5CONSTITUENT | nvarchar(154) | yes | Application 5 constituent on pledge |
| PLEDGE5AMOUNT | money | yes | Application 5 pledge amount |
| PLEDGE5DATE | datetime | yes | Application 5 pledge date |
| PLEDGE5BALANCE | money | yes | Application 5 pledge balance |
| SPLIT5RECOGNITIONCREDIT1RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 1 recipient |
| SPLIT5RECOGNITIONCREDIT1AMOUNT | money | yes | Application 5 recognition credit 1 amount |
| SPLIT5RECOGNITIONCREDIT1TYPE | nvarchar(100) | yes | Application 5 recognition credit 1 type |
| SPLIT5RECOGNITIONCREDIT1EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 1 effective date |
| SPLIT5RECOGNITIONCREDIT2RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 2 recipient |
| SPLIT5RECOGNITIONCREDIT2AMOUNT | money | yes | Application 5 recognition credit 2 amount |
| SPLIT5RECOGNITIONCREDIT2TYPE | nvarchar(100) | yes | Application 5 recognition credit 2 type |
| SPLIT5RECOGNITIONCREDIT2EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 2 effective date |
| SPLIT5RECOGNITIONCREDIT3RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 3 recipient |
| SPLIT5RECOGNITIONCREDIT3AMOUNT | money | yes | Application 5 recognition credit 3 amount |
| SPLIT5RECOGNITIONCREDIT3TYPE | nvarchar(100) | yes | Application 5 recognition credit 3 type |
| SPLIT5RECOGNITIONCREDIT3EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 3 effective date |
| SPLIT5RECOGNITIONCREDIT4RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 4 recipient |
| SPLIT5RECOGNITIONCREDIT4AMOUNT | money | yes | Application 5 recognition credit 4 amount |
| SPLIT5RECOGNITIONCREDIT4TYPE | nvarchar(100) | yes | Application 5 recognition credit 4 type |
| SPLIT5RECOGNITIONCREDIT4EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 4 effective date |
| SPLIT5RECOGNITIONCREDIT5RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 5 recipient |
| SPLIT5RECOGNITIONCREDIT5AMOUNT | money | yes | Application 5 recognition credit 5 amount |
| SPLIT5RECOGNITIONCREDIT5TYPE | nvarchar(100) | yes | Application 5 recognition credit 5 type |
| SPLIT5RECOGNITIONCREDIT5EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 5 effective date |
| SPLIT5RECOGNITIONCREDIT6RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 6 recipient |
| SPLIT5RECOGNITIONCREDIT6AMOUNT | money | yes | Application 5 recognition credit 6 amount |
| SPLIT5RECOGNITIONCREDIT6TYPE | nvarchar(100) | yes | Application 5 recognition credit 6 type |
| SPLIT5RECOGNITIONCREDIT6EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 6 effective date |
| SPLIT5RECOGNITIONCREDIT7RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 7 recipient |
| SPLIT5RECOGNITIONCREDIT7AMOUNT | money | yes | Application 5 recognition credit 7 amount |
| SPLIT5RECOGNITIONCREDIT7TYPE | nvarchar(100) | yes | Application 5 recognition credit 7 type |
| SPLIT5RECOGNITIONCREDIT7EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 7 effective date |
| SPLIT5RECOGNITIONCREDIT8RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 8 recipient |
| SPLIT5RECOGNITIONCREDIT8AMOUNT | money | yes | Application 5 recognition credit 8 amount |
| SPLIT5RECOGNITIONCREDIT8TYPE | nvarchar(100) | yes | Application 5 recognition credit 8 type |
| SPLIT5RECOGNITIONCREDIT8EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 8 effective date |
| SPLIT5RECOGNITIONCREDIT9RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 9 recipient |
| SPLIT5RECOGNITIONCREDIT9AMOUNT | money | yes | Application 5 recognition credit 9 amount |
| SPLIT5RECOGNITIONCREDIT9TYPE | nvarchar(100) | yes | Application 5 recognition credit 9 type |
| SPLIT5RECOGNITIONCREDIT9EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 9 effective date |
| SPLIT5RECOGNITIONCREDIT10RECIPIENT | nvarchar(154) | yes | Application 5 recognition credit 10 recipient |
| SPLIT5RECOGNITIONCREDIT10AMOUNT | money | yes | Application 5 recognition credit 10 amount |
| SPLIT5RECOGNITIONCREDIT10TYPE | nvarchar(100) | yes | Application 5 recognition credit 10 type |
| SPLIT5RECOGNITIONCREDIT10EFFECTIVEDATE | datetime | yes | Application 5 recognition credit 10 effective date |
| RECOGNITIONPROGRAM | nvarchar(100) | yes | Recognition program |
| RECOGNITIONLEVEL | nvarchar(100) | yes | Recognition level |
| TRANSACTIONCURRENCYID | uniqueidentifier | Transaction currency ID | |
| BASECURRENCYID | uniqueidentifier | Base currency ID | |
| TOTALPLEDGEAMOUNTCURRENCY | nvarchar(3) | yes | Total pledge amount currency |
| FIRSTINSTALLMENTAMOUNTCURRENCY | nvarchar(3) | yes | First installment amount currency |
| TRIBUTE1AMOUNTCURRENCY | nvarchar(3) | yes | Tribute 1 amount currency |
| TRIBUTE2AMOUNTCURRENCY | nvarchar(3) | yes | Tribute 2 amount currency |
| TRIBUTE3AMOUNTCURRENCY | nvarchar(3) | yes | Tribute 3 amount currency |
| TRIBUTE4AMOUNTCURRENCY | nvarchar(3) | yes | Tribute 4 amount currency |
| TRIBUTE5AMOUNTCURRENCY | nvarchar(3) | yes | Tribute 5 amount currency |
| MATCHINGGIFT1CURRENCYID | uniqueidentifier | yes | Matching gift 1 currency ID |
| MATCHINGGIFT1AMOUNTCURRENCY | nvarchar(3) | yes | Matching gift 1 amount currency |
| MATCHINGGIFT2CURRENCYID | uniqueidentifier | yes | Matching gift 2 currency ID |
| MATCHINGGIFT2AMOUNTCURRENCY | nvarchar(3) | yes | Matching gift 2 amount currency |
| MATCHINGGIFT3CURRENCYID | uniqueidentifier | yes | Matching gift 3 currency ID |
| MATCHINGGIFT3AMOUNTCURRENCY | nvarchar(3) | yes | Matching gift 3 amount currency |
| BENEFIT1UNITVALUECURRENCY | nvarchar(3) | yes | Benefit 1 unit cost currency |
| BENEFIT1TOTALVALUECURRENCY | nvarchar(3) | yes | Benefit 1 total value currency |
| BENEFIT2UNITVALUECURRENCY | nvarchar(3) | yes | Benefit 2 unit cost currency |
| BENEFIT2TOTALVALUECURRENCY | nvarchar(3) | yes | Benefit 2 total value currency |
| BENEFIT3UNITVALUECURRENCY | nvarchar(3) | yes | Benefit 3 unit cost currency |
| BENEFIT3TOTALVALUECURRENCY | nvarchar(3) | yes | Benefit 3 total value currency |
| BENEFIT4UNITVALUECURRENCY | nvarchar(3) | yes | Benefit 4 unit cost currency |
| BENEFIT4TOTALVALUECURRENCY | nvarchar(3) | yes | Benefit 4 total value currency |
| BENEFIT5UNITVALUECURRENCY | nvarchar(3) | yes | Benefit 5 unit cost currency |
| BENEFIT5TOTALVALUECURRENCY | nvarchar(3) | yes | Benefit 5 total value currency |
| DESIGNATION1AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 amount currency |
| DESIGNATION2AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 amount currency |
| DESIGNATION3AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 amount currency |
| DESIGNATION4AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 amount currency |
| DESIGNATION5AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 amount currency |
| PLEDGE1CURRENCYID | uniqueidentifier | yes | Application 1 pledge currency ID |
| PLEDGE1AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 pledge amount currency |
| PLEDGE1BALANCECURRENCY | nvarchar(3) | yes | Application 1 pledge balance currency |
| PLEDGE2CURRENCYID | uniqueidentifier | yes | Application 2 pledge currency ID |
| PLEDGE2AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 pledge amount currency |
| PLEDGE2BALANCECURRENCY | nvarchar(3) | yes | Application 2 pledge balance currency |
| PLEDGE3CURRENCYID | uniqueidentifier | yes | Application 3 pledge currency ID |
| PLEDGE3AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 pledge amount currency |
| PLEDGE3BALANCECURRENCY | nvarchar(3) | yes | Application 3 pledge balance currency |
| PLEDGE4CURRENCYID | uniqueidentifier | yes | Application 4 pledge currency ID |
| PLEDGE4AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 pledge amount currency |
| PLEDGE4BALANCECURRENCY | nvarchar(3) | yes | Application 4 pledge balance currency |
| PLEDGE5CURRENCYID | uniqueidentifier | yes | Application 5 pledge currency ID |
| PLEDGE5AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 pledge amount currency |
| PLEDGE5BALANCECURRENCY | nvarchar(3) | yes | Application 5 pledge balance currency |
| SPLIT1RECOGNITIONCREDIT1AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 1 amount currency |
| SPLIT1RECOGNITIONCREDIT2AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 2 amount currency |
| SPLIT1RECOGNITIONCREDIT3AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 3 amount currency |
| SPLIT1RECOGNITIONCREDIT4AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 4 amount currency |
| SPLIT1RECOGNITIONCREDIT5AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 5 amount currency |
| SPLIT1RECOGNITIONCREDIT6AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 6 amount currency |
| SPLIT1RECOGNITIONCREDIT7AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 7 amount currency |
| SPLIT1RECOGNITIONCREDIT8AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 8 amount currency |
| SPLIT1RECOGNITIONCREDIT9AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 9 amount currency |
| SPLIT1RECOGNITIONCREDIT10AMOUNTCURRENCY | nvarchar(3) | yes | Application 1 recognition credit 10 amount currency |
| SPLIT2RECOGNITIONCREDIT1AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 1 amount currency |
| SPLIT2RECOGNITIONCREDIT2AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 2 amount currency |
| SPLIT2RECOGNITIONCREDIT3AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 3 amount currency |
| SPLIT2RECOGNITIONCREDIT4AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 4 amount currency |
| SPLIT2RECOGNITIONCREDIT5AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 5 amount currency |
| SPLIT2RECOGNITIONCREDIT6AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 6 amount currency |
| SPLIT2RECOGNITIONCREDIT7AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 7 amount currency |
| SPLIT2RECOGNITIONCREDIT8AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 8 amount currency |
| SPLIT2RECOGNITIONCREDIT9AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 9 amount currency |
| SPLIT2RECOGNITIONCREDIT10AMOUNTCURRENCY | nvarchar(3) | yes | Application 2 recognition credit 10 amount currency |
| SPLIT3RECOGNITIONCREDIT1AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 1 amount currency |
| SPLIT3RECOGNITIONCREDIT2AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 2 amount currency |
| SPLIT3RECOGNITIONCREDIT3AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 3 amount currency |
| SPLIT3RECOGNITIONCREDIT4AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 4 amount currency |
| SPLIT3RECOGNITIONCREDIT5AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 5 amount currency |
| SPLIT3RECOGNITIONCREDIT6AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 6 amount currency |
| SPLIT3RECOGNITIONCREDIT7AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 7 amount currency |
| SPLIT3RECOGNITIONCREDIT8AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 8 amount currency |
| SPLIT3RECOGNITIONCREDIT9AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 9 amount currency |
| SPLIT3RECOGNITIONCREDIT10AMOUNTCURRENCY | nvarchar(3) | yes | Application 3 recognition credit 10 amount currency |
| SPLIT4RECOGNITIONCREDIT1AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 1 amount currency |
| SPLIT4RECOGNITIONCREDIT2AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 2 amount currency |
| SPLIT4RECOGNITIONCREDIT3AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 3 amount currency |
| SPLIT4RECOGNITIONCREDIT4AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 4 amount currency |
| SPLIT4RECOGNITIONCREDIT5AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 5 amount currency |
| SPLIT4RECOGNITIONCREDIT6AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 6 amount currency |
| SPLIT4RECOGNITIONCREDIT7AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 7 amount currency |
| SPLIT4RECOGNITIONCREDIT8AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 8 amount currency |
| SPLIT4RECOGNITIONCREDIT9AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 9 amount currency |
| SPLIT4RECOGNITIONCREDIT10AMOUNTCURRENCY | nvarchar(3) | yes | Application 4 recognition credit 10 amount currency |
| SPLIT5RECOGNITIONCREDIT1AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 1 amount currency |
| SPLIT5RECOGNITIONCREDIT2AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 2 amount currency |
| SPLIT5RECOGNITIONCREDIT3AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 3 amount currency |
| SPLIT5RECOGNITIONCREDIT4AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 4 amount currency |
| SPLIT5RECOGNITIONCREDIT5AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 5 amount currency |
| SPLIT5RECOGNITIONCREDIT6AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 6 amount currency |
| SPLIT5RECOGNITIONCREDIT7AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 7 amount currency |
| SPLIT5RECOGNITIONCREDIT8AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 8 amount currency |
| SPLIT5RECOGNITIONCREDIT9AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 9 amount currency |
| SPLIT5RECOGNITIONCREDIT10AMOUNTCURRENCY | nvarchar(3) | yes | Application 5 recognition credit 10 amount currency |
| DDIACCOUNTNUMBER_MASKED | nvarchar(4000) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/21/2016 5:07:46 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.154.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_ACKNOWLEDGEMENTPROCESSPLEDGEOUTPUTEXTENDED AS
select
REVENUE.ID as REVENUEID,
CONSTITUENT.NAME as CONSTITUENTNAME,
CONSTITUENT.LOOKUPID as CONSTITUENTLOOKUPID,
(select FORMATTEDNAME from dbo.NAMEFORMAT where NAMEFORMAT.CONSTITUENTID = CONSTITUENT.ID and NAMEFORMAT.PRIMARYADDRESSEE = 1) as PRIMARYADDRESSEE,
(select FORMATTEDNAME from dbo.NAMEFORMAT where NAMEFORMAT.CONSTITUENTID = CONSTITUENT.ID and NAMEFORMAT.PRIMARYSALUTATION = 1) as PRIMARYSALUTATION,
case when CONSTITUENT.ISORGANIZATION = 1 then
(select top (1)
CONTACT.NAME
from dbo.RELATIONSHIP
inner join dbo.CONSTITUENT CONTACT on RELATIONSHIP.RECIPROCALCONSTITUENTID = CONTACT.ID
where RELATIONSHIP.ISPRIMARYCONTACT = 1
and RELATIONSHIP.RELATIONSHIPCONSTITUENTID = CONSTITUENT.ID)
else
null
end as PRIMARYCONTACT,
ADDRESS.ADDRESSBLOCK as ADDRESSBLOCK,
ADDRESS.CITY as CITY,
STATE.ABBREVIATION as STATE,
ADDRESS.POSTCODE as POSTCODE,
COUNTRY.DESCRIPTION as COUNTRY,
EMAILADDRESS.EMAILADDRESS,
REVENUE.TRANSACTIONAMOUNT as TOTALPLEDGEAMOUNT,
REVENUE.DATE as PLEDGEDATE,
SCHEDULE.FREQUENCY,
SCHEDULE.STARTDATE,
SCHEDULE.NUMBEROFINSTALLMENTS,
(select INSTALLMENT.DATE from dbo.INSTALLMENT where INSTALLMENT.REVENUEID = REVENUE.ID and INSTALLMENT.SEQUENCE = 1) as FIRSTDUEDATE,
(select INSTALLMENT.TRANSACTIONAMOUNT from dbo.INSTALLMENT where INSTALLMENT.REVENUEID = REVENUE.ID and INSTALLMENT.SEQUENCE = 1) as FIRSTINSTALLMENTAMOUNT,
case SCHEDULE.SENDPLEDGEREMINDER when 1 then 'Yes' else 'No' end as SENDPLEDGEREMINDER,
case REVENUE_EXT.GIVENANONYMOUSLY when 1 then 'Yes' else 'No' end as GIVENANONYMOUSLY,
case when [FIRSTGIFTS].[ID] is not null then 'Yes' else 'No' end as [ISFIRSTGIFT],
APPEAL.NAME as APPEALNAME,
case when CONSTITUENT.ISORGANIZATION = 1 then
(select top 1 RELATIONSHIP.POSITION from dbo.RELATIONSHIP
inner join dbo.CONSTITUENT CONTACT on RELATIONSHIP.RECIPROCALCONSTITUENTID = CONTACT.ID
where RELATIONSHIP.ISPRIMARYCONTACT = 1
and RELATIONSHIP.RELATIONSHIPCONSTITUENTID = CONSTITUENT.ID)
else
null
end as POSITION,
REVENUELETTER.ID as REVENUELETTERID,
(select FORMATTEDNAME from dbo.NAMEFORMAT where NAMEFORMAT.CONSTITUENTID = DONOR.ID and NAMEFORMAT.PRIMARYADDRESSEE = 1) as DONORADDRESSEE,
DONORADDRESS.ADDRESSBLOCK as DONORADDRESSBLOCK,
DONORADDRESS.CITY as DONORCITY,
DONORSTATE.ABBREVIATION as DONORSTATE,
DONORADDRESS.POSTCODE as DONORPOSTCODE,
DONORCOUNTRY.DESCRIPTION as DONORCOUNTRY,
DONOREMAILADDRESS.EMAILADDRESS as DONOREMAILADDRESS,
case when [DDPAYMENT].ID is null then null else [DONOR].NAME end as [DDIACCOUNTHOLDER],
case when [DDPAYMENT].ID is null then null else [DONORADDRESS].ADDRESSBLOCK end as [DDIACCOUNTHOLDERADDRESSBLOCK],
case when [DDPAYMENT].ID is null then null else [DONORADDRESS].CITY end as [DDIACCOUNTHOLDERCITY],
case when [DDPAYMENT].ID is null then null else [DONORSTATE].ABBREVIATION end as [DDIACCOUNTHOLDERSTATE],
case when [DDPAYMENT].ID is null then null else [DONORADDRESS].POSTCODE end as [DDIACCOUNTHOLDERPOSTCODE],
case when [DDPAYMENT].ID is null then null else [DONORCOUNTRY].DESCRIPTION end as [DDIACCOUNTHOLDERCOUNTRY],
case when [DDPAYMENT].ID is null then null else convert(nvarchar(50), DecryptByKey([DDACCOUNT].ACCOUNTNUMBER)) end as [DDIACCOUNTNUMBER],
case when [DDPAYMENT].ID is null then null else [DDBANK].FINANCIALINSTITUTION end as [DDIACCOUNTBANK],
case when [DDPAYMENT].ID is null then null else [DDBANK].BRANCHNAME end as [DDIACCOUNTBRANCH],
case when [DDPAYMENT].ID is null then null else [DDBANK].ADDRESSBLOCK end as [DDIACCOUNTBANKADDRESSBLOCK],
case when [DDPAYMENT].ID is null then null else [DDBANK].CITY end as [DDIACCOUNTBANKCITY],
case when [DDPAYMENT].ID is null then null else [DDBANKSTATE].ABBREVIATION end as [DDIACCOUNTBANKSTATE],
case when [DDPAYMENT].ID is null then null else [DDBANK].POSTCODE end as [DDIACCOUNTBANKPOSTCODE],
case when [DDPAYMENT].ID is null then null else [DDBANKCOUNTRY].DESCRIPTION end as [DDIACCOUNTBANKCOUNTRY],
case when [DDPAYMENT].ID is null then null else [DDSCHEDULE].NUMBEROFINSTALLMENTS end as [DDINUMBEROFINSTALLMENTS],
case when [DDPAYMENT].ID is null then null else [DDSCHEDULE].FREQUENCY end as [DDIFREQUENCY],
case when [DDPAYMENT].ID is null then null else [DDSCHEDULE].STARTDATE end as [DDISTARTDATE],
case when [DDPAYMENT].ID is null then null else dbo.UFN_REVENUE_GETLASTTRANSACTIONDATE(REVENUE.ID) end as [DDIENDDATE],
case when [DDPAYMENT].ID is null then null
else
(
select case when REVENUE.TYPECODE = 1 then
dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE([DDINSTALLMENT].ID)
when REVENUE.TYPECODE = 2 then
REVENUE.TRANSACTIONAMOUNT
else
null
end
)
end as [DDIINSTALLMENTAMOUNT],
[DDACCOUNT].ACCOUNTNAME as [DDINAMEONACCOUNT],
coalesce(GIFTAID.GROSSAMOUNT, REVENUE.TRANSACTIONAMOUNT) as AMOUNTWITHGIFTAID,
OTHERPAYMENTMETHODCODE.DESCRIPTION as OTHERPAYMENTMETHOD,
REVENUEREFERENCE.REFERENCE,
TRIBUTE1.TYPE as TRIBUTE1TYPE,
TRIBUTE1.TRIBUTEE as TRIBUTE1TRIBUTEE,
TRIBUTE1.TRIBUTETEXT as TRIBUTE1TRIBUTETEXT,
TRIBUTE1.DEFAULTDESIGNATION as TRIBUTE1DEFAULTDESIGNATION,
TRIBUTE1.AMOUNT as TRIBUTE1AMOUNT,
TRIBUTE2.TYPE as TRIBUTE2TYPE,
TRIBUTE2.TRIBUTEE as TRIBUTE2TRIBUTEE,
TRIBUTE2.TRIBUTETEXT as TRIBUTE2TRIBUTETEXT,
TRIBUTE2.DEFAULTDESIGNATION as TRIBUTE2DEFAULTDESIGNATION,
TRIBUTE2.AMOUNT as TRIBUTE2AMOUNT,
TRIBUTE3.TYPE as TRIBUTE3TYPE,
TRIBUTE3.TRIBUTEE as TRIBUTE3TRIBUTEE,
TRIBUTE3.TRIBUTETEXT as TRIBUTE3TRIBUTETEXT,
TRIBUTE3.DEFAULTDESIGNATION as TRIBUTE3DEFAULTDESIGNATION,
TRIBUTE3.AMOUNT as TRIBUTE3AMOUNT,
TRIBUTE4.TYPE as TRIBUTE4TYPE,
TRIBUTE4.TRIBUTEE as TRIBUTE4TRIBUTEE,
TRIBUTE4.TRIBUTETEXT as TRIBUTE4TRIBUTETEXT,
TRIBUTE4.DEFAULTDESIGNATION as TRIBUTE4DEFAULTDESIGNATION,
TRIBUTE4.AMOUNT as TRIBUTE4AMOUNT,
TRIBUTE5.TYPE as TRIBUTE5TYPE,
TRIBUTE5.TRIBUTEE as TRIBUTE5TRIBUTEE,
TRIBUTE5.TRIBUTETEXT as TRIBUTE5TRIBUTETEXT,
TRIBUTE5.DEFAULTDESIGNATION as TRIBUTE5DEFAULTDESIGNATION,
TRIBUTE5.AMOUNT as TRIBUTE5AMOUNT,
MATCHINGGIFT1.ORGANIZATION as MATCHINGGIFT1ORGANIZATION,
MATCHINGGIFT1.CONDITIONTYPE as MATCHINGGIFT1CONDITIONTYPE,
MATCHINGGIFT1.AMOUNT as MATCHINGGIFT1AMOUNT,
MATCHINGGIFT2.ORGANIZATION as MATCHINGGIFT2ORGANIZATION,
MATCHINGGIFT2.CONDITIONTYPE as MATCHINGGIFT2CONDITIONTYPE,
MATCHINGGIFT2.AMOUNT as MATCHINGGIFT2AMOUNT,
MATCHINGGIFT3.ORGANIZATION as MATCHINGGIFT3ORGANIZATION,
MATCHINGGIFT3.CONDITIONTYPE as MATCHINGGIFT3CONDITIONTYPE,
MATCHINGGIFT3.AMOUNT as MATCHINGGIFT3AMOUNT,
case REVENUE_EXT.BENEFITSWAIVED when 1 then 'Yes' else 'No' end as BENEFITSWAIVED,
-- Benefits fields
REVENUEBENEFIT1.NAME as BENEFIT1NAME,
REVENUEBENEFIT1.QUANTITY as BENEFIT1QUANTITY,
REVENUEBENEFIT1.TRANSACTIONUNITVALUE as BENEFIT1UNITVALUE,
REVENUEBENEFIT1.TRANSACTIONTOTALVALUE as BENEFIT1TOTALVALUE,
REVENUEBENEFIT2.NAME as BENEFIT2NAME,
REVENUEBENEFIT2.QUANTITY as BENEFIT2QUANTITY,
REVENUEBENEFIT2.TRANSACTIONUNITVALUE as BENEFIT2UNITVALUE,
REVENUEBENEFIT2.TRANSACTIONTOTALVALUE as BENEFIT2TOTALVALUE,
REVENUEBENEFIT3.NAME as BENEFIT3NAME,
REVENUEBENEFIT3.QUANTITY as BENEFIT3QUANTITY,
REVENUEBENEFIT3.TRANSACTIONUNITVALUE as BENEFIT3UNITVALUE,
REVENUEBENEFIT3.TRANSACTIONTOTALVALUE as BENEFIT3TOTALVALUE,
REVENUEBENEFIT4.NAME as BENEFIT4NAME,
REVENUEBENEFIT4.QUANTITY as BENEFIT4QUANTITY,
REVENUEBENEFIT4.TRANSACTIONUNITVALUE as BENEFIT4UNITVALUE,
REVENUEBENEFIT4.TRANSACTIONTOTALVALUE as BENEFIT4TOTALVALUE,
REVENUEBENEFIT5.NAME as BENEFIT5NAME,
REVENUEBENEFIT5.QUANTITY as BENEFIT5QUANTITY,
REVENUEBENEFIT5.TRANSACTIONUNITVALUE as BENEFIT5UNITVALUE,
REVENUEBENEFIT5.TRANSACTIONTOTALVALUE as BENEFIT5TOTALVALUE,
-- Split 1 fields
REVENUESPLIT1.APPLICATION as APPLICATION1TYPE,
REVENUESPLIT1.DESIGNATIONNAME as DESIGNATION1NAME,
REVENUESPLIT1.DESIGNATIONPUBLICNAME as DESIGNATION1PUBLICNAME,
REVENUESPLIT1.AMOUNT as DESIGNATION1AMOUNT,
REVENUESPLIT1.DESIGNATIONADMINISTRATOR as DESIGNATION1ADMINISTRATOR,
REVENUESPLIT1.DESIGNATIONLOOKUPID as DESIGNATION1LOOKUPID,
CAMPAIGNS1.CAMPAIGN1 as SPLIT1CAMPAIGN1NAME,
CAMPAIGNS1.CAMPAIGN2 as SPLIT1CAMPAIGN2NAME,
CAMPAIGNS1.CAMPAIGN3 as SPLIT1CAMPAIGN3NAME,
CAMPAIGNS1.CAMPAIGN4 as SPLIT1CAMPAIGN4NAME,
CAMPAIGNS1.CAMPAIGN5 as SPLIT1CAMPAIGN5NAME,
CAMPAIGNS1.CAMPAIGN6 as SPLIT1CAMPAIGN6NAME,
CAMPAIGNS1.CAMPAIGN7 as SPLIT1CAMPAIGN7NAME,
CAMPAIGNS1.CAMPAIGN8 as SPLIT1CAMPAIGN8NAME,
CAMPAIGNS1.CAMPAIGN9 as SPLIT1CAMPAIGN9NAME,
CAMPAIGNS1.CAMPAIGN10 as SPLIT1CAMPAIGN10NAME,
REVENUESPLIT1.MEMBERSHIPPROGRAM as MEMBERSHIP1PROGRAM,
REVENUESPLIT1.MEMBERSHIPLEVEL as MEMBERSHIP1LEVEL,
--The "GETEARLIESTTIME" date function has been inlined here for performance (the part with "cast(@DATE as date)")...
cast(cast(REVENUESPLIT1.MEMBERSHIPEXPIRATIONDATE as date) as datetime) as MEMBERSHIP1EXPIRATIONDATE,
REVENUESPLIT1.PLEDGECONSTITUENT as PLEDGE1CONSTITUENT,
REVENUESPLIT1.PLEDGEAMOUNT as PLEDGE1AMOUNT,
REVENUESPLIT1.PLEDGEDATE as PLEDGE1DATE,
REVENUESPLIT1.PLEDGEBALANCE as PLEDGE1BALANCE,
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 fields
REVENUESPLIT2.APPLICATION as APPLICATION2TYPE,
REVENUESPLIT2.DESIGNATIONNAME as DESIGNATION2NAME,
REVENUESPLIT2.DESIGNATIONPUBLICNAME as DESIGNATION2PUBLICNAME,
REVENUESPLIT2.AMOUNT as DESIGNATION2AMOUNT,
REVENUESPLIT2.DESIGNATIONADMINISTRATOR as DESIGNATION2ADMINISTRATOR,
REVENUESPLIT2.DESIGNATIONLOOKUPID as DESIGNATION2LOOKUPID,
CAMPAIGNS2.CAMPAIGN1 as SPLIT2CAMPAIGN1NAME,
CAMPAIGNS2.CAMPAIGN2 as SPLIT2CAMPAIGN2NAME,
CAMPAIGNS2.CAMPAIGN3 as SPLIT2CAMPAIGN3NAME,
CAMPAIGNS2.CAMPAIGN4 as SPLIT2CAMPAIGN4NAME,
CAMPAIGNS2.CAMPAIGN5 as SPLIT2CAMPAIGN5NAME,
CAMPAIGNS2.CAMPAIGN6 as SPLIT2CAMPAIGN6NAME,
CAMPAIGNS2.CAMPAIGN7 as SPLIT2CAMPAIGN7NAME,
CAMPAIGNS2.CAMPAIGN8 as SPLIT2CAMPAIGN8NAME,
CAMPAIGNS2.CAMPAIGN9 as SPLIT2CAMPAIGN9NAME,
CAMPAIGNS2.CAMPAIGN10 as SPLIT2CAMPAIGN10NAME,
REVENUESPLIT2.MEMBERSHIPPROGRAM as MEMBERSHIP2PROGRAM,
REVENUESPLIT2.MEMBERSHIPLEVEL as MEMBERSHIP2LEVEL,
--The "GETEARLIESTTIME" date function has been inlined here for performance (the part with "cast(@DATE as date)")...
cast(cast(REVENUESPLIT2.MEMBERSHIPEXPIRATIONDATE as date) as datetime) as MEMBERSHIP2EXPIRATIONDATE,
REVENUESPLIT2.PLEDGECONSTITUENT as PLEDGE2CONSTITUENT,
REVENUESPLIT2.PLEDGEAMOUNT as PLEDGE2AMOUNT,
REVENUESPLIT2.PLEDGEDATE as PLEDGE2DATE,
REVENUESPLIT2.PLEDGEBALANCE as PLEDGE2BALANCE,
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 fields
REVENUESPLIT3.APPLICATION as APPLICATION3TYPE,
REVENUESPLIT3.DESIGNATIONNAME as DESIGNATION3NAME,
REVENUESPLIT3.DESIGNATIONPUBLICNAME as DESIGNATION3PUBLICNAME,
REVENUESPLIT3.AMOUNT as DESIGNATION3AMOUNT,
REVENUESPLIT3.DESIGNATIONADMINISTRATOR as DESIGNATION3ADMINISTRATOR,
REVENUESPLIT3.DESIGNATIONLOOKUPID as DESIGNATION3LOOKUPID,
CAMPAIGNS3.CAMPAIGN1 as SPLIT3CAMPAIGN1NAME,
CAMPAIGNS3.CAMPAIGN2 as SPLIT3CAMPAIGN2NAME,
CAMPAIGNS3.CAMPAIGN3 as SPLIT3CAMPAIGN3NAME,
CAMPAIGNS3.CAMPAIGN4 as SPLIT3CAMPAIGN4NAME,
CAMPAIGNS3.CAMPAIGN5 as SPLIT3CAMPAIGN5NAME,
CAMPAIGNS3.CAMPAIGN6 as SPLIT3CAMPAIGN6NAME,
CAMPAIGNS3.CAMPAIGN7 as SPLIT3CAMPAIGN7NAME,
CAMPAIGNS3.CAMPAIGN8 as SPLIT3CAMPAIGN8NAME,
CAMPAIGNS3.CAMPAIGN9 as SPLIT3CAMPAIGN9NAME,
CAMPAIGNS3.CAMPAIGN10 as SPLIT3CAMPAIGN10NAME,
REVENUESPLIT3.MEMBERSHIPPROGRAM as MEMBERSHIP3PROGRAM,
REVENUESPLIT3.MEMBERSHIPLEVEL as MEMBERSHIP3LEVEL,
--The "GETEARLIESTTIME" date function has been inlined here for performance (the part with "cast(@DATE as date)")...
cast(cast(REVENUESPLIT3.MEMBERSHIPEXPIRATIONDATE as date) as datetime) as MEMBERSHIP3EXPIRATIONDATE,
REVENUESPLIT3.PLEDGECONSTITUENT as PLEDGE3CONSTITUENT,
REVENUESPLIT3.PLEDGEAMOUNT as PLEDGE3AMOUNT,
REVENUESPLIT3.PLEDGEDATE as PLEDGE3DATE,
REVENUESPLIT3.PLEDGEBALANCE as PLEDGE3BALANCE,
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 fields
REVENUESPLIT4.APPLICATION as APPLICATION4TYPE,
REVENUESPLIT4.DESIGNATIONNAME as DESIGNATION4NAME,
REVENUESPLIT4.DESIGNATIONPUBLICNAME as DESIGNATION4PUBLICNAME,
REVENUESPLIT4.AMOUNT as DESIGNATION4AMOUNT,
REVENUESPLIT4.DESIGNATIONADMINISTRATOR as DESIGNATION4ADMINISTRATOR,
REVENUESPLIT4.DESIGNATIONLOOKUPID as DESIGNATION4LOOKUPID,
CAMPAIGNS4.CAMPAIGN1 as SPLIT4CAMPAIGN1NAME,
CAMPAIGNS4.CAMPAIGN2 as SPLIT4CAMPAIGN2NAME,
CAMPAIGNS4.CAMPAIGN3 as SPLIT4CAMPAIGN3NAME,
CAMPAIGNS4.CAMPAIGN4 as SPLIT4CAMPAIGN4NAME,
CAMPAIGNS4.CAMPAIGN5 as SPLIT4CAMPAIGN5NAME,
CAMPAIGNS4.CAMPAIGN6 as SPLIT4CAMPAIGN6NAME,
CAMPAIGNS4.CAMPAIGN7 as SPLIT4CAMPAIGN7NAME,
CAMPAIGNS4.CAMPAIGN8 as SPLIT4CAMPAIGN8NAME,
CAMPAIGNS4.CAMPAIGN9 as SPLIT4CAMPAIGN9NAME,
CAMPAIGNS4.CAMPAIGN10 as SPLIT4CAMPAIGN10NAME,
REVENUESPLIT4.MEMBERSHIPPROGRAM as MEMBERSHIP4PROGRAM,
REVENUESPLIT4.MEMBERSHIPLEVEL as MEMBERSHIP4LEVEL,
--The "GETEARLIESTTIME" date function has been inlined here for performance (the part with "cast(@DATE as date)")...
cast(cast(REVENUESPLIT4.MEMBERSHIPEXPIRATIONDATE as date) as datetime) as MEMBERSHIP4EXPIRATIONDATE,
REVENUESPLIT4.PLEDGECONSTITUENT as PLEDGE4CONSTITUENT,
REVENUESPLIT4.PLEDGEAMOUNT as PLEDGE4AMOUNT,
REVENUESPLIT4.PLEDGEDATE as PLEDGE4DATE,
REVENUESPLIT4.PLEDGEBALANCE as PLEDGE4BALANCE,
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 fields
REVENUESPLIT5.APPLICATION as APPLICATION5TYPE,
REVENUESPLIT5.DESIGNATIONNAME as DESIGNATION5NAME,
REVENUESPLIT5.DESIGNATIONPUBLICNAME as DESIGNATION5PUBLICNAME,
REVENUESPLIT5.AMOUNT as DESIGNATION5AMOUNT,
REVENUESPLIT5.DESIGNATIONADMINISTRATOR as DESIGNATION5ADMINISTRATOR,
REVENUESPLIT5.DESIGNATIONLOOKUPID as DESIGNATION5LOOKUPID,
CAMPAIGNS5.CAMPAIGN1 as SPLIT5CAMPAIGN1NAME,
CAMPAIGNS5.CAMPAIGN2 as SPLIT5CAMPAIGN2NAME,
CAMPAIGNS5.CAMPAIGN3 as SPLIT5CAMPAIGN3NAME,
CAMPAIGNS5.CAMPAIGN4 as SPLIT5CAMPAIGN4NAME,
CAMPAIGNS5.CAMPAIGN5 as SPLIT5CAMPAIGN5NAME,
CAMPAIGNS5.CAMPAIGN6 as SPLIT5CAMPAIGN6NAME,
CAMPAIGNS5.CAMPAIGN7 as SPLIT5CAMPAIGN7NAME,
CAMPAIGNS5.CAMPAIGN8 as SPLIT5CAMPAIGN8NAME,
CAMPAIGNS5.CAMPAIGN9 as SPLIT5CAMPAIGN9NAME,
CAMPAIGNS5.CAMPAIGN10 as SPLIT5CAMPAIGN10NAME,
REVENUESPLIT5.MEMBERSHIPPROGRAM as MEMBERSHIP5PROGRAM,
REVENUESPLIT5.MEMBERSHIPLEVEL as MEMBERSHIP5LEVEL,
--The "GETEARLIESTTIME" date function has been inlined here for performance (the part with "cast(@DATE as date)")...
cast(cast(REVENUESPLIT5.MEMBERSHIPEXPIRATIONDATE as date) as datetime) as MEMBERSHIP5EXPIRATIONDATE,
REVENUESPLIT5.PLEDGECONSTITUENT as PLEDGE5CONSTITUENT,
REVENUESPLIT5.PLEDGEAMOUNT as PLEDGE5AMOUNT,
REVENUESPLIT5.PLEDGEDATE as PLEDGE5DATE,
REVENUESPLIT5.PLEDGEBALANCE as PLEDGE5BALANCE,
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,
RECOGNITIONPROGRAM.RECOGNITIONPROGRAM,
RECOGNITIONPROGRAM.RECOGNITIONLEVEL,
-- General multicurrency fields
REVENUE.TRANSACTIONCURRENCYID,
CURRENCYSET.BASECURRENCYID,
dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) as TOTALPLEDGEAMOUNTCURRENCY,
dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) as FIRSTINSTALLMENTAMOUNTCURRENCY,
-- Tribute multicurrency fields
case when TRIBUTE1.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as TRIBUTE1AMOUNTCURRENCY,
case when TRIBUTE2.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as TRIBUTE2AMOUNTCURRENCY,
case when TRIBUTE3.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as TRIBUTE3AMOUNTCURRENCY,
case when TRIBUTE4.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as TRIBUTE4AMOUNTCURRENCY,
case when TRIBUTE5.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(CURRENCYSET.BASECURRENCYID) else null end as TRIBUTE5AMOUNTCURRENCY,
-- Matching gift currencies
MATCHINGGIFT1.TRANSACTIONCURRENCYID as MATCHINGGIFT1CURRENCYID,
dbo.UFN_CURRENCY_GETISO(MATCHINGGIFT1.TRANSACTIONCURRENCYID) as MATCHINGGIFT1AMOUNTCURRENCY,
MATCHINGGIFT2.TRANSACTIONCURRENCYID as MATCHINGGIFT2CURRENCYID,
dbo.UFN_CURRENCY_GETISO(MATCHINGGIFT2.TRANSACTIONCURRENCYID) as MATCHINGGIFT2AMOUNTCURRENCY,
MATCHINGGIFT3.TRANSACTIONCURRENCYID as MATCHINGGIFT3CURRENCYID,
dbo.UFN_CURRENCY_GETISO(MATCHINGGIFT3.TRANSACTIONCURRENCYID) as MATCHINGGIFT3AMOUNTCURRENCY,
-- Benefit currencies
case when REVENUEBENEFIT1.TRANSACTIONUNITVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT1UNITVALUECURRENCY,
case when REVENUEBENEFIT1.TRANSACTIONTOTALVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT1TOTALVALUECURRENCY,
case when REVENUEBENEFIT2.TRANSACTIONUNITVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT2UNITVALUECURRENCY,
case when REVENUEBENEFIT2.TRANSACTIONTOTALVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT2TOTALVALUECURRENCY,
case when REVENUEBENEFIT3.TRANSACTIONUNITVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT3UNITVALUECURRENCY,
case when REVENUEBENEFIT3.TRANSACTIONTOTALVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT3TOTALVALUECURRENCY,
case when REVENUEBENEFIT4.TRANSACTIONUNITVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT4UNITVALUECURRENCY,
case when REVENUEBENEFIT4.TRANSACTIONTOTALVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT4TOTALVALUECURRENCY,
case when REVENUEBENEFIT5.TRANSACTIONUNITVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT5UNITVALUECURRENCY,
case when REVENUEBENEFIT5.TRANSACTIONTOTALVALUE is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as BENEFIT5TOTALVALUECURRENCY,
-- Designation currencies
case when REVENUESPLIT1.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as DESIGNATION1AMOUNTCURRENCY,
case when REVENUESPLIT2.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as DESIGNATION2AMOUNTCURRENCY,
case when REVENUESPLIT3.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as DESIGNATION3AMOUNTCURRENCY,
case when REVENUESPLIT4.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as DESIGNATION4AMOUNTCURRENCY,
case when REVENUESPLIT5.AMOUNT is not null then dbo.UFN_CURRENCY_GETISO(REVENUE.TRANSACTIONCURRENCYID) else null end as DESIGNATION5AMOUNTCURRENCY,
-- Pledge currencies
REVENUESPLIT1.PLEDGETRANSACTIONCURRENCYID as PLEDGE1CURRENCYID,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT1.PLEDGETRANSACTIONCURRENCYID) as PLEDGE1AMOUNTCURRENCY,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT1.PLEDGETRANSACTIONCURRENCYID) as PLEDGE1BALANCECURRENCY,
REVENUESPLIT2.PLEDGETRANSACTIONCURRENCYID as PLEDGE2CURRENCYID,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT2.PLEDGETRANSACTIONCURRENCYID) as PLEDGE2AMOUNTCURRENCY,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT2.PLEDGETRANSACTIONCURRENCYID) as PLEDGE2BALANCECURRENCY,
REVENUESPLIT3.PLEDGETRANSACTIONCURRENCYID as PLEDGE3CURRENCYID,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT3.PLEDGETRANSACTIONCURRENCYID) as PLEDGE3AMOUNTCURRENCY,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT3.PLEDGETRANSACTIONCURRENCYID) as PLEDGE3BALANCECURRENCY,
REVENUESPLIT4.PLEDGETRANSACTIONCURRENCYID as PLEDGE4CURRENCYID,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT4.PLEDGETRANSACTIONCURRENCYID) as PLEDGE4AMOUNTCURRENCY,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT4.PLEDGETRANSACTIONCURRENCYID) as PLEDGE4BALANCECURRENCY,
REVENUESPLIT5.PLEDGETRANSACTIONCURRENCYID as PLEDGE5CURRENCYID,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT5.PLEDGETRANSACTIONCURRENCYID) as PLEDGE5AMOUNTCURRENCY,
dbo.UFN_CURRENCY_GETISO(REVENUESPLIT5.PLEDGETRANSACTIONCURRENCYID) as PLEDGE5BALANCECURRENCY,
-- Recognition credit currencies
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,
case
when len(coalesce(convert(nvarchar(50), DecryptByKey([DDACCOUNT].ACCOUNTNUMBER)),'')) = 0 then ''
else replicate('*', len(coalesce(convert(nvarchar(50), DecryptByKey([DDACCOUNT].ACCOUNTNUMBER)),'')) -
len(right(coalesce(convert(nvarchar(50), DecryptByKey([DDACCOUNT].ACCOUNTNUMBER)),''), 4))) +
right(coalesce(convert(nvarchar(50), DecryptByKey([DDACCOUNT].ACCOUNTNUMBER)),''), 4)
end as [DDIACCOUNTNUMBER_MASKED]
from dbo.FINANCIALTRANSACTION as REVENUE
inner join dbo.REVENUELETTER on REVENUE.ID = REVENUELETTER.REVENUEID
inner join dbo.CONSTITUENT on REVENUELETTER.ACKNOWLEDGEEID = CONSTITUENT.ID
inner join dbo.REVENUE_EXT on REVENUE.ID = REVENUE_EXT.ID
inner join dbo.PDACCOUNTSYSTEM on REVENUE.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID
inner join dbo.CURRENCYSET on PDACCOUNTSYSTEM.CURRENCYSETID = CURRENCYSET.ID
left join dbo.CONSTITUENT DONOR on REVENUE.CONSTITUENTID = DONOR.ID
left join dbo.REVENUESCHEDULE SCHEDULE on REVENUE.ID = SCHEDULE.ID
left join dbo.ADDRESS on ADDRESS.CONSTITUENTID = CONSTITUENT.ID and ADDRESS.ISPRIMARY = 1 and ADDRESS.DONOTMAIL = 0
left join dbo.COUNTRY on ADDRESS.COUNTRYID = COUNTRY.ID
left join dbo.STATE on ADDRESS.STATEID = STATE.ID
left join dbo.EMAILADDRESS on EMAILADDRESS.CONSTITUENTID=CONSTITUENT.ID and EMAILADDRESS.ISPRIMARY = 1
left join dbo.APPEAL on REVENUE_EXT.APPEALID = APPEAL.ID
left join dbo.ADDRESS DONORADDRESS on DONORADDRESS.CONSTITUENTID = DONOR.ID and DONORADDRESS.ISPRIMARY = 1 and DONORADDRESS.DONOTMAIL = 0
left join dbo.COUNTRY DONORCOUNTRY on DONORADDRESS.COUNTRYID = DONORCOUNTRY.ID
left join dbo.STATE DONORSTATE on DONORADDRESS.STATEID = DONORSTATE.ID
left join dbo.EMAILADDRESS DONOREMAILADDRESS on DONOREMAILADDRESS.CONSTITUENTID = DONOR.ID and DONOREMAILADDRESS.ISPRIMARY = 1 and DONOREMAILADDRESS.DONOTEMAIL = 0
left join dbo.REVENUESCHEDULEDIRECTDEBITPAYMENT as [DDPAYMENT] on [DDPAYMENT].ID = REVENUE.ID
left join dbo.CONSTITUENTACCOUNT as [DDACCOUNT] on [DDACCOUNT].ID = [DDPAYMENT].CONSTITUENTACCOUNTID
left join dbo.FINANCIALINSTITUTION as [DDBANK] on [DDBANK].ID = [DDACCOUNT].FINANCIALINSTITUTIONID
left join dbo.STATE as [DDBANKSTATE] on [DDBANKSTATE].ID = [DDBANK].STATEID
left join dbo.COUNTRY as [DDBANKCOUNTRY] on [DDBANKCOUNTRY].ID = [DDBANK].COUNTRYID
left join dbo.REVENUESCHEDULE as [DDSCHEDULE] on [DDSCHEDULE].ID = [DDPAYMENT].ID
left join dbo.INSTALLMENT [DDINSTALLMENT] on [DDINSTALLMENT].ID = dbo.UFN_REVENUE_GETNEXTINSTALLMENT([DDPAYMENT].ID) and not [DDPAYMENT].ID is null and REVENUE.TYPECODE = 1
left join
(
select
REVENUE.ID as REVENUEID,
case REVENUE.TYPECODE
when 0 then dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEGROSSAMOUNT_2(REVENUE.ID, 1, 1)
when 1 then dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEPLEDGEGROSSAMOUNT_2(REVENUE.ID, 1)
when 2 then dbo.UFN_GIFTAIDREVENUESPLIT_CALCULATEGROSSAMOUNT_2(REVENUE.ID, 1, 1)
end as GROSSAMOUNT
from dbo.FINANCIALTRANSACTION as REVENUE
where REVENUE.DELETEDON is null
) as GIFTAID on REVENUE.ID = GIFTAID.REVENUEID and dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('9568A6C2-F7AA-45fd-8F54-21FE9654EE2D') = 1
inner join dbo.REVENUEPAYMENTMETHOD on REVENUEPAYMENTMETHOD.REVENUEID = REVENUE.ID
left join dbo.OTHERPAYMENTMETHODDETAIL on OTHERPAYMENTMETHODDETAIL.ID = REVENUEPAYMENTMETHOD.ID
left join dbo.OTHERPAYMENTMETHODCODE on OTHERPAYMENTMETHODCODE.ID = OTHERPAYMENTMETHODDETAIL.OTHERPAYMENTMETHODCODEID
left join dbo.REVENUEREFERENCE on REVENUEREFERENCE.ID = REVENUE.ID
outer apply dbo.UFN_REVENUE_GETTRIBUTEBYROWNUMBER(REVENUE.ID, 1) as TRIBUTE1
outer apply dbo.UFN_REVENUE_GETTRIBUTEBYROWNUMBER(REVENUE.ID, 2) as TRIBUTE2
outer apply dbo.UFN_REVENUE_GETTRIBUTEBYROWNUMBER(REVENUE.ID, 3) as TRIBUTE3
outer apply dbo.UFN_REVENUE_GETTRIBUTEBYROWNUMBER(REVENUE.ID, 4) as TRIBUTE4
outer apply dbo.UFN_REVENUE_GETTRIBUTEBYROWNUMBER(REVENUE.ID, 5) as TRIBUTE5
outer apply dbo.UFN_REVENUE_GETMATCHINGGIFTBYROWNUMBER(REVENUE.ID, 1) as MATCHINGGIFT1
outer apply dbo.UFN_REVENUE_GETMATCHINGGIFTBYROWNUMBER(REVENUE.ID, 2) as MATCHINGGIFT2
outer apply dbo.UFN_REVENUE_GETMATCHINGGIFTBYROWNUMBER(REVENUE.ID, 3) as MATCHINGGIFT3
outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(REVENUE.ID, 1) as REVENUESPLIT1
outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(REVENUE.ID, 2) as REVENUESPLIT2
outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(REVENUE.ID, 3) as REVENUESPLIT3
outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(REVENUE.ID, 4) as REVENUESPLIT4
outer apply dbo.UFN_REVENUE_GETSPLITBYROWNUMBER(REVENUE.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 dbo.UFN_REVENUESPLIT_GETTOP10CAMPAIGNSINONEROW(REVENUESPLIT1.ID) as CAMPAIGNS1
outer apply dbo.UFN_REVENUESPLIT_GETTOP10CAMPAIGNSINONEROW(REVENUESPLIT2.ID) as CAMPAIGNS2
outer apply dbo.UFN_REVENUESPLIT_GETTOP10CAMPAIGNSINONEROW(REVENUESPLIT3.ID) as CAMPAIGNS3
outer apply dbo.UFN_REVENUESPLIT_GETTOP10CAMPAIGNSINONEROW(REVENUESPLIT4.ID) as CAMPAIGNS4
outer apply dbo.UFN_REVENUESPLIT_GETTOP10CAMPAIGNSINONEROW(REVENUESPLIT5.ID) as CAMPAIGNS5
outer apply dbo.UFN_CONSTITUENT_GETMOSTRECENTLYCHANGEDRECOGNITIONPROGRAM(DONOR.ID) as RECOGNITIONPROGRAM
outer apply dbo.UFN_REVENUE_GETREVENUEBENEFITS_BYROWNUMBER(REVENUE.ID, 1) as REVENUEBENEFIT1
outer apply dbo.UFN_REVENUE_GETREVENUEBENEFITS_BYROWNUMBER(REVENUE.ID, 2) as REVENUEBENEFIT2
outer apply dbo.UFN_REVENUE_GETREVENUEBENEFITS_BYROWNUMBER(REVENUE.ID, 3) as REVENUEBENEFIT3
outer apply dbo.UFN_REVENUE_GETREVENUEBENEFITS_BYROWNUMBER(REVENUE.ID, 4) as REVENUEBENEFIT4
outer apply dbo.UFN_REVENUE_GETREVENUEBENEFITS_BYROWNUMBER(REVENUE.ID, 5) as REVENUEBENEFIT5
left join dbo.[UFN_FINANCIALTRANSACTION_GETFIRSTGIFTS]() as [FIRSTGIFTS] on [FIRSTGIFTS].[ID] = [REVENUE].[ID]
where REVENUE_EXT.DONOTACKNOWLEDGE = 0
and REVENUE.TYPECODE <> 3
and REVENUE.DELETEDON is null