V_SIMPLEDATALIST_RECEIPTOUTPUTQUERYVIEW

Returns a list of receipt output business process views.

Fields

Field	Field Type	Null	Description
LABEL	nvarchar(255)

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  1/27/2010 6:56:19 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.5.465.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_RECEIPTOUTPUTQUERYVIEW AS



                select 
                    BUSINESSPROCESSVIEW.CAPTION as LABEL
                from 
                    dbo.QUERYVIEWCATALOG 
                left join 
                    dbo.RECORDTYPE on QUERYVIEWCATALOG.RECORDTYPEID = RECORDTYPE.ID
                inner join 
                    dbo.BUSINESSPROCESSVIEW on QUERYVIEWCATALOG.ID = BUSINESSPROCESSVIEW.QUERYVIEWCATALOGID;