Orders

The Orders table contains data regarding customer orders of Xtreme Mountain Bikes' products.

Table B-6: Order data

Field Name	Data Type	Length	Description
Order ID	AutoNumber	Long Integer	Unique identification number assigned to each order.
Order Amount	Currency	Currency	Total amount of the order.
Customer ID	Number	Long Integer	Customer unique identification number.
Employee ID	Number	Long Integer	Employee unique identification number.
Order Date	Date/Time	General Date (MM/DD/YYYY HH:MM:SS AM/PM)	Date on which order was placed.
Required Date	Date/Time	Short Date (MM/DD/YYYY)	Date on which order is required to be received.
Ship Date	Date/Time	General Date (MM/DD/YYYY HH:MM:SS AM/PM)	Date on which order was shipped.
Ship Via	Text	20	Comment regarding how product was shipped.
Courier Web Site	Hyperlink	h"ttp"://www".up"s \.c\om	The courier's web site address.
Shipped	Logical	Yes/No	Boolean which states "yes" or "no" to whether the product was shipped.
PO#	Text	50	The purchase order number.
Payment Received	Logical	Yes/No	Boolean which states "yes" or "no" to whether payment was received for the order.