V_SIMPLEDATALIST_MKTLETTERCODE
Returns a list of letters.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LABEL | nvarchar(100) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:15:50 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_MKTLETTERCODE AS
select
[LETTERCODE].[NAME] as [LABEL]
from dbo.[LETTERCODE]
inner join dbo.[EXPORTDEFINITION] on [EXPORTDEFINITION].[ID] = [LETTERCODE].[EXPORTDEFINITIONID]
where [LETTERCODE].[ISACTIVE] = 1
and dbo.[UFN_MKTEXPORTDEFINITION_RECORDTYPEIDISVALIDFORMARKETING]([EXPORTDEFINITION].[RECORDTYPEID]) = 1;