V_QUERY_VENDOR
Query for vendors.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| DISPLAYNAME | nvarchar(154) | yes | Display name |
| KEYNAME | nvarchar(100) | Last/Org name | |
| FIRSTNAME | nvarchar(50) | First name | |
| MIDDLENAME | nvarchar(50) | Middle name | |
| ISORGANIZATION | bit | Is organization | |
| TITLE | nvarchar(100) | yes | Title |
| SUFFIX | nvarchar(100) | yes | Suffix |
| INDUSTRY | nvarchar(100) | yes | Industry |
| WEBADDRESS | UDT_WEBADDRESS | Web address | |
| CUSTOMERNUMBER | nvarchar(20) | Customer number | |
| PAYMENTTERMNAME | nvarchar(20) | yes | Payment terms |
| PAYMENTMETHOD | nvarchar(5) | yes | Payment method |
| INCLUDEIN1099 | bit | Include in 1099 reporting | |
| REMITADDRESSID | uniqueidentifier | yes | Remit Address |
| PAYMENTBANKACCOUNTID | uniqueidentifier | yes | Payment Bank Account |
| ALLOWPAYMENTS | bit | Allow payments | |
| ALLOWTOCREATEINVOICES | bit | Allow invoices | |
| TAXIDNUMBER | nvarchar(64) | Tax Identification Number | |
| DESCRIPTION | nvarchar(255) | Description | |
| CHECK1099BOX9 | bit | yes | 1099 box 9 |
| CHECK10992TIN | bit | yes | 1099 2nd TIN |
| FIRSTLINEKEYNAME | nvarchar(100) | yes | Name first line |
| SECONDLINEKEYNAME | nvarchar(100) | yes | Name second line |
| ADDRESSID | uniqueidentifier | yes | Address |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| 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 |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:46 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_VENDOR AS
select
V.ID,
C.NAME as DISPLAYNAME,
C.KEYNAME,
C.FIRSTNAME,
C.MIDDLENAME,
C.ISORGANIZATION,
TC.[DESCRIPTION] as TITLE,
SC.[DESCRIPTION] as SUFFIX,
dbo.UFN_INDUSTRYCODE_GETDESCRIPTION(COALESCE(OD.INDUSTRYCODEID, CJ.INDUSTRYCODEID)) as INDUSTRY,
C.WEBADDRESS,
V.CUSTOMERNUMBER,
PT.NAME as PAYMENTTERMNAME,
V.PAYMENTMETHOD,
V.INCLUDEIN1099,
V.REMITADDRESSID,
V.PAYMENTBANKACCOUNTID,
V.ALLOWPAYMENTS,
V.ALLOWTOCREATEINVOICES,
V.TAXIDNUMBER,
V.[DESCRIPTION],
VS.CHECK1099BOX9,
VS.CHECK10992TIN,
A1.KEYNAME as FIRSTLINEKEYNAME,
A2.KEYNAME as SECONDLINEKEYNAME,
VS.ADDRESSID,
V.DATEADDED,
V.DATECHANGED,
V.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
from dbo.VENDOR as V
inner join dbo.CONSTITUENT as C on C.ID = V.ID
left join dbo.SUFFIXCODE as SC on SC.ID = C.SUFFIXCODEID
left join dbo.TITLECODE as TC on TC.ID = C.TITLECODEID
left join dbo.ORGANIZATIONDATA as OD on C.ID = OD.ID and C.ISORGANIZATION = 1
left join dbo.CONSTITUENTJOBINFO as CJ on C.ID = CJ.ID and C.ISORGANIZATION = 0
left join dbo.PAYMENTTERM as PT on PT.ID = V.PAYMENTTERMID
left join dbo.VENDOR1099SETTING as VS on VS.ID = V.ID
left join dbo.ALIAS as A1 on A1.ID = VS.NAMEFIRSTLINEALIASTYPECODEID
left join dbo.ALIAS as A2 on A2.ID = VS.NAMESECONDLINEALIASTYPECODEID
left join dbo.CHANGEAGENT as ADDEDBY on ADDEDBY.ID = V.ADDEDBYID
left join dbo.CHANGEAGENT as CHANGEDBY on CHANGEDBY.ID = V.CHANGEDBYID