Payment control

[Ratib Hussaini]

hello everyone... I developed an inventory database and i want to add some more features on that. In my database i can control inventory very well but not the payments.
I have following tables.

Orders, order Details, Purchase Order, Purchase Order Details, Inventory Transactions, Product Details, Location Details, Suppliers, Shippers, Customers, Employees

Now I want to know also, that
1. for every order how much is paid and how much is left with different currencies.

2. The same thing for purchase orders payments
3. Shippers payments
4. Employees salaries

What kind of structure or design you prefer, your help will be highly appreciated.

 

[llkhoutx]

I would add a receipts (payment, returns, credits) table and an allocation table which allocates receipts among Orders, Purchase Orders, etc.

 

[Ratib Hussaini]

can you please give more details, and also we have customers that save their money with us.