Purchases

The Purchases table contains data regarding the purchase information of Xtreme Mountain Bikes products.

Table B-10: Purchase data

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.