AdventureWorks2019
Purchasing.vVendorWithAddresses
//
Vendor (company) names and addresses .
Created: Modified:
Columns
-
BusinessEntityID[int] NOT NULL
-
Name[Name] NOT NULL
-
AddressType[Name] NOT NULL
-
AddressLine1[nvarchar](60) NOT NULL
-
AddressLine2[nvarchar](60) NULL
-
City[nvarchar](30) NOT NULL
-
StateProvinceName[Name] NOT NULL
-
PostalCode[nvarchar](15) NOT NULL
-
CountryRegionName[Name] NOT NULL
Definition
Sample Data
BusinessEntityID
Name
AddressType
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryRegionName
1492
Australia Bike Retailer
Main Office
28 San Marino Ct.
NULL
Bellingham
Washington
98225
United States
1494
Allenson Cycles
Main Office
4659 Montoya
NULL
Altadena
California
91001
United States
1496
Advanced Bicycles
Main Office
7995 Edwards Ave.
NULL
Lynnwood
Washington
98036
United States
1498
Trikes, Inc.
Main Office
90 Sunny Ave
NULL
Berkeley
California
94704
United States
1500
Morgan Bike Accessories
Main Office
9098 Story Lane
NULL
Albany
New York
12210
United States
1502
Cycling Master
Main Office
4823 Stonewood Ct.
NULL
Walla Walla
Washington
99362
United States
1504
Chicago Rent-All
Main Office
15 Pear Dr.
NULL
Newport Beach
California
92625
United States
1506
Greenwood Athletic Company
Main Office
6441 Co Road
NULL
Lemon Grove
Arizona
85252
United States
1508
Compete Enterprises, Inc
Main Office
50 Via Del Sol
NULL
Lynnwood
Washington
98036
United States
1510
International
Main Office
683 Larch Ct.
NULL
Salt Lake City
Utah
84101
United States
1512
Light Speed
Main Office
298 Sunnybrook Drive
NULL
Spring Valley
California
91977
United States
1514
Training Systems
Main Office
6 Dancing Road
NULL
Burien
Washington
98168
United States
1516
Gardner Touring Cycles
Main Office
8513 Hurlstone Ct.
NULL
Altadena
California
91001
United States
1518
International Trek Center
Main Office
8844 Garcia
NULL
West Covina
California
91791
United States
1520
G & K Bicycle Corp.
Main Office
8981 Carmel Drive
NULL
W. Linn
Nevada
89701
United States
1522
First National Sport Co.
Main Office
8127 Otter Dr.
NULL
Boise
Idaho
83702
United States
1524
Recreation Place
Main Office
207 Concerto Circle
NULL
Salem
Oregon
97301
United States
1526
International Bicycles
Main Office
20 Rambling Rose Ave.
# 103
West Covina
California
91791
United States
1528
Image Makers Bike Center
Main Office
3195 RiverRock Dr.
NULL
Burlingame
California
94010
United States
1530
Comfort Road Bicycles
Main Office
7651 Smiling Tree Court
Space 55
Los Angeles
California
90012
United States
1532
Knopfler Cycles
Main Office
3253 La Jolla
NULL
Salem
Oregon
97301
United States
1534
Ready Rentals
Main Office
35 Buckthorn Court
# 1
Kirkland
Washington
98033
United States
1536
Cruger Bike Company
Main Office
67 Monetary Way
NULL
Berkeley
California
94704
United States
1538
Vista Road Bikes
Main Office
8197 Hermosa
NULL
Salem
Oregon
97301
United States
1540
Bergeron Off-Roads
Main Office
9830 May Way
NULL
Mill Valley
Montana
59715
United States