DELETE FROM t_tctb_formula WHERE FID = 1388990222582183458;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183458,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#11#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','11','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720868;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720868,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#11#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','11','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356772;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356772,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#11#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','11','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265695;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265695,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#11#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','11','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369415;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369415,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#11#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','11','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921671;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921671,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#11#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','11','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183459;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183459,{ts'2022-06-20  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#11#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','11','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356773;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356773,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#11#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','11','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921672;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921672,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#11#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','11','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265696;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265696,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#11#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','11','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369416;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369416,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#11#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','11','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720869;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720869,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#11#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','11','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'' ) and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183460;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183460,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#12#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','12','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720870;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720870,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#12#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','12','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265697;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265697,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#12#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','12','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921673;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921673,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#12#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','12','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369417;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369417,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#12#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','12','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356774;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356774,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#12#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','12','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720871;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720871,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#12#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','12','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356775;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356775,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#12#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','12','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183461;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183461,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#12#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','12','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265698;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265698,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#12#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','12','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369418;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369418,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#12#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','12','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921674;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921674,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#12#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-3%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','12','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.03'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate = ''3%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183446;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183446,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#1#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','1','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0 , {S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720856;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720856,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#1#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','1','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0 , {S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356759;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356759,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#1#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','1','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0 , {S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369403;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369403,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#1#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','1','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0 , {S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921659;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921659,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#1#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','1','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0 , {S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265683;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265683,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#1#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','1','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0 , {S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720857;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720857,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#1#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','1','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0 ,{S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},  {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356760;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356760,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#1#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','1','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0 ,{S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},  {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183447;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183447,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#1#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','1','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0 ,{S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},  {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369404;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369404,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#1#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','1','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0 ,{S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},  {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921660;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921660,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#1#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','1','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0 ,{S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},  {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265684;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265684,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#1#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','1','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0 ,{S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},  {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183456;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183456,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#22#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','22','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369413;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369413,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#22#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','22','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921669;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921669,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#22#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','22','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265693;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265693,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#22#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','22','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356770;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356770,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#22#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','22','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720866;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720866,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#22#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','22','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183457;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183457,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#22#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','22','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720867;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720867,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#22#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','22','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356771;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356771,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#22#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','22','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265694;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265694,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#22#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','22','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369414;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369414,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#22#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','22','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921670;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921670,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#22#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','22','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720860;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720860,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#23#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','23','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356763;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356763,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#23#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','23','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369407;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369407,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#23#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','23','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921663;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921663,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#23#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','23','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183450;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183450,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#23#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','23','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265687;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265687,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#23#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','23','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183451;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183451,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#23#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','23','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]}=0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265688;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265688,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#23#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','23','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]}=0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369408;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369408,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#23#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','23','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]}=0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921664;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921664,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#23#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','23','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]}=0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720861;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720861,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#23#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','23','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]}=0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356764;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356764,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#23#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','23','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]}=0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183448;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183448,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#2#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','2','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265685;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265685,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#2#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','2','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921661;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921661,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#2#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','2','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720858;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720858,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#2#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','2','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356761;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356761,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#2#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','2','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369405;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369405,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#2#kjskzzszyfpxse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','2','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720859;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720859,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#2#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','2','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356762;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356762,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#2#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','2','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183449;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183449,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#2#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','2','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265686;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265686,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#2#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','2','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369406;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369406,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#2#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','2','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921662;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921662,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#2#kjskzzszyfpxxynse',' ','一般纳税人附表一#13%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','2','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''3%'' or fgoodscode like ''4%''  or fgoodscode like ''5%'') and ftaxrate in (''0.13'', ''0.16'', ''0.17'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%'' )  and s.ftaxrate in (''13%'',''16%'',''17%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265689;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265689,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#4#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','4','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921665;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921665,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#4#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','4','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183452;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183452,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#4#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','4','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720862;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720862,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#4#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','4','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356765;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356765,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#4#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','4','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369409;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369409,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#4#kjskzzszyfpxse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销售额','1','4','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(famount) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%'' or  t.fmergecode like ''5%'')  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720863;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720863,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#4#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','4','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183453;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183453,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#4#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','4','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369410;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369410,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#4#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','4','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356766;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356766,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#4#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','4','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921666;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921666,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#4#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','4','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265690;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265690,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#4#kjskzzszyfpxxynse',' ','一般纳税人附表一#9%税率的服务、不动产和无形资产#开具税控增值税专用发票-销项应纳税额','1','4','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(ftax) from t_sim_vatinvoice_item where  (fgoodscode like ''3%'' or fgoodscode like ''4%'' or fgoodscode like ''5%'') and ftaxrate in (''0.09'', ''0.10'', ''0.11'') and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''3%'' or  t.fmergecode like ''4%''  or  t.fmergecode like ''5%''   )  and s.ftaxrate in (''9%'',''10%'',''11%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183474;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183474,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#5#kjskzzszyfpxse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销售额','1','5','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(i.famount) from t_sim_vatinvoice_item i ,  t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod''   and s.ftaxrate = ''6%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720545;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720545,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#5#kjskzzszyfpxse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销售额','1','5','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(i.famount) from t_sim_vatinvoice_item i ,  t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod''   and s.ftaxrate = ''6%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356786;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356786,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#5#kjskzzszyfpxse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销售额','1','5','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(i.famount) from t_sim_vatinvoice_item i ,  t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod''   and s.ftaxrate = ''6%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369431;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369431,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#5#kjskzzszyfpxse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销售额','1','5','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(i.famount) from t_sim_vatinvoice_item i ,  t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod''   and s.ftaxrate = ''6%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921687;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921687,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#5#kjskzzszyfpxse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销售额','1','5','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(i.famount) from t_sim_vatinvoice_item i ,  t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod''   and s.ftaxrate = ''6%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265376;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265376,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#5#kjskzzszyfpxse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销售额','1','5','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0,{S[select sum(i.famount) from t_sim_vatinvoice_item i ,  t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']}, {S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod''   and s.ftaxrate = ''6%'' ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183475;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183475,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#5#kjskzzszyfpxxynse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销项应纳税额','1','5','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(i.ftax) from t_sim_vatinvoice_item i , t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and   s.ftaxrate =''6%'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356787;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356787,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#5#kjskzzszyfpxxynse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销项应纳税额','1','5','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(i.ftax) from t_sim_vatinvoice_item i , t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and   s.ftaxrate =''6%'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369432;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369432,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#5#kjskzzszyfpxxynse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销项应纳税额','1','5','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(i.ftax) from t_sim_vatinvoice_item i , t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and   s.ftaxrate =''6%'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720546;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720546,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#5#kjskzzszyfpxxynse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销项应纳税额','1','5','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(i.ftax) from t_sim_vatinvoice_item i , t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and   s.ftaxrate =''6%'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265377;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265377,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#5#kjskzzszyfpxxynse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销项应纳税额','1','5','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(i.ftax) from t_sim_vatinvoice_item i , t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and   s.ftaxrate =''6%'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921688;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921688,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#5#kjskzzszyfpxxynse',' ','一般纳税人附表一#6%税率#开具税控增值税专用发票-销项应纳税额','1','5','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0,{S[select sum(i.ftax) from t_sim_vatinvoice_item i , t_sim_vatinvoice v where  i.fid = v.fid and i.ftaxrate = ''0.06'' and   v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'']},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and   s.ftaxrate =''6%'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183454;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183454,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#9#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','9','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720864;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720864,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#9#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','9','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356767;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356767,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#9#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','9','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265691;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265691,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#9#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','9','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369411;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369411,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#9#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','9','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921667;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921667,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#9#kjskzzszyfpxse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销售额','1','9','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxse',' ',' ','if({C[#income]} = 0, {S[select sum(famount) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialinvoiceamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1388990222582183455;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388990222582183455,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206','tcvat_ybnsr_fb1#9#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','9','1388990221600714752','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1389922187686720865;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1389922187686720865,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-A','tcvat_ybnsr_fb1#9#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','9','1389922186361365504','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1392817179346356769;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1392817179346356769,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-GD','tcvat_ybnsr_fb1#9#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','9','1392817178188729344','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1427515948046265692;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1427515948046265692,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-ZJ','tcvat_ybnsr_fb1#9#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','9','1427515946653870080','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421799681775921668;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421799681775921668,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-B','tcvat_ybnsr_fb1#9#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','9','1421799680660253696','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
DELETE FROM t_tctb_formula WHERE FID = 1421743500860369412;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1421743500860369412,{ts'2022-06-21  00:00:00'},' ',' ','VAT202206-BJ','tcvat_ybnsr_fb1#9#kjskzzszyfpxxynse',' ','一般纳税人附表一#简易计税-5%征收率的货物及加工修理修配劳务#开具税控增值税专用发票-销项应纳税额','1','9','1421743499946245120','zzsybnsr','tcvat_ybnsr_fb1','kjskzzszyfpxxynse',' ',' ','if({C[#income]} = 0, {S[select sum(ftax) from t_sim_vatinvoice_item where (fgoodscode like ''1%'' or fgoodscode like ''2%'') and ftaxrate = ''0.05'' and fid in (select v.fid from t_sim_vatinvoice v where  v.fbaseinvoicetype in (961639304377984000 ,961640097369875456) and v.fmaintaxorg = ''#orgid'' and v.finvoicestatus in (''0'',''3'') and v.fissuetime >= ''#startDate'' and v.fissuetime <= ''#endDate 23:59:59'')]},{S[select sum(s.fspecialtaxamount) from t_tcvat_income_summary s,t_tpo_taxitemrateentry t  where s.FBUSINESSTYPEID=t.FENTRYID and s.FORGID=''#orgid'' and s.FTAXPERIOD=''#taxperiod'' and  (t.fmergecode like ''1%'' or  t.fmergecode like ''2%'')  and s.ftaxrate in (''5%'') ]})'); 
