DELETE FROM t_tctb_formula WHERE FID = 1103365408859332608;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1103365408859332608,{ts'2022-07-26  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#6#jzjtxm',' ','增值税一般纳税人总览表#6#即征即退项目','1','6','1102685677520327680','draft_zzsybnsr','tcvat_zlb_ybnsr','jzjtxm',' ',' ','{S[select sum(t1.ftotaltaxamount) from t_tcvat_income_summary t1 , t_tpo_taxitemrateentry t2  where t1.fbusinesstypeid=t2.fentryid  and  t1.forgid=''#orgid'' and t1.ftaxperiod=''#taxperiod'' and t1.fjzjt=''1'' and t1.FTAXMETHOD = ''一般计税'' and (t2.flongnumber like ''1%'' or t2.flongnumber like ''2%'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1120106605166407680;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1120106605166407680,{ts'2022-07-26  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#6#jzjtxm',' ','增值税汇总一般企业税额计算总览表#6#即征即退项目','1','6','1119375361449286656','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','jzjtxm',' ',' ','{S[select sum(t1.ftotaltaxamount) from t_tcvat_hz_account_summar t1 , t_tpo_taxitemrateentry t2  where t1.ftaxpayertype = ''#taxpayertype'' and t1.fbusinesstypeid=t2.fentryid  and  t1.forgid=''#orgid'' and t1.fstartdate >=''#startDate'' and t1.fenddate <= ''#endDate'' and t1.fjzjt=''1'' and t1.FTAXMETHOD = ''一般计税'' and (t2.flongnumber like ''1%'' or t2.flongnumber like ''2%'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1230462228940064768;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1230462228940064768,{ts'2022-07-26  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#7#jzjtxm',' ','增值税一般纳税人总览表#7#即征即退项目','1','7','1102685677520327680','draft_zzsybnsr','tcvat_zlb_ybnsr','jzjtxm',' ',' ','{S[select sum(t1.ftotaltaxamount) from t_tcvat_income_summary t1 , t_tpo_taxitemrateentry t2  where t1.fbusinesstypeid=t2.fentryid  and  t1.forgid=''#orgid'' and t1.ftaxperiod=''#taxperiod'' and t1.fjzjt=''1'' and t1.FTAXMETHOD = ''一般计税'' and (t2.flongnumber like ''3%''  or t2.flongnumber like ''4%'' or t2.flongnumber like ''5%'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1244875012872094720;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1244875012872094720,{ts'2022-07-26  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#7#jzjtxm',' ','增值税汇总一般企业税额计算总览表#7#即征即退项目','1','7','1119375361449286656','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','jzjtxm',' ',' ','{S[select sum(t1.ftotaltaxamount) from t_tcvat_hz_account_summar t1 , t_tpo_taxitemrateentry t2  where t1.ftaxpayertype = ''#taxpayertype'' and t1.fbusinesstypeid=t2.fentryid  and  t1.forgid=''#orgid'' and t1.fstartdate=''#startDate'' and t1.fenddate = ''#endDate'' and t1.fjzjt=''1'' and t1.FTAXMETHOD = ''一般计税'' and (t2.flongnumber like ''3%''  or t2.flongnumber like ''4%''  or t2.flongnumber like ''5%'')]}');
