V_SIMPLEDATALIST_LETTERCODE

Returns a list of revenue letters.

Fields

Field	Field Type	Null	Description
LABEL	nvarchar(100)

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:15:48 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_LETTERCODE AS



                select 
                    NAME as LABEL
                from
                    dbo.LETTERCODE
                where
                    ISACTIVE = 1
                    and IDSETREGISTERID is not null
                    and ISSYSTEM = 0