DELETE FROM t_tctb_formula WHERE FID = 1427518256591300957;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427518256591300957,{ts'2022-06-16  00:00:00'},' ',' ','VAT-YB-202206-ZJ','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1427518255299341312','zzsybnsr_ybhz','tcvat_ybnsr_fb1','wkjfpxse',' ',' ','{S[SELECT sum(s.faccountingamount) as FTAXAMOUNT FROM t_tcvat_hz_account_summar s,t_tpo_taxitemrateentry t WHERE s.ftaxpayertype = ''#taxpayertype'' and s.FBUSINESSTYPEID = t.FENTRYID AND ( t.fmergecode LIKE ''3%'' OR t.fmergecode LIKE ''4%'' OR t.fmergecode LIKE ''5%'' )   AND s.FTAXRATE  in(''9%'')  and s.FORGID=''#orgid'' and s.fstartdate=''#startDate'' and s.fenddate=''#endDate'']}');
