Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
|
The Product table contains data regarding each of Xtreme Mountain Bikes' products.
| Field Name | Data Type | Length | Description |
|---|---|---|---|
| Product ID | Number | Long Integer | Unique identification number assigned to each product. |
| Product Name | Text | 50 | Name of the product. |
| Color | Text | 20 | Color of the product. |
| Size | Text | 10 | Size of the product. |
| M/F | Text | 10 | States whether product is for men or women specifically. |
| Price (SRP) | Currency | Currency | The price of the product. |
| Product Type ID | Number | Long Integer | Unique identification number assigned to each product type. |
| Product Class | Text | 50 | The product class. |
| Supplier ID | Number | Long Integer | Unique identification number assigned to each product supplier. |
|