title: Magento database: Invoice items database table?
body: <p>Does anyone know where the Invoice data is stored in Magento database?</p>
  
  <p>For example, I've found that the order data is stored in sales_order, sales_flat_order, sales_flat_order_item.</p>
  
  <p>I've also found out that the main invoice data is stored in sales_order_entity, sales_order_entity_decimal and sales_order_entity_int. Through that I can change the subtotal and totals of the invoice in the system.</p>
  
  <p>But! I don't know where to find the items data? For orders, that data is in sales_flat_order_item, but my sales_flat_invoice_item table is empty?!</p>
  
  <p><a href="http://img809.imageshack.us/img809/1921/invoicey.jpg" rel="nofollow">http://img809.imageshack.us/img809/1921/invoicey.jpg</a></p>