V_QUERY_REMINDERSEXPORTROOT
Export definitions used with reminders are based on this query view.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FINDERNUMBER | nvarchar(20) | yes | Finder number |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
| AMOUNTDUE | money | yes | Amount due |
| PROCESSEDDATE | datetime | yes | Process date |
| NEXTINSTALLMENTDATE | datetime | yes | Next installment date |
| PASTDUEAMOUNT | money | yes | Past due amount |
| CURRENTDUEAMOUNT | money | yes | Current due amount |
| AMOUNTRECEIVEDSINCELASTREMINDER | money | yes | Amount received since last reminder |
| PAIDTHROUGH | datetime | yes | Paid through |
| DATEOFLASTPAYMENT | datetime | yes | Date of last payment |
| REVENUEID_08BEBCA2_49AF_4451_BB21_8AAA46E96577 | uniqueidentifier | yes | Revenue Marketing |
| DONORID_08BEBCA2_49AF_4451_BB21_8AAA46E96577 | uniqueidentifier | yes | Constituent Marketing Information |
| DESIGNATIONLIST | nvarchar(3000) | yes | |
| PLEDGEBALANCE | money | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:33:27 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_REMINDERSEXPORTROOT AS
select
cast('' as nvarchar(20)) as [FINDERNUMBER]
,cast(null as uniqueidentifier) as [BASECURRENCYID]
,cast(null as money) as [AMOUNTDUE]
,cast(null as datetime) as [PROCESSEDDATE]
,cast(null as datetime) as [NEXTINSTALLMENTDATE]
,cast(null as money) as [PASTDUEAMOUNT]
,cast(null as money) as [CURRENTDUEAMOUNT]
,cast(null as money) as [AMOUNTRECEIVEDSINCELASTREMINDER]
,cast(null as datetime) as [PAIDTHROUGH]
,cast(null as datetime) as [DATEOFLASTPAYMENT]
,cast(null as uniqueidentifier) as [REVENUEID_08BEBCA2_49AF_4451_BB21_8AAA46E96577]
,cast(null as uniqueidentifier) as [DONORID_08BEBCA2_49AF_4451_BB21_8AAA46E96577]
,cast(null as nvarchar(3000)) as [DESIGNATIONLIST]
,cast(null as money) as [PLEDGEBALANCE]