[Spce-user] Urgent: CDR files with too less cent decimals... not possible to rate short calls!!!

[Matthias Hohl]

It is enough to set this in mysql to have more decimals for carrier, 
customer and reseller costs for source and destination..?



ALTER TABLE accounting.cdr MODIFY carrier_cost decimal(10,6);

ALTER TABLE accounting.cdr MODIFY customer_cost decimal(10,6);

ALTER TABLE accounting.cdr MODIFY reseller_cost decimal(10,6);



To have 6 dicimals in the CDR..?

I use version: mr3.7.1





Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von 
Matthias Hohl
Gesendet: Mittwoch, 25. Februar 2015 15:23
An: spce-user at lists.sipwise.com
Betreff: [Spce-user] Urgent: CDR files with too less cent decimals... not 
possible to rate short calls!!!



Hello,



i found out that the CDR files can’t rate short calls with low billing fees, 
cause the cdr file at <source_customer_cost> or any other cost has too less 
decimal digits!

So a fee with 2 Cents per Minute with a 1/1 rating is not possible.



This should be:

0,02 € / 60 minutes = 0,000333333 €  this now multiplicated with 10 seconds 
= 0,00333 Cents but the CDR file shows only „0,00“



Thats is very terrible!!!



How can i increase the decimals to 5 digits or more..?



Thanks!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150225/d3d69ec5/attachment-0001.html>