Our Magento database was wiped a few weeks back (long story!) and I used the MySql logs to restore it. That worked for the most part but there was one order I had to restore manually. I thought I had done that successfully but we don't seem to be able to create a Credit Memo for the Order. Specifically, the subtotal column is not being populated correctly - it's showing zero for both item rows. These totals are populate correctly on the order and invoice.
My question is what database table is the subtotal sourced from?