V_QUERY_BBNCFUNDRAISERBATCHEXCEPTIONREPORT

View used for output by the Blackbaud Internet Solutions Fundraiser Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(100)	yes	Name

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:41:54 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BBNCFUNDRAISERBATCHEXCEPTIONREPORT AS



                select 
                    [BATCHBBNCFUNDRAISER].[ID],
                    [APPEAL].[NAME]
                from 
                    dbo.BATCHBBNCFUNDRAISER
                    left join dbo.APPEAL on [BATCHBBNCFUNDRAISER].[APPEALID] = [APPEAL].[ID]