Table 'Purchasing.ProductVendor', Cross-reference table mapping vendors with the products they supply.

Table 'Purchasing.ProductVendor', Cross-reference table mapping vendors with the products they supply.

Property Name	Property Value
Records	406
Fields	11
Record size (bytes) w/o BLOBs	104

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	952
Average value	475.04679802955667
Values variance	31989.95582922826
Unique values	211

Field statistics for 'VendorID' int

Field property	Property Value
Minimum value	1
Maximum value	104
Average value	50.820197044334975
Values variance	790.95771452897873
Unique values	79

Field statistics for 'AverageLeadTime' int

Field property	Property Value
Minimum value	15
Maximum value	19
Average value	16.940886699507388
Values variance	2.0853858784893182
Unique values	5

Field statistics for 'StandardPrice' money(19,4)

Field property	Property Value
Minimum value	.2000
Maximum value	78.8900
Average value	36.446748768472858
Values variance	151.64969458858351
Unique values	144

Field statistics for 'LastReceiptCost' money(19,4)

Field property	Property Value
Minimum value	.2100
Maximum value	82.8345
Average value	38.26908620689656
Values variance	167.1937882839064
Unique values	144

Field statistics for 'LastReceiptDate' datetime

Field property	Property Value
Minimum value	2001-08-22 00:00:00.000
Maximum value	2001-09-29 00:00:00.000
Unique values	29

Field statistics for 'MinOrderQty' int

Field property	Property Value
Minimum value	1
Maximum value	500
Average value	28.53448275862069
Values variance	2883.2420178799489
Unique values	4

Field statistics for 'MaxOrderQty' int

Field property	Property Value
Minimum value	5
Maximum value	2000
Average value	262.1305418719212
Values variance	195826.86933649576
Unique values	4

Field statistics for 'OnOrderQty' int

Field property	Property Value
Minimum value	3
Maximum value	300
Average value	98.10891089108911
Values variance	18436.058019801978
Unique values	3

Field statistics for 'UnitMeasureCode' nchar(3)

Field property	Property Value
Minimum value	CAN
Maximum value	PAK
Unique values	7

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-08-22 00:00:00.000
Maximum value	2001-09-29 00:00:00.000
Unique values	29