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

[Matthias Hohl]

Now i have done following…

13 digits with 7 decimals: so this should be enough space for every billing 
situation…



ALTER TABLE accounting.cdr MODIFY source_carrier_cost decimal(13,7);

ALTER TABLE accounting.cdr MODIFY source_reseller_cost decimal(13,7);

ALTER TABLE accounting.cdr MODIFY source_customer_cost decimal(13,7);

ALTER TABLE accounting.cdr MODIFY destination _carrier_cost decimal(13,7);

ALTER TABLE accounting.cdr MODIFY destination _reseller_cost decimal(13,7);

ALTER TABLE accounting.cdr MODIFY destination _customer_cost decimal(13,7);



Anything else to do now..?





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



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 <mailto: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/3ae29af8/attachment-0001.html>