<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Brian,<div><br></div><div><div>The logic of the rating first determines the destination then it searches for a price for it. So for every entry in destinations table you MUST have an entry in the rates table otherwise the price is zero. </div></div><div><br></div><div>The best practice is to maintain a central minium destination table common for all customers (add entries to it as it grows) and define custom rates for each of them. Also if you have lot of resellers you can create a main rating table and add only exceptions for the destinations particular to some of them.<div><br></div><div>Adrian</div><div><br></div><div><div><br><div><div>On Jan 20, 2009, at 3:56 PM, Brian Chamberlain wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi All,<br><br>I am sending calls to a number of different sip providers.<br>I have rates & destinations from all of them. Some of the providers <br>have broken up the amount of destinations into 30,000 different codes.<br>I am trying to build the rates and destinations tables so it is easy <br>to maintain in the future.<br><br>Would I be best having a minimal set of destinations to cover each <br>country and my local countries/areas and having the rates being more <br>specific.<br><br>I suppose my questions are the folowing.<br><br>If I have a destination:<br><br>1 USA<br><br>and a rate for 1 USA .02<br>and a rate for 1617 USA (Boston)<br><br>and the customer dials Boston then looking at the logic, even though I <br>don't have a boston Destination CDRTool will still rate the call using <br>the rate for 1617<br><br>If the reverse was through and I had a destination 1617 for boston but <br>only a rate for 1 USA would CDRTool use the 1 rate even though it <br>found the destination for 1617 in the destinations table?<br><br>Thanks,<br>Brian<br><br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br></div></blockquote></div><br></div></div></div></body></html>