DELETE FROM t_tctb_formula WHERE FID = 1611554578313296917;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1611554578313296917,{ts'2024-02-02  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#16#jzjtxm',' ','增值税一般纳税人总览表#16#即征即退项目','1','16','1611554577046620160','draft_zzsybnsr_sjjt','tcvat_zlb_ybnsr','jzjtxm',' ',' ','#if(''{C[#month]}'' == ''1'' &&  ''{S[select fdeductionrate from t_tcvat_policyconfirm where forgid = ''#orgid'' and freportperiod >=''#startDate''  and freportperiod <= ''#endDate'' and fdraftpurpose = ''sjjt'']}'' == ''N'')  0 #else  {S[select t1.fqmye from t_tcvat_ybnsr_jjdj t1 where t1.fewblxh=''2'' and t1.fsbbid=''#predeclaresbbid'']}  #end');
DELETE FROM t_tctb_formula WHERE FID = 1808077454846207000;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808077454846207000,{ts'2024-02-02  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#16#jzjtxm',' ','增值税一般纳税人总览表#16#即征即退项目','1','16','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','jzjtxm',' ',' ','#if(''{C[#month]}'' == ''1'' &&  ''{S[select fdeductionrate from t_tcvat_policyconfirm where forgid = ''#orgid'' and freportperiod >=''#startDate''  and freportperiod <= ''#endDate'' and fdraftpurpose = ''nssb'']}'' == ''N'')  0 #else  {S[select t1.fqmye from t_tcvat_ybnsr_jjdj t1 where t1.fewblxh=''2'' and t1.fsbbid=''#predeclaresbbid'']}  #end');
DELETE FROM t_tctb_formula WHERE FID = 1808077454846206999;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808077454846206999,{ts'2024-02-02  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#16#ybxm',' ','增值税一般纳税人总览表#16#一般项目','1','16','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','#if(''{C[#month]}'' == ''1'' &&  ''{S[select fdeductionrate from t_tcvat_policyconfirm where forgid = ''#orgid'' and freportperiod >=''#startDate''  and freportperiod <= ''#endDate'' and fdraftpurpose = ''nssb'']}'' == ''N'')  0 #else  {S[select t1.fqmye from t_tcvat_ybnsr_jjdj t1 where t1.fewblxh=''1'' and t1.fsbbid=''#predeclaresbbid'']}  #end');
DELETE FROM t_tctb_formula WHERE FID = 1611554578313296916;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1611554578313296916,{ts'2024-02-02  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#16#ybxm',' ','增值税一般纳税人总览表#16#一般项目','1','16','1611554577046620160','draft_zzsybnsr_sjjt','tcvat_zlb_ybnsr','ybxm',' ',' ','#if(''{C[#month]}'' == ''1'' &&  ''{S[select fdeductionrate from t_tcvat_policyconfirm where forgid = ''#orgid'' and freportperiod >=''#startDate''  and freportperiod <= ''#endDate'' and fdraftpurpose = ''sjjt'']}'' == ''N'')  0 #else  {S[select t1.fqmye from t_tcvat_ybnsr_jjdj t1 where t1.fewblxh=''1'' and t1.fsbbid=''#predeclaresbbid'']}  #end');
DELETE FROM t_tctb_formula WHERE FID = 1808078374355084306;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808078374355084306,{ts'2024-02-02  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#16#jzjtxm',' ','增值税汇总一般企业税额计算总览表#16#即征即退项目','1','16','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','jzjtxm',' ',' ','#if(''{C[#month]}'' == ''1'' &&  ''{S[select fdeductionrate from t_tcvat_ybhz_policy_conf where forgid = ''#orgid'' and fstartdate >=''#startDate''  and fenddate<= ''#endDate'' and fdraftpurpose = ''nssb'']}'' == ''N'')  0 #else  {S[SELECT fqmye from t_tcvat_ybnsr_jjdj t1  where t1.fewblxh=''2'' AND t1.fsbbid IN (select CONCAT(fid , '''') from t_tctb_declare_main where FNSRTYPE = ''#taxpayertype'' and FSKSSQQ  = to_date(''#prestartDate'') and FSKSSQZ  = to_date(''#preendDate'') and FTAXLIMIT = ''month'' and  FORGID = ''#orgid'') ]} #end');
DELETE FROM t_tctb_formula WHERE FID = 1626005309807968306;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1626005309807968306,{ts'2024-02-02  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#16#jzjtxm',' ','增值税汇总一般企业税额计算总览表#16#即征即退项目','1','16','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','jzjtxm',' ',' ','#if(''{C[#month]}'' == ''1'' &&  ''{S[select fdeductionrate from t_tcvat_ybhz_policy_conf where forgid = ''#orgid'' and fstartdate >=''#startDate''  and fenddate<= ''#endDate'' and fdraftpurpose = ''sjjt'']}'' == ''N'')  0 #else  {S[SELECT fqmye from t_tcvat_ybnsr_jjdj t1  where t1.fewblxh=''2'' AND t1.fsbbid IN (select CONCAT(fid , '''') from t_tctb_declare_main where FNSRTYPE = ''#taxpayertype'' and FSKSSQQ  = to_date(''#prestartDate'') and FSKSSQZ  = to_date(''#preendDate'') and FTAXLIMIT = ''month'' and  FORGID = ''#orgid'') ]} #end');
DELETE FROM t_tctb_formula WHERE FID = 1808078374355084297;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808078374355084297,{ts'2024-02-02  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#16#ybxm',' ','增值税汇总一般企业税额计算总览表#16#一般项目','1','16','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','#if(''{C[#month]}'' == ''1'' &&  ''{S[select fdeductionrate from t_tcvat_ybhz_policy_conf where forgid = ''#orgid'' and fstartdate >=''#startDate''  and fenddate<= ''#endDate'' and fdraftpurpose = ''nssb'']}'' == ''N'')  0 #else   {S[SELECT fqmye from t_tcvat_ybnsr_jjdj t1  where t1.fewblxh=''1'' AND t1.fsbbid IN (select CONCAT(fid , '''') from t_tctb_declare_main where FNSRTYPE = ''#taxpayertype'' and FSKSSQQ  = to_date(''#prestartDate'') and FSKSSQZ  = to_date(''#preendDate'') and FTAXLIMIT = ''month'' and  FORGID = ''#orgid'') ]} #end');
DELETE FROM t_tctb_formula WHERE FID = 1626005309807968279;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1626005309807968279,{ts'2024-02-02  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#16#ybxm',' ','增值税汇总一般企业税额计算总览表#16#一般项目','1','16','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','#if(''{C[#month]}'' == ''1'' &&  ''{S[select fdeductionrate from t_tcvat_ybhz_policy_conf where forgid = ''#orgid'' and fstartdate >=''#startDate''  and fenddate<= ''#endDate'' and fdraftpurpose = ''sjjt'']}'' == ''N'')  0 #else  {S[SELECT fqmye from t_tcvat_ybnsr_jjdj t1  where t1.fewblxh=''1'' AND t1.fsbbid IN (select CONCAT(fid , '''') from t_tctb_declare_main where FNSRTYPE = ''#taxpayertype'' and FSKSSQQ  = to_date(''#prestartDate'') and FSKSSQZ  = to_date(''#preendDate'') and FTAXLIMIT = ''month'' and  FORGID = ''#orgid'') ]} #end');
