'0.00' NOT NULL AFTER `charge` ;
ALTER TABLE `cdr_03` ADD = `tm_charge`=20 DOUBLE( 10, 2 ) DEFAULT '0.00' NOT NULL AFTER `charge` ;
ALTER TABLE = `cdr_04`=20 ADD `tm_charge` DOUBLE( 10, 2 ) DEFAULT '0.00' NOT NULL AFTER `charge`=20 ;
ALTER TABLE `cdr_05` ADD `tm_charge` DOUBLE( 10, 2 ) DEFAULT '0.00' = NOT=20 NULL AFTER `charge` ;
ALTER TABLE `cdr_06` ADD `tm_charge` DOUBLE( = 10, 2 )=20 DEFAULT '0.00' NOT NULL AFTER `charge` ;
ALTER TABLE `cdr_07` ADD = `tm_charge`=20 DOUBLE( 10, 2 ) DEFAULT '0.00' NOT NULL AFTER `charge` ;
ALTER TABLE = `cdr_08`=20 ADD `tm_charge` DOUBLE( 10, 2 ) DEFAULT '0.00' NOT NULL AFTER `charge`=20 ;
ALTER TABLE `cdr_09` ADD `tm_charge` DOUBLE( 10, 2 ) DEFAULT '0.00' = NOT=20 NULL AFTER `charge` ;
ALTER TABLE `cdr_10` ADD `tm_charge` DOUBLE( = 10, 2 )=20 DEFAULT '0.00' NOT NULL AFTER `charge` ;
ALTER TABLE `cdr_11` ADD = `tm_charge`=20 DOUBLE( 10, 2 ) DEFAULT '0.00' NOT NULL AFTER `charge` ;
ALTER TABLE = `cdr_12`=20 ADD `tm_charge` DOUBLE( 10, 2 ) DEFAULT '0.00' NOT NULL AFTER `charge` = ;

ALTER TABLE `company_ani` ADD `toll_free_rate` DOUBLE( 10, 2 ) = DEFAULT=20 '0.00' NOT NULL AFTER `SAani` ;

2) download exe update from this link and replace current exe = :

----- Original Message -----
From:=20 Taufik
To: izhar@eurekasys.com.my =

Sent: Monday, November 05, 2007 = 2:38=20 PM

Subject: BA system = enhancement

New enhancement for BA according to = meeting on=20 5/11/2007 9.30 am with Tham :

1) Import to excel function to CDR = details for=20 all account

2) Add column in summary - TM = Rates

-need to calculate TM rates for every = CDR

3) Import TM Rates - 1 rates for all=20 account

-format :

Prefix    |=20 Rates    | Blocking

--------------------------------------------

03    =    =20   | 0.20      | =20 20

4) Import toll free rate for all=20 account

-format :

ANI          &= nbsp; =20 | Toll Free Rates

---------------------------------

0132099018 | 0.04

0192455322 | 0.06

5) Function to = maintain/identify/update toll free=20 rates for all ani

6) Function for Database sync between = 2=20 computer

pls advice and email to=20 happytel

------=_NextPart_000_0027_01C82