update vtiger_account
set accountname=<@SDESCRIPTION@>,
account_type = <@SREPORTINGGROUP1@>,
industry=<@SREPORTINGGROUP2@>,
tickersymbol=<@SACCOUNTCODE@>,
phone=<@STelephone1@>,
otherphone=<@STelephone2@>,
email1=<@SEMail@>,
fax=<@SFax@>
where accountid = <@CRMID@>