Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
|
The Purchases table contains data regarding the purchase information of Xtreme Mountain Bikes products.
| Field Name | Data Type | Length | Description |
|---|---|---|---|
| Product ID | Number | Long Integer | Unique identification number assigned to the product. |
| Reorder Level | Number | Long Integer | Minimum number of products left in inventory before a reorder is made. |
| Units in Stock | Number | Long Integer | Current number of product units in stock. |
| Units on Order | Number | Long Integer | Current number of products on order. |
| PO# | Number | Long Integer | Purchase order number. |
| Order Date | Date/Time | Date/Time | Date an order for products was made. |
| Expected Receiving Date | Date/Time | (undefined) | Expected receiving date for the product. |
| Received | Logical | Yes/No | Boolean which states "yes" or "no" to whether the product was received. |
| Paid | Logical | Yes/No | Boolean which states "yes" or "no" to whether payment was made for the product shipment. |
|