DELETE FROM t_tctb_formula WHERE FID = 1421802798185736541;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421802798185736541,{ts'2022-06-21  00:00:00'},' ',' ','VAT-YB-202206-BJ','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1421802796659026944','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'']}'); 
DELETE FROM t_tctb_formula WHERE FID = 1421817294715382109;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421817294715382109,{ts'2022-06-21  00:00:00'},' ',' ','VAT-YB-202206-B','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1421817293482273792','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'']}'); 
