Purchasing.vVendor

View: 'Purchasing.vVendor', Vendor (company) names and addresses and the names of vendor employees to contact.

Field NameType and Size
VendorIDint NOT NULL
NameName NOT NULL
ContactTypeName NOT NULL
Titlenvarchar(8) NULL
FirstNameName NOT NULL
MiddleNameName NULL
LastNameName NOT NULL
Suffixnvarchar(10) NULL
PhonePhone NULL
EmailAddressnvarchar(50) NULL
EmailPromotionint NOT NULL
AddressLine1nvarchar(60) NOT NULL
AddressLine2nvarchar(60) NULL
Citynvarchar(30) NOT NULL
StateProvinceNameName NOT NULL
PostalCodenvarchar(15) NOT NULL
CountryRegionNameName NOT NULL