Need help with naming a couple of tables

  • I have this situation where an invoice comes in today with

    invoiceID

    invoiceDt

    lineCnt

    totalAmt

    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.

  • HUB_InvoiceHeader

    SAT_invoiceHeader

    Googlefor: Data Vault

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply