DELETE FROM t_tctb_formula WHERE FID = 1102879354490445824;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1102879354490445824,{ts'2023-09-28  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#31#ybxm',' ','增值税一般纳税人总览表#31#一般项目','1','31','1102685677520327680','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','{S[SELECT sum(fyjsjje) FROM t_tctb_declare_entry WHERE fid IN (SELECT fid FROM t_tcvat_prepay_declare WHERE fskssqq>=to_date(''#startDate'') AND fskssqz<=to_date(''#endDate'') AND forgid=''#orgid'' AND fpaystatus=''1'' AND  fdeductionperiod=''0'') AND ftaxtype=''1'']}+ {S[select sum(fcurrentamount) from t_tcvat_perpre_summary where forgid = ''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline = ''#deadline'']}'); 
DELETE FROM t_tctb_formula WHERE FID = 1611554578313296941;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1611554578313296941,{ts'2023-09-28  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#31#ybxm',' ','增值税一般纳税人总览表#31#一般项目','1','31','1611554577046620160','draft_zzsybnsr_sjjt','tcvat_zlb_ybnsr','ybxm',' ',' ','{S[SELECT sum(fyjsjje) FROM t_tctb_declare_entry WHERE fid IN (SELECT fid FROM t_tcvat_prepay_declare WHERE fskssqq>=to_date(''#startDate'') AND fskssqz<=to_date(''#endDate'') AND forgid=''#orgid'' AND fpaystatus=''1'' AND  fdeductionperiod=''0'') AND ftaxtype=''1'']}+ {S[select sum(fcurrentamount) from t_tcvat_perpre_sum_sjjt where forgid = ''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline = ''#deadline'']}'); 
