V_SIMPLEDATALIST_LETTERCODE_ALL
Returns a list of all revenue letters.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LABEL | nvarchar(100) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:44:39 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_LETTERCODE_ALL AS
select
[LETTERCODE].[NAME] as [LABEL]
from dbo.[LETTERCODE]
left outer join dbo.[EXPORTDEFINITION] on [EXPORTDEFINITION].[ID] = [LETTERCODE].[EXPORTDEFINITIONID]
left outer join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [EXPORTDEFINITION].[RECORDTYPEID]
where (
[LETTERCODE].[IDSETREGISTERID] is not null
or
([LETTERCODE].[EXPORTDEFINITIONID] is not null and dbo.[UFN_MKTEXPORTDEFINITION_GETMAILINGTYPECODEFROMRECORDTYPE]([RECORDTYPE].[NAME]) in (1, 5))
)