Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)

2017-07-07 02:10:07

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.

Категории