Customer


The Customer table contains data regarding the global customers of Xtreme Mountain Bikes.

Table B-2: Customer data

Field Name

Data Type

Field Size/Format

Description

Customer ID

Number

Long Integer

Customer unique identification number.

Customer Credit ID

Number

Long Integer

Customer unique credit identification number.

Customer Name

Text

40

Name of the customer.

Contact First Name

Text

30

First name of the contact individual.

Contact Last Name

Text

30

Last name of the contact individual.

Contact Title

Text

5

Title of the contact individual.

Contact Position

Text

30

Position of the contact individual.

Last Year's Sales

Currency

Currency

Last year's total sales for the customer.

Address1

Text

60

The primary street address information for the customer.

Address2

Text

20

A line for secondary address information for the customer.

City

Text

20

The city of the customer's address.

Region

Text

30

The region with which the customer is associated.

Country

Text

30

The country of the customer's address.

Postal Code

Text

10

The postal code of the customer's address.

E-mail

Text

50

The customer's contact e-mail address.

Web Site

Text

50

The customer's web site.

Phone

Text

20

The customer's phone number.

Fax

Text

20

The customer's fax number.




Mastering Business Analysis with Crystal Reports 9
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
Year: 2004
Pages: 177
Authors: Chris Tull

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net