V_QUERY_MKTVENDOR
All vendor fields
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(154) | yes | Name |
| DESCRIPTION | nvarchar(255) | Description | |
| WEBADDRESS | UDT_WEBADDRESS | Web site address | |
| ISINACTIVE | bit | Inactive | |
| 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: 11/11/2014 4:14:11 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MKTVENDOR AS
select
[VENDOR].[ID],
[CONSTITUENT].[NAME],
[VENDOR].[DESCRIPTION],
[CONSTITUENT].[WEBADDRESS],
[CONSTITUENT].[ISINACTIVE],
/* System fields */
[ADDEDBY].[APPLICATIONNAME] as [ADDEDBY_APPLICATION],
[ADDEDBY].[USERNAME] as [ADDEDBY_USERNAME],
(case when [VENDOR].[TSLONG] > [CONSTITUENT].[TSLONG] then [CHANGEDBY_VENDOR].[APPLICATIONNAME] else [CHANGEDBY_CONSTITUENT].[APPLICATIONNAME] end) as [CHANGEDBY_APPLICATION],
(case when [VENDOR].[TSLONG] > [CONSTITUENT].[TSLONG] then [CHANGEDBY_VENDOR].[USERNAME] else [CHANGEDBY_CONSTITUENT].[USERNAME] end) as [CHANGEDBY_USERNAME],
[VENDOR].[DATEADDED],
(case when [VENDOR].[DATECHANGED] > [CONSTITUENT].[DATECHANGED] then [VENDOR].[DATECHANGED] else [CONSTITUENT].[DATECHANGED] end) as [DATECHANGED],
(case when [VENDOR].[TSLONG] > [CONSTITUENT].[TSLONG] then [VENDOR].[TSLONG] else [CONSTITUENT].[TSLONG] end) as [TSLONG]
/*#EXTENSION*/
from dbo.[VENDOR]
inner join dbo.[CONSTITUENT] on [CONSTITUENT].[ID] = [VENDOR].[ID]
left join dbo.[CHANGEAGENT] as [ADDEDBY] on [ADDEDBY].[ID] = [VENDOR].[ADDEDBYID]
left join dbo.[CHANGEAGENT] as [CHANGEDBY_VENDOR] on [CHANGEDBY_VENDOR].[ID] = [VENDOR].[CHANGEDBYID]
left join dbo.[CHANGEAGENT] as [CHANGEDBY_CONSTITUENT] on [CHANGEDBY_CONSTITUENT].[ID] = [CONSTITUENT].[CHANGEDBYID]