I have this situation where an invoice comes in today with
inv123 01/08/2014 10 $100.
If there is a resubmission of say one line (out of the original 10 lines) tomorrow, the record will come in as
inv123 01/08/2014 1 $20. (note: the invoiceID and invoiceDt remain the same).
So I plan to split this into two tables. The first one will have the ID and Dt. The second one will have the processedDt, lineCnt and totalAmt with a one to many between the first and second tables.
What will be an ideal naming for these two tables. I did not want to call them, invoiceHeader and invoiceDetail as the second one is not actually a detail of the first.
Any suggestions are greatly appreciated.