asterisk2billing.org
http://forum.asterisk2billing.org/

calledrate dropped from cc_call table
http://forum.asterisk2billing.org/viewtopic.php?f=21&t=8516
Page 1 of 1

Author:  khy [ Tue Jan 18, 2011 10:24 pm ]
Post subject:  calledrate dropped from cc_call table

We are planning to move from A2Billing 1.3.3 to 1.7.1.
In the UPDATE-a2billing-v1.3.4-to-v1.4.0.sql script, the calledrate is dropped from the cc_call record.
ALTER TABLE cc_call DROP calledrate, DROP buyrate;
It looks like A2Billing now uses the rateinitial from the associated cc_ratecard to get the sell rate for the CDRs.

Currently we update the rateinitial value in the ratecard when our sell rates change. We also delete unused ratecards when they are no longer applicable.

When we move to 1.7.1 the old CDRs would then not show the rateinitial that was in effect at the time of the call if the rateinitial value
was updated or the associated ratecard was deleted.

We'd appreciate any recommendations on what we should be doing to ensure we show the sell rates that were in effect at the time of the call.

When we change sell rates, instead of modifying the existing ratecard should we create a new ratecard with the updated values so the rateinitial history is retained
in the old ratecard? Instead of deleting unused ratecards do we need to keep these ratecards for history?

Thanks for any suggestions!

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/