V_SIMPLEDATALIST_LETTERCODE_ASSIGNLETTERCODEPROCESS

Returns a list of revenue letters along with revenue letters linked to an assign letter code process.

Fields

Field	Field Type	Null	Description
LABEL	nvarchar(100)

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  2/1/2011 9:03:33 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_LETTERCODE_ASSIGNLETTERCODEPROCESS AS



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