Object type: Data view

Vendor (company) names and addresses and the names of vendor employees to contact.

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
No	No	No	No	No

Data Source Activity 

Accesses	Description
Person.Address	Street address information for customers, employees, and vendors.
Person.Contact	Names of each employee, customer contact, and vendor contact.
Person.ContactType	Lookup table containing the types of contacts stored in Contact.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.
Purchasing.Vendor	Companies from whom Adventure Works Cycles purchases parts or other goods.
Purchasing.VendorAddress	Cross-reference mapping vendors and addresses.
Purchasing.VendorContact	Cross-reference table mapping vendors and their employees.

Output Recordset 

Column	Description
VendorID
Name
ContactType
Title
FirstName
MiddleName
LastName
Suffix
Phone
EmailAddress
EmailPromotion
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryRegionName

Data source	Description
Person.Address	Street address information for customers, employees, and vendors.
Person.Contact	Names of each employee, customer contact, and vendor contact.
Person.ContactType	Lookup table containing the types of contacts stored in Contact.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.
Purchasing.Vendor	Companies from whom Adventure Works Cycles purchases parts or other goods.
Purchasing.VendorAddress	Cross-reference mapping vendors and addresses.
Purchasing.VendorContact	Cross-reference table mapping vendors and their employees.

Applies to

Views

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation