DELETE FROM t_tctb_formula WHERE FID = 1808077454846206984;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808077454846206984,{ts'2024-03-06  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#9#jzjtxm',' ','增值税一般纳税人总览表#9#即征即退项目','1','9','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','jzjtxm',' ',' ','{S[select sum(round(finputtaxamount,2)) from t_tcvat_deduction_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'']}');
DELETE FROM t_tctb_formula WHERE FID = 1102694340259648512;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1102694340259648512,{ts'2024-03-06  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#9#jzjtxm',' ','增值税一般纳税人总览表#9#即征即退项目','1','9','1102685677520327680','draft_zzsybnsr','tcvat_zlb_ybnsr','jzjtxm',' ',' ','{S[select sum(round(finputtaxamount,2)) from t_tcvat_deduction_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'']}');
DELETE FROM t_tctb_formula WHERE FID = 1611554578313296905;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1611554578313296905,{ts'2024-03-06  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#9#jzjtxm',' ','增值税一般纳税人总览表#9#即征即退项目','1','9','1611554577046620160','draft_zzsybnsr_sjjt','tcvat_zlb_ybnsr','jzjtxm',' ',' ','{S[select sum(round(finputtaxamount,2)) from t_tcvat_deduction_sum_jt  where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'']}');
DELETE FROM t_tctb_formula WHERE FID = 1120107439984132096;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1120107439984132096,{ts'2024-03-06  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#9#jzjtxm',' ','增值税汇总一般企业税额计算总览表#9#即征即退项目','1','9','1119375361449286656','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','jzjtxm',' ',' ','{S[select sum(round(finputtaxamount,2)) from t_tcvat_hz_deduction_sum  where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate=to_date(''#startDate'') and fenddate = to_date(''#endDate'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1626005309807968300;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1626005309807968300,{ts'2024-03-06  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#9#jzjtxm',' ','增值税汇总一般企业税额计算总览表#9#即征即退项目','1','9','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','jzjtxm',' ',' ','{S[select sum(round(finputtaxamount,2)) from t_tcvat_hz_deduct_sum_jt  where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate=to_date(''#startDate'') and fenddate = to_date(''#endDate'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1808078374355084303;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808078374355084303,{ts'2024-03-06  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#9#jzjtxm',' ','增值税汇总一般企业税额计算总览表#9#即征即退项目','1','9','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','jzjtxm',' ',' ','{S[select sum(round(finputtaxamount,2)) from t_tcvat_hz_deduction_sum  where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate=to_date(''#startDate'') and fenddate = to_date(''#endDate'')]}');
