V_QUERY_MERCHANDISE_VENDOR
Query merchandise vendors.
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? | |
| PRIMARYCONTACTID | uniqueidentifier | yes | Primary contact |
| PRODUCTID | uniqueidentifier | yes | Product |
| 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: 3/19/2013 1:37:49 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MERCHANDISE_VENDOR AS
select
[VENDOR].[ID],
[CONSTITUENT].[NAME],
[VENDOR].[DESCRIPTION],
[CONSTITUENT].[WEBADDRESS],
[CONSTITUENT].[ISINACTIVE],
[RELATIONSHIP].[RECIPROCALCONSTITUENTID] as PRIMARYCONTACTID,
[PRODUCTVENDOR].[PRODUCTID],
/* 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]
left outer join dbo.[PRODUCTVENDOR]
on [PRODUCTVENDOR].[VENDORID] = [VENDOR].[ID]
left outer join dbo.[RELATIONSHIP]
on [RELATIONSHIP].[RELATIONSHIPCONSTITUENTID] = [VENDOR].[ID] and [RELATIONSHIP].[ISPRIMARYCONTACT] = 1
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]