Order Entry System

This is a possible structure for the tables/stores/files in a very basic Order Entry System. In fact, a more sophisticated system would be required for a real company.

Order Header	Order Line	Inventory	Vendor	Customer
(Open)	(Open)
Ord # - KEY	Ord # } - KEY Item #}	Item # - KEY	Vendor # - KEY	Cust # - KEY
Cust #	Ord # } - KEY Item #}	Item Name	Vendor Name	Name
Date Ord	Num ord	Cost	Address	Address
	Quoted price	Price	Phone	Phone
	Shipped	On Hand		Amt Owe
		Committed		Credit Limit
		On Order
		Reorder Pt
		Size
		Weight
		Vendor #

Some things to consider:

When an order has been filled it should probably move to a history file - on the history file the date would be part of the key - consider this when developing the order line file
Backorders are not handled here - if your company does back ordering they must be included
There is no invoice information - billing should have an invoice table or tables that contains invoicing information