What are the Tables for Invoice MySQL Database

What are the Tables for Invoice MySQL Database

Following tables in MySQL Database are normally can be used for generate invoices.

1. invoice table
2. client/customer table
3. order table
4. inventory table
5. payment table
6. etc

It depends on how you have designed/created your table structure. How ever these tables must contain the following fields which requires for invoicing.

1. line_id
2. order_id
3. user_id
4. total_cost
5. order_date
6. status
7. order_item_id
8. item_name
9. invoice_id
10. invoice_no
11. invoice_date
12. company_id
13. tax
14. discount
15. client_id

Further you need not to use all the above fields as well. (It is not required to be all the fields in one table.) Fields can be selected according to your invoice format & information you are going to mention in the invoice.