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: Wednesday, September 3, 2014 9:54 AM
Points: 80, Visits: 140
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 434, Visits: 665
HUB_InvoiceHeader
SAT_invoiceHeader

Googlefor: Data Vault

Post #1554162
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse