Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need help with naming a couple of tables Expand / Collapse
Author
Message
Posted Wednesday, January 8, 2014 1:39 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:27 AM
Points: 80, Visits: 137
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.




Post #1529090
Posted Monday, March 24, 2014 11:26 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:48 AM
Points: 386, Visits: 623
HUB_InvoiceHeader
SAT_invoiceHeader

Googlefor: Data Vault

Post #1554162
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse