What are the Tables for Invoice MySQL Database

Asked By James Mayer 0 points N/A Posted on - 12/08/2012

I need to create mysql tables for small application that stores and generates invoices. What tables do I need for invoice mysql database?

• Status: Open
• Question Views: 1080
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Vogt Joan 0 points N/A #135438

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.

About Vogt Joan

Questions
9

Answers
35

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 12/12/2012
• Question Category: MySQL Server