Good point, I'll change it to 4 decimal digits. That should satisfy everyone. ----- Original Message ----- From: "Oleg Ustinov" <Oleg.Ustinov@xxxxxxxxxx> Sent: Thursday, June 10, 2004 2:37 PM > One important point for accounting, > Amount rounding. > In your account model you made round to 2 digits after comma, but it is not > enough for destinations with really small rates, i.e. 1 cent or less. > In this cause up to 25 seconds will be not accounted absolutely - but your > termination carrier will do it definitely. > They match round up to 4 digits. And final rounding to 2 digits does match > in final invoice only. > > In these opinion, I would like to offer to round session costs to 3 digits > and change trigger and 'cost' column in 'voipcalls' table as follow: > File 'c_voipcall_trig.sql' > Line60: ' costdiff NUMERIC(9,3);' > Line64: ' NEW.price::NUMERIC(9,3) * > (NEW.duration::NUMERIC(9,3) / 60::INT),' > Line65: ' 3' > > File 'c_voipcall.sql' > Line53: ' cost NUMERIC(9,3),' > > Best regards, > Oleg ------------------------------------------------------- This SF.Net email is sponsored by: GNOME Foundation Hackers Unite! GUADEC: The world's #1 Open Source Desktop Event. GNOME Users and Developers European Conference, 28-30th June in Norway http://2004/guadec.org _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
