DELETE FROM t_tctb_formula WHERE FID = 1078798159276196157;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1078798159276196157,{ts'2022-06-08  00:00:00'},' ',' ','VAT-YB-201904','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1078760636948901888','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 = 1226870079983991102;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1226870079983991102,{ts'2022-06-08  00:00:00'},' ',' ','VAT-YB-202107','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1225368037159352320','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 = 1300563700658272605;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1300563700658272605,{ts'2022-06-08  00:00:00'},' ',' ','VAT-YB-202107-A','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1300563697839700992','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 = 1388273942480879003;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388273942480879003,{ts'2022-06-08  00:00:00'},' ',' ','VAT-YB-202107-GD','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1388273941751068672','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 = 1389856118104143198;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389856118104143198,{ts'2022-06-08  00:00:00'},' ',' ','VAT-YB-202206','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1389856116283859968','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 = 1393323893741079901;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1393323893741079901,{ts'2022-06-08  00:00:00'},' ',' ','VAT-YB-202206-A','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1393323890779899904','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 = 1393361442341670299;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1393361442341670299,{ts'2022-06-08  00:00:00'},' ',' ','VAT-YB-202206-GD','tcvat_ybnsr_fb1#4#wkjfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#未开具发票-销售额','1','4','1393361441116932096','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'']}'); 
