troubleshooting Question

Should I Merge Service and Usage Charges

Avatar of badabing1
badabing1 asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
5 Comments3 Solutions276 ViewsLast Modified:
Hi all,

I am building a billing OLTP database to hold our provider charges.  Currently I have set the database up so that the charges are split into two tables: Services table (for fixed charges) and Usage table (for call charges).

Because both of these tables share many columns such as; the asset it is allocated to, the division the charge is related to, the charge description, the date, the cost and the rerated cost, I am seriously considering merging the two into a charges table.  I feel this would help as summing the cost column would be the correct bill total rather than having to add the service cost to the usage cost.  The only problem I can see with this is that they do differ on some columns and the calls table is vastly larger than the services table.  Also calls can be treated slightly differently in analysis and reporting.  Nevertheless as long as these can be split out I cant see this being a problem.

Is merging these table the right thing to do at the OLTP level?
Thanks in advance for any help.
Contract ERP Admin/Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros