DELETE FROM t_tctb_formula WHERE FID = 1809380469842881536;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809380469842881536,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#50#ybxm',' ','增值税汇总一般企业税额计算总览表#50#一般项目','1','50','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','({Q[tcvat_zlb_zzsybnsr_ybhz#46#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#47#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#48#ybxm]})*{Q[tcvat_zlb_zzsybnsr_ybhz#49#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1809382197283759104;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809382197283759104,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#58#ybxm',' ','增值税汇总一般企业税额计算总览表#58#一般项目','1','58','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','({Q[tcvat_zlb_zzsybnsr_ybhz#54#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#55#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#56#ybxm]})*{Q[tcvat_zlb_zzsybnsr_ybhz#57#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1809563759728095232;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809563759728095232,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#50#ybxm',' ','增值税汇总一般企业税额计算总览表#50#一般项目','1','50','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','({Q[tcvat_zlb_zzsybnsr_ybhz#46#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#47#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#48#ybxm]})*{Q[tcvat_zlb_zzsybnsr_ybhz#49#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1808810740560612352;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808810740560612352,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#39#ybxm',' ','增值税一般纳税人总览表#39#一般项目','1','39','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','({Q[tcvat_zlb_ybnsr#35#ybxm]}+{Q[tcvat_zlb_ybnsr#36#ybxm]}-{Q[tcvat_zlb_ybnsr#37#ybxm]})*{Q[tcvat_zlb_ybnsr#38#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1808815972317193216;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808815972317193216,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#47#ybxm',' ','增值税一般纳税人总览表#47#一般项目','1','47','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','({Q[tcvat_zlb_ybnsr#43#ybxm]}+{Q[tcvat_zlb_ybnsr#44#ybxm]}-{Q[tcvat_zlb_ybnsr#45#ybxm]})*{Q[tcvat_zlb_ybnsr#46#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1808818027081681920;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808818027081681920,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#55#ybxm',' ','增值税一般纳税人总览表#55#一般项目','1','55','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','({Q[tcvat_zlb_ybnsr#51#ybxm]}+{Q[tcvat_zlb_ybnsr#52#ybxm]}-{Q[tcvat_zlb_ybnsr#53#ybxm]})*{Q[tcvat_zlb_ybnsr#54#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1809377722171108352;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809377722171108352,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#42#ybxm',' ','增值税汇总一般企业税额计算总览表#42#一般项目','1','42','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','({Q[tcvat_zlb_zzsybnsr_ybhz#38#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#39#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#40#ybxm]})*{Q[tcvat_zlb_zzsybnsr_ybhz#41#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1809562764881129472;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809562764881129472,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#42#ybxm',' ','增值税汇总一般企业税额计算总览表#42#一般项目','1','42','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','({Q[tcvat_zlb_zzsybnsr_ybhz#38#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#39#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#40#ybxm]})*{Q[tcvat_zlb_zzsybnsr_ybhz#41#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1809564628561391616;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809564628561391616,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#58#ybxm',' ','增值税汇总一般企业税额计算总览表#58#一般项目','1','58','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','({Q[tcvat_zlb_zzsybnsr_ybhz#54#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#55#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#56#ybxm]})*{Q[tcvat_zlb_zzsybnsr_ybhz#57#ybxm]}/100'); 
DELETE FROM t_tctb_formula WHERE FID = 1808731930074991616;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808731930074991616,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#35#ybxm',' ','增值税一般纳税人总览表#35#一般项目','1','35','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','if({C[#cswhjssenable]} = 1, {Q[tcvat_zlb_ybnsr#34#ybxm]}+{Q[tcvat_zlb_ybnsr#34#jzjtxm]}+min({S[select sum(t1.fqmye) from t_tcvat_ybnsr_jsxm t1 left join t_tctb_declare_main t2 on t1.fsbbid = CONCAT(t2.fid , '''') where t2.forgid=''#orgid'' and t2.fskssqq=to_date(''#prestartDate'') and t2.fskssqz=to_date(''#preendDate'') and t2.fnsrtype=''zzsybnsr'' and t1.fswsxdm in (789806480298652672,789806480307039232,789806484249687040,789806484258073600,789806484266464256,789806484274850816) and t1.fewblxh != ''1'']}+{S[select sum(fcurrentamount) from t_tcvat_taxreduce_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and ftaxreductionid in (789806480298652672,789806480307039232,789806484249687040,789806484258073600,789806484266464256,789806484274850816)]},{Q[tcvat_zlb_ybnsr#28#ybxm]}+{Q[tcvat_zlb_ybnsr#28#jzjtxm]}),0)');
DELETE FROM t_tctb_formula WHERE FID = 1809374033087802368;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809374033087802368,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#38#ybxm',' ','增值税汇总一般企业税额计算总览表#38#一般项目','1','38','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','if({C[#cswhjssenable]} = 1, {Q[tcvat_zlb_zzsybnsr_ybhz#31#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#31#jzjtxm]}+min({S[select sum(t1.fqmye) from t_tcvat_ybnsr_jsxm t1 left join t_tctb_declare_main t2 on t1.fsbbid = CONCAT(t2.fid , '''') where t2.forgid=''#orgid'' and t2.fskssqq=to_date(''#prestartDate'') and t2.fskssqz=to_date(''#preendDate'') and t2.fnsrtype=''#taxpayertype'' and t1.fswsxdm in (789806480298652672,789806480307039232,789806484249687040,789806484258073600,789806484266464256,789806484274850816) and t1.fewblxh != ''1'']}+{S[select sum(fcurrentamount) from t_tcvat_hz_taxreduce_sum where forgid=''#orgid'' and fstartdate=to_date(''#startDate'') AND fenddate=to_date(''#endDate'') and ftaxpayertype=''#taxpayertype'' and ftaxreductionid in (789806480298652672,789806480307039232,789806484249687040,789806484258073600,789806484266464256,789806484274850816)]},{Q[tcvat_zlb_zzsybnsr_ybhz#28#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#28#jzjtxm]}),0)');
DELETE FROM t_tctb_formula WHERE FID = 1809561062874509312;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809561062874509312,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#38#ybxm',' ','增值税汇总一般企业税额计算总览表#38#一般项目','1','38','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','if({C[#cswhjssenable]} = 1, {Q[tcvat_zlb_zzsybnsr_ybhz#31#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#31#jzjtxm]}+min({S[select sum(t1.fqmye) from t_tcvat_ybnsr_jsxm t1 left join t_tctb_declare_main t2 on t1.fsbbid = CONCAT(t2.fid , '''') where t2.forgid=''#orgid'' and t2.fskssqq=to_date(''#prestartDate'') and t2.fskssqz=to_date(''#preendDate'') and t2.fnsrtype=''#taxpayertype'' and t1.fswsxdm in (789806480298652672,789806480307039232,789806484249687040,789806484258073600,789806484266464256,789806484274850816) and t1.fewblxh != ''1'']}+{S[select sum(fcurrentamount) from t_tcvat_hz_jsxm_sum_sjjt where forgid=''#orgid'' and fstartdate=to_date(''#startDate'') AND fenddate=to_date(''#endDate'') and ftaxpayertype=''#taxpayertype'' and ftaxreductionid in (789806480298652672,789806480307039232,789806484249687040,789806484258073600,789806484266464256,789806484274850816)]},{Q[tcvat_zlb_zzsybnsr_ybhz#28#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#28#jzjtxm]}),0)');
DELETE FROM t_tctb_formula WHERE FID = 1616568741121108992;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1616568741121108992,{ts'2023-11-20  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#35#ybxm',' ','增值税一般纳税人总览表#35#一般项目','1','35','1611554577046620160','draft_zzsybnsr_sjjt','tcvat_zlb_ybnsr','ybxm',' ',' ','if({C[#cswhjssenable]} = 1, {Q[tcvat_zlb_ybnsr#34#ybxm]}+{Q[tcvat_zlb_ybnsr#34#jzjtxm]}+min({S[select sum(t1.fqmye) from t_tcvat_ybnsr_jsxm t1 left join t_tctb_declare_main t2 on t1.fsbbid = CONCAT(t2.fid , '''') where t2.forgid=''#orgid'' and t2.fskssqq=to_date(''#prestartDate'') and t2.fskssqz=to_date(''#preendDate'') and t2.fnsrtype=''zzsybnsr'' and t1.fswsxdm in (789806480298652672,789806480307039232,789806484249687040,789806484258073600,789806484266464256,789806484274850816) and t1.fewblxh != ''1'']}+{S[select sum(fcurrentamount) from t_tcvat_taxreduce_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and ftaxreductionid in (789806480298652672,789806480307039232,789806484249687040,789806484258073600,789806484266464256,789806484274850816)]},{Q[tcvat_zlb_ybnsr#28#ybxm]}+{Q[tcvat_zlb_ybnsr#28#jzjtxm]}),0)');
