V_QUERY_EVENTSALESMETHOD

Provides the ability to query event sales methods.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
EVENTID	uniqueidentifier	yes	Event system ID
SALESMETHODID	uniqueidentifier	yes	Sales method system ID
SALESMETHODNAME	nvarchar(50)	yes	Name
ONSALEDATE	datetime	yes	On sale date
ONSALETIME	UDT_HOURMINUTE		On sale time
ONSALEDATETIME	datetime	yes	On sale date time
ONSALEDATETIMEWITHOFFSET	datetimeoffset	yes	On sale date with offset
ADDEDBY_APPLICATION	nvarchar(200)	yes	Added by application
ADDEDBY_USERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBY_USERNAME	nvarchar(128)	yes	Changed by user name
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:59 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_EVENTSALESMETHOD AS



                select EVENTSALESMETHOD.ID,
                    EVENTSALESMETHOD.EVENTID,
                    EVENTSALESMETHOD.SALESMETHODID,
                    dbo.UFN_TRANSLATIONFUNCTION_SALESMETHOD_GETNAME(EVENTSALESMETHOD.SALESMETHODID) as SALESMETHODNAME,
                    EVENTSALESMETHOD.ONSALEDATE,
                    EVENTSALESMETHOD.ONSALETIME,
                    EVENTSALESMETHOD.ONSALEDATETIME,
                    EVENTSALESMETHOD.ONSALEDATETIMEWITHOFFSET,
                    [ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    [ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
                    [CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
                    EVENTSALESMETHOD.DATEADDED,
                    EVENTSALESMETHOD.DATECHANGED,
                    EVENTSALESMETHOD.TSLONG
                /*#EXTENSION*/

                from dbo.EVENTSALESMETHOD
                left outer join    dbo.CHANGEAGENT as [ADDEDBY] 
                    on EVENTSALESMETHOD.ADDEDBYID = [ADDEDBY].ID
                left outer join dbo.CHANGEAGENT as [CHANGEDBY] 
                    on EVENTSALESMETHOD.CHANGEDBYID = [CHANGEDBY].ID