Vendor Table (AdventureWorks)

Contains companies from whom Adventure Works Cycles purchases parts or other goods.

Vendor Table Definition

The Vendor table is contained in the Purchasing schema.

Column	Data type	Nullability	Description
VendorID	int	Not null	Primary key.
AccountNumber	AccountNumber (user-defined type) nvarchar(15)	Not null	Vendor account (identification) number.
Name	Name (user-defined type) nvarchar(50)	Not null	Company name.
CreditRating	tinyint	Not null	1 = Superior 2 = Excellent 3 = Above average 4 = Average 5 = Below average
PreferredVendorStatus	Flag (user-defined type) bit	Not null	0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.
ActiveFlag	Flag (user-defined type) bit	Not null	0 = Vendor is no longer used. 1 = Vendor is actively used.
PurchasingWebServiceURL	nvarchar(1024)	Null	Vendor URL.
ModifiedDate	datetime	Not null	Date and time the row was last updated.