Name Type/ Size Field Size P/Key F/Key

Customer_ID Number 8 Yes No

Customer_Last_Name Character 20 No No

Customer_First_Name Character 20 No No

Customer_Street VarChar (25) No No

Customer_City Character 15

Customer_State Text 2

Customer_Zip Number 5

Customer_Home_PhoneNumber 12 No No

Customer_Work_PhoneNumber 12 No No

Customer_Fax_ Number 12 No No

Customer_Email Character 50 No No

Last_Shiping_Street VarChar (25) No No

Last_Shiping_City Character 15

Last_Shiping _State Text 2

Last_Shiping _Zip Number 5

Last_Shiping_Name Text 20

Tax_Exempt_Number Number 20

Name Type/ Size Field Size P/Key F/Key

Employee_ID Number 8 Yes No

Employee_Last_Name Character 20 No No

Employee_First_NameCharacter 20 No No

Employee_Street VarChar (25) No No

Employee_City Character 15

Employee_State Text 2

Employee_Zip Number 5

Employee_Home_PhoneNumber 12 No No

Employee_Extension Number 4 No No

Employee_Email Character 50 No No

Employee_Type Number 3 No No

Field Name Type Field Size P/Key F/Key

Line_Item_Number Number 10 Yes No

Order_ID VarChar 15 No Yes

Product_Code VarChar 20 No Yes

Quantity Number 5 No No

Field Name Type Field Size P/Key F/Key

Order_ID VarChar 15 No Yes

Date Date 8 No No

Time Time 8 No No

Activity Character 50 No No

Location Character 20 No No

Extra_Informatiom Memo No No

Field Name Type Field Size P/Key F/Key

Order_ID Number 15 AN Yes No

Employee_ID Number 8 No Yes

Approx_Due_Date Date 8 No No

Must_Due_Date Date 8 No No

Sale_Date Date 8 No No

Delivery_Type Text 25 No No

Subtotal Currency 7 No No

Freight Currency 7 No No

Tax Currency 7 No No

Total Currency 7 No No

Deposit Currency 7 No No

Balance Currency 7 No No

Purchase_Agent No No

Payment_Method Text 25 No No

Customer_ID Number 8 No Yes

Discount Number 2

P_O_Num Number 20

Field Name Type Field Size P/Key F/Key

Product_Code VarChar 20 Yes No

Product_Name Character 50 No No

Product_Description Memo

Retail_Price Currency No No

Price Currency No No

Vendor_Code Number No Yes

On_Hand Number No No

On_Order Number No No

Product_Type Text 1 No No

Field Name Type Field Size P/Key F/Key

P_O_Num Number 20 Yes No

Order_ID VarChar 15 No Yes

Field Name Type Field Size P/Key F/Key

Quote_ID Number 8 max Yes No

Customer_ID Number 8 No Yes

Employee_ID Number 8 No Yes

Quote_Date Date 8 No No