DELETE FROM t_tctb_formula WHERE FID = 1808806235450297344;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808806235450297344,{ts'2024-07-04  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#37#ybxm',' ','增值税一般纳税人总览表#37#一般项目','1','37','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']} <= 0 || ({Q[tcvat_zlb_ybnsr#35#ybxm]}+{Q[tcvat_zlb_ybnsr#36#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']},{Q[tcvat_zlb_ybnsr#35#ybxm]}+{Q[tcvat_zlb_ybnsr#36#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}))'); 
DELETE FROM t_tctb_formula WHERE FID = 1616568890102787072;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1616568890102787072,{ts'2024-07-04  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#37#ybxm',' ','增值税一般纳税人总览表#37#一般项目','1','37','1611554577046620160','draft_zzsybnsr_sjjt','tcvat_zlb_ybnsr','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_sum_sjjt where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_ybnsr#35#ybxm]}+{Q[tcvat_zlb_ybnsr#36#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_sum_sjjt where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']}, {Q[tcvat_zlb_ybnsr#35#ybxm]}+{Q[tcvat_zlb_ybnsr#36#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}))'); 
DELETE FROM t_tctb_formula WHERE FID = 1808815215656363008;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808815215656363008,{ts'2024-07-04  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#45#ybxm',' ','增值税一般纳税人总览表#45#一般项目','1','45','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']} <= 0 || ({Q[tcvat_zlb_ybnsr#43#ybxm]}+{Q[tcvat_zlb_ybnsr#44#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']},{Q[tcvat_zlb_ybnsr#43#ybxm]}+{Q[tcvat_zlb_ybnsr#44#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}))');
DELETE FROM t_tctb_formula WHERE FID = 1616569462801443840;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1616569462801443840,{ts'2024-07-04  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#45#ybxm',' ','增值税一般纳税人总览表#45#一般项目','1','45','1611554577046620160','draft_zzsybnsr_sjjt','tcvat_zlb_ybnsr','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_sum_sjjt where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_ybnsr#43#ybxm]}+{Q[tcvat_zlb_ybnsr#44#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_sum_sjjt where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']}, {Q[tcvat_zlb_ybnsr#43#ybxm]}+{Q[tcvat_zlb_ybnsr#44#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}))');
DELETE FROM t_tctb_formula WHERE FID = 1808817552923878400;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1808817552923878400,{ts'2024-07-04  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_02','tcvat_zlb_ybnsr#53#ybxm',' ','增值税一般纳税人总览表#53#一般项目','1','53','1808077452505784320','draft_zzsybnsr','tcvat_zlb_ybnsr','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']} <= 0 || ({Q[tcvat_zlb_ybnsr#51#ybxm]}+{Q[tcvat_zlb_ybnsr#52#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_summary where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']},{Q[tcvat_zlb_ybnsr#51#ybxm]}+{Q[tcvat_zlb_ybnsr#52#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}))');
DELETE FROM t_tctb_formula WHERE FID = 1616570132774400000;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1616570132774400000,{ts'2024-07-04  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_01','tcvat_zlb_ybnsr#53#ybxm',' ','增值税一般纳税人总览表#53#一般项目','1','53','1611554577046620160','draft_zzsybnsr_sjjt','tcvat_zlb_ybnsr','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_sum_sjjt where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_ybnsr#51#ybxm]}+{Q[tcvat_zlb_ybnsr#52#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_roll_out_sum_sjjt where forgid=''#orgid'' and ftaxperiod in (''#startPeriod'',''#middlePeriod'',''#endPeriod'') and fdeadline=''#deadline'' and frollouttype = ''11'']}, {Q[tcvat_zlb_ybnsr#51#ybxm]}+{Q[tcvat_zlb_ybnsr#52#ybxm]}-{Q[tcvat_zlb_ybnsr#27#ybxm]}-{Q[tcvat_zlb_ybnsr#27#jzjtxm]}))'); 


DELETE FROM t_tctb_formula WHERE FID = 1809376443982128128;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809376443982128128,{ts'2024-07-05  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#40#ybxm',' ','增值税汇总一般企业税额计算总览表#40#一般项目','1','40','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_roll_out_sum where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_zzsybnsr_ybhz#38#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#39#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_roll_out_sum where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']}, {Q[tcvat_zlb_zzsybnsr_ybhz#38#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#39#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}))'); 
DELETE FROM t_tctb_formula WHERE FID = 1809562462597640192;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809562462597640192,{ts'2024-07-05  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#40#ybxm',' ','增值税汇总一般企业税额计算总览表#40#一般项目','1','40','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_rollout_sum_jt where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_zzsybnsr_ybhz#38#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#39#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_rollout_sum_jt where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']}, {Q[tcvat_zlb_zzsybnsr_ybhz#38#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#39#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}))'); 
DELETE FROM t_tctb_formula WHERE FID = 1809379730445804544;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809379730445804544,{ts'2024-07-05  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#48#ybxm',' ','增值税汇总一般企业税额计算总览表#48#一般项目','1','48','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_roll_out_sum where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_zzsybnsr_ybhz#46#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#47#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_roll_out_sum where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']}, {Q[tcvat_zlb_zzsybnsr_ybhz#46#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#47#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}))'); 
DELETE FROM t_tctb_formula WHERE FID = 1809563480051904512;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809563480051904512,{ts'2024-07-05  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#48#ybxm',' ','增值税汇总一般企业税额计算总览表#48#一般项目','1','48','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_rollout_sum_jt where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_zzsybnsr_ybhz#46#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#47#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_rollout_sum_jt where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']}, {Q[tcvat_zlb_zzsybnsr_ybhz#46#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#47#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}))'); 
DELETE FROM t_tctb_formula WHERE FID = 1809381683741568000;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809381683741568000,{ts'2024-07-05  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_02','tcvat_zlb_zzsybnsr_ybhz#56#ybxm',' ','增值税汇总一般企业税额计算总览表#56#一般项目','1','56','1808078373642051584','draft_zzsybnsr_ybhz','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_roll_out_sum where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_zzsybnsr_ybhz#54#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#55#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_roll_out_sum where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']}, {Q[tcvat_zlb_zzsybnsr_ybhz#54#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#55#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}))'); 
DELETE FROM t_tctb_formula WHERE FID = 1809564362298585088;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1809564362298585088,{ts'2024-07-05  00:00:00'},' ',' ','VAT_DRAFT_YBNSR_YBHZ_01','tcvat_zlb_zzsybnsr_ybhz#56#ybxm',' ','增值税汇总一般企业税额计算总览表#56#一般项目','1','56','1626005309052994560','draft_zzsybnsr_ybhz_sjjt','tcvat_zlb_zzsybnsr_ybhz','ybxm',' ',' ','if({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_rollout_sum_jt where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']} <= 0 ||  ({Q[tcvat_zlb_zzsybnsr_ybhz#54#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#55#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}) <= 0 ,0, min({S[select sum(fjzxqkyykcdldtse) from t_tcvat_sb_fjsf_jz  where fsbbid = ''#perDeclareSbbidByCurrentDateSubtractOneMonth'' and fewblxh =''1'']} + {S[select sum(faccountingamount) from t_tcvat_hz_rollout_sum_jt where ftaxpayertype = ''#taxpayertype'' and forgid=''#orgid'' and fstartdate= to_date(''#startDate'') and fenddate = to_date(''#endDate'') and frollouttype = ''11'']}, {Q[tcvat_zlb_zzsybnsr_ybhz#54#ybxm]}+{Q[tcvat_zlb_zzsybnsr_ybhz#55#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#ybxm]}-{Q[tcvat_zlb_zzsybnsr_ybhz#27#jzjtxm]}))'); 
