What are the Tables for Invoice MySQL Database

Asked By 0 points N/A Posted on -

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

Answered By 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.

Login/Register to Answer

Related Questions