Databases > WideWorldImporters > Views > Website.Customers

WideWorldImporters

Website.Customers

Created: 6/2/2016 Modified: 6/2/2016

Columns

CustomerID

[int] NOT NULL
CustomerName

[nvarchar](100) NOT NULL
CustomerCategoryName

[nvarchar](50) NULL
PrimaryContact

[nvarchar](50) NULL
AlternateContact

[nvarchar](50) NULL
PhoneNumber

[nvarchar](20) NOT NULL
FaxNumber

[nvarchar](20) NOT NULL
BuyingGroupName

[nvarchar](50) NULL
WebsiteURL

[nvarchar](256) NOT NULL
DeliveryMethod

[nvarchar](50) NULL
CityName

[nvarchar](50) NULL
DeliveryLocation

[geography] NULL
DeliveryRun

[nvarchar](5) NULL
RunPosition

[nvarchar](5) NULL

Definition

Sample Data

CustomerID

CustomerName

CustomerCategoryName

PrimaryContact

AlternateContact

PhoneNumber

FaxNumber

BuyingGroupName

WebsiteURL

DeliveryMethod

CityName

DeliveryLocation

DeliveryRun

RunPosition

Tailspin Toys (Head Office)

Novelty Shop

Waldemar Fisar

Laimonis Berzins

(308) 555-0100

(308) 555-0101

Tailspin Toys

http://www.tailspintoys.com

Delivery Van

Lisco

[geography]

NULL

Tailspin Toys (Sylvanite, MT)

Novelty Shop

Lorena Cindric

Hung Van Groesen

(406) 555-0100

(406) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Sylvanite

Delivery Van

Sylvanite

[geography]

NULL

Tailspin Toys (Peeples Valley, AZ)

Novelty Shop

Bhaargav Rambhatla

Mudar Jevtic

(480) 555-0100

(480) 555-0101

Tailspin Toys

http://www.tailspintoys.com/PeeplesValley

Delivery Van

Peeples Valley

[geography]

NULL

Tailspin Toys (Medicine Lodge, KS)

Novelty Shop

Daniel Roman

Leyla Radnia

(316) 555-0100

(316) 555-0101

Tailspin Toys

http://www.tailspintoys.com/MedicineLodge

Delivery Van

Medicine Lodge

[geography]

NULL

Tailspin Toys (Gasport, NY)

Novelty Shop

Johanna Huiting

Robert Ruutli

(212) 555-0100

(212) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Gasport

Delivery Van

Gasport

[geography]

NULL

Tailspin Toys (Jessie, ND)

Novelty Shop

Biswajeet Thakur

Radha Shah

(701) 555-0100

(701) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Jessie

Delivery Van

Jessie

[geography]

NULL

Tailspin Toys (Frankewing, TN)

Novelty Shop

Kalidas Nadar

Filip Nedvidek

(423) 555-0100

(423) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Frankewing

Delivery Van

Frankewing

[geography]

NULL

Tailspin Toys (Bow Mar, CO)

Novelty Shop

Kanti Kotadia

Hoa Cu

(303) 555-0100

(303) 555-0101

Tailspin Toys

http://www.tailspintoys.com/BowMar

Delivery Van

Bow Mar

[geography]

NULL

Tailspin Toys (Netcong, NJ)

Novelty Shop

Sointu Aalto

Jae-Gon Min

(201) 555-0100

(201) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Netcong

Delivery Van

Netcong

[geography]

NULL

Tailspin Toys (Wimbledon, ND)

Novelty Shop

Siddhartha Parkar

Paula Matos

(701) 555-0100

(701) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Wimbledon

Delivery Van

Wimbledon

[geography]

NULL

Tailspin Toys (Devault, PA)

Novelty Shop

Elnaz Javan

Jayashish Ghatak

(215) 555-0100

(215) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Devault

Delivery Van

Devault

[geography]

NULL

Tailspin Toys (Biscay, MN)

Novelty Shop

Heloisa Fernandes

Amornrat Rattanaporn

(218) 555-0100

(218) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Biscay

Delivery Van

Biscay

[geography]

NULL

Tailspin Toys (Stonefort, IL)

Novelty Shop

Razeena Hosseini

Leticia Ribeiro

(217) 555-0100

(217) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Stonefort

Delivery Van

Stonefort

[geography]

NULL

Tailspin Toys (Long Meadow, MD)

Novelty Shop

Tereza Valentova

Brijesh Ganguly

(240) 555-0100

(240) 555-0101

Tailspin Toys

http://www.tailspintoys.com/LongMeadow

Delivery Van

Long Meadow

[geography]

NULL

Tailspin Toys (Batson, TX)

Novelty Shop

Filips Jaunzems

Bharati Bhowmick

(210) 555-0100

(210) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Batson

Delivery Van

Batson

[geography]

NULL

Tailspin Toys (Coney Island, MO)

Novelty Shop

Nitin Matondkar

Joy Dutta

(314) 555-0100

(314) 555-0101

Tailspin Toys

http://www.tailspintoys.com/ConeyIsland

Delivery Van

Coney Island

[geography]

NULL

Tailspin Toys (East Fultonham, OH)

Novelty Shop

Adam Kubat

Gulzar Naidu

(216) 555-0100

(216) 555-0101

Tailspin Toys

http://www.tailspintoys.com/EastFultonham

Delivery Van

East Fultonham

[geography]

NULL

Tailspin Toys (Goffstown, NH)

Novelty Shop

Isabelle Vodlan

Prakash Sarma

(603) 555-0100

(603) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Goffstown

Delivery Van

Goffstown

[geography]

NULL

Tailspin Toys (Lemeta, AK)

Novelty Shop

Mithun Bhattacharya

Sandhya Raju

(907) 555-0100

(907) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Lemeta

Delivery Van

Lemeta

[geography]

NULL

Tailspin Toys (College Place, WA)

Novelty Shop

Nghi Hua

Ravindra Parkar

(206) 555-0100

(206) 555-0101

Tailspin Toys

http://www.tailspintoys.com/CollegePlace

Delivery Van

College Place

[geography]

NULL

Tailspin Toys (Tresckow, PA)

Novelty Shop

Duleep Raju

Vlatka Duvnjak

(215) 555-0100

(215) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Tresckow

Delivery Van

Tresckow

[geography]

NULL

Tailspin Toys (Ward Ridge, FL)

Novelty Shop

Cristina Longo

Antonio Lucchese

(239) 555-0100

(239) 555-0101

Tailspin Toys

http://www.tailspintoys.com/WardRidge

Delivery Van

Ward Ridge

[geography]

NULL

Tailspin Toys (Ikatan, AK)

Novelty Shop

Hang Tang

Hong Ang

(907) 555-0100

(907) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Ikatan

Delivery Van

Ikatan

[geography]

NULL

Tailspin Toys (Dundarrach, NC)

Novelty Shop

Intira Mookjai

Young-Tae Kim

(252) 555-0100

(252) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Dundarrach

Delivery Van

Dundarrach

[geography]

NULL

Tailspin Toys (Avenal, CA)

Novelty Shop

Sulabha Khalsa

Alessandro Milano

(209) 555-0100

(209) 555-0101

Tailspin Toys

http://www.tailspintoys.com/Avenal

Delivery Van

Avenal

[geography]

NULL