V_QUERY_SALESORDERALERTEMAILSUBSCRIPTION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| EMAILADDRESS | UDT_EMAILADDRESS | ||
| APPUSERID | uniqueidentifier | ||
| ALERTONDAILYADMISSION | bit | ||
| ALERTONSCHEDULEDPROGRAM | bit | ||
| ALERTONSPECIALEVENT | bit | ||
| ALERTONMEMBERSHIP | bit | ||
| ALERTONDONATION | bit | ||
| APPUSERDISPLAYNAME | nvarchar(255) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:39:22 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SALESORDERALERTEMAILSUBSCRIPTION AS
select
SALESORDERALERTEMAILSUBSCRIPTION.ID,
SALESORDERALERTEMAILADDRESS.EMAILADDRESS,
SALESORDERALERTEMAILADDRESS.APPUSERID,
SALESORDERALERTCONFIGURATION.ALERTONDAILYADMISSION,
SALESORDERALERTCONFIGURATION.ALERTONSCHEDULEDPROGRAM,
SALESORDERALERTCONFIGURATION.ALERTONSPECIALEVENT,
SALESORDERALERTCONFIGURATION.ALERTONMEMBERSHIP,
SALESORDERALERTCONFIGURATION.ALERTONDONATION,
APPUSER.DISPLAYNAME as APPUSERDISPLAYNAME
from dbo.SALESORDERALERTEMAILSUBSCRIPTION
inner join dbo.SALESORDERALERTCONFIGURATION on
SALESORDERALERTEMAILSUBSCRIPTION.SALESORDERALERTCONFIGURATIONID = SALESORDERALERTCONFIGURATION.ID
inner join dbo.SALESORDERALERTEMAILADDRESS on
SALESORDERALERTEMAILSUBSCRIPTION.SALESORDERALERTEMAILADDRESSID = SALESORDERALERTEMAILADDRESS.ID
inner join dbo.APPUSER on
SALESORDERALERTEMAILADDRESS.APPUSERID = APPUSER.ID