Table 'Purchasing.Vendor', Companies from whom Adventure Works Cycles purchases parts or other goods.

Table 'Purchasing.Vendor', Companies from whom Adventure Works Cycles purchases parts or other goods.

Property Name	Property Value
Records	104
Fields	8
Record size (bytes) w/o BLOBs	2201

Field statistics for 'VendorID' int identity

Field property	Property Value
Minimum value	1
Maximum value	104
Average value	52.5
Values variance	910.0
Unique values	104

Field statistics for 'AccountNumber' AccountNumber

Field property	Property Value
Minimum value	ADATUM0001
Maximum value	WOODFIT0001
Unique values	104

Field statistics for 'Name' Name

Field property	Property Value
Minimum value	A. Datum Corporation
Maximum value	Wood Fitness
Unique values	104

Field statistics for 'CreditRating' tinyint

Field property	Property Value
Minimum value	1
Maximum value	5
Average value	1.3557692307692308
Values variance	0.7168595967139656
Unique values	5

Field statistics for 'PreferredVendorStatus' Flag

Field property	Property Value
Unique values	2

Field statistics for 'ActiveFlag' Flag

Field property	Property Value
Unique values	2

Field statistics for 'PurchasingWebServiceURL' nvarchar(1024)

Field property	Property Value
Minimum value	www.adatum.com/
Maximum value	www.wideworldimporters.com/
Unique values	6

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-26 00:00:00.000
Maximum value	2002-03-21 00:00:00.000
Unique values	10