V_SEARCHLIST_VENDORCONTACT
This provides the ability to search for individuals to serve as vendor contacts.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| LOOKUPID | nvarchar(100) | yes | |
| NAME | nvarchar(154) | yes | |
| ADDRESS | nvarchar(150) | yes | |
| CITY | nvarchar(50) | yes | |
| STATE | nvarchar(100) | yes | |
| POSTCODE | nvarchar(12) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/1/2011 9:09:26 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCHLIST_VENDORCONTACT AS
select
[CONSTITUENT].[ID],
[CONSTITUENT].[LOOKUPID],
NF.[NAME],
[ADDRESS].[ADDRESSBLOCK] [ADDRESS],
[ADDRESS].[CITY],
[STATE].[DESCRIPTION] as [STATE],
[ADDRESS].[POSTCODE]
from dbo.[CONSTITUENT]
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
left join dbo.[ADDRESS] on [CONSTITUENT].[ID] = [ADDRESS].[CONSTITUENTID]
left join dbo.[STATE] on [ADDRESS].[STATEID] = [STATE].[ID];