V_QUERY_PLEDGEREMINDERPROCESSSEASONALADDRESSDETAILS
View used for standard output for the pledge reminder process details when grouping by revenue is chosen.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTLOOKUPID | nvarchar(100) | yes | Constituent Lookup ID |
| REVENUEID | uniqueidentifier | System record id | |
| TOTALPLEDGEAMOUNT | money | Total Amount | |
| GIVENANONYMOUSLY | varchar(3) | Anonymous | |
| PLEDGEDATE | datetime | yes | Date |
| PLEDGEBALANCE | money | yes | Pledge balance |
| AMOUNTPAID | money | Amount paid | |
| APPEALNAME | nvarchar(100) | yes | Appeal name |
| DESIGNATION1NAME | nvarchar(512) | yes | Designation 1 |
| DESIGNATION1PUBLICNAME | nvarchar(512) | yes | Designation 1 public name |
| DESIGNATION1AMOUNT | money | yes | Designation 1 amount |
| DESIGNATION2NAME | nvarchar(512) | yes | Designation 2 |
| DESIGNATION2PUBLICNAME | nvarchar(512) | yes | Designation 2 public name |
| DESIGNATION2AMOUNT | money | yes | Designation 2 amount |
| REVENUELOOKUPID | nvarchar(100) | yes | Revenue lookup ID |
| TRANSACTIONCURRENCYID | uniqueidentifier | Transaction currency ID | |
| TRANSACTIONCURRENCY | nvarchar(3) | yes | Transaction currency |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:36:01 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PLEDGEREMINDERPROCESSSEASONALADDRESSDETAILS AS
select top(100) PERCENT
CONSTITUENTLOOKUPID,
REVENUEID,
TOTALPLEDGEAMOUNT,
GIVENANONYMOUSLY,
PLEDGEDATE,
PLEDGEBALANCE,
AMOUNTPAID,
APPEALNAME,
DESIGNATION1NAME,
DESIGNATION1PUBLICNAME,
DESIGNATION1AMOUNT,
DESIGNATION2NAME,
DESIGNATION2PUBLICNAME,
DESIGNATION2AMOUNT,
REVENUELOOKUPID,
TRANSACTIONCURRENCYID,
TRANSACTIONCURRENCY
from V_QUERY_PLEDGEREMINDERPROCESS_SEASONALADDRESSOUTPUT
order by CONSTITUENTLOOKUPID