DELETE FROM t_tctb_formula WHERE FID = 1336294730773833970;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1336294730773833970,{ts'2022-05-07  00:00:00'},' ',' ','CTCIT2021','tccit_qysds_a100000#1#yysr','{Q[金额#1.营业收入]}+{Q[金额#1.营业收入]}+{Q[金额#2.财政补助收入]}+{Q[金额#3.事业收入]}+{Q[金额#4.上级补助收入]}+{Q[金额#5.附属单位上缴收入]}+{Q[金额#6.经营收入]}+{Q[金额#11.接受捐赠收入]}+{Q[金额#12.会费收入]}+{Q[金额#13.提供劳务收入]}+{Q[金额#14.商品销售收入]}+{Q[金额#15.政府补助收入]}','A100000年度纳税申报表#金额#1.营业收入','1','1','1336294713250031616','qysdsnb','tccit_qysds_a100000','yysr','1',' ','if({Q[tccit_qysds_a101010#1#yysr]}+{Q[tccit_qysds_a101020#1#yysr]}+{Q[tccit_qysds_a103000#1#czbzsr]}+{Q[tccit_qysds_a103000#1#sysr]}+{Q[tccit_qysds_a103000#1#sjbzsr]}+{Q[tccit_qysds_a103000#1#fsdwsjsr]}+{Q[tccit_qysds_a103000#1#jysr]}+{Q[tccit_qysds_a103000#1#jsjzsr]}+{Q[tccit_qysds_a103000#1#hfsr]}+{Q[tccit_qysds_a103000#1#tglwsr]}+{Q[tccit_qysds_a103000#1#spxssr]}+{Q[tccit_qysds_a103000#1#zfbzsr]}!=0,{Q[tccit_qysds_a101010#1#yysr]}+{Q[tccit_qysds_a101020#1#yysr]}+{Q[tccit_qysds_a103000#1#czbzsr]}+{Q[tccit_qysds_a103000#1#sysr]}+{Q[tccit_qysds_a103000#1#sjbzsr]}+{Q[tccit_qysds_a103000#1#fsdwsjsr]}+{Q[tccit_qysds_a103000#1#jysr]}+{Q[tccit_qysds_a103000#1#jsjzsr]}+{Q[tccit_qysds_a103000#1#hfsr]}+{Q[tccit_qysds_a103000#1#tglwsr]}+{Q[tccit_qysds_a103000#1#spxssr]}+{Q[tccit_qysds_a103000#1#zfbzsr]},{S[select famount from t_tccit_dg_a100000_1_sum where fitemtype =''001'' and forgid = ''#orgid'' and fskssqq =''#startDate'' and fskssqz =''#endDate'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1336294730773834092;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1336294730773834092,{ts'2022-05-07  00:00:00'},' ',' ','CTCIT2021','tccit_qysds_a100000#1#yylr','{Q[金额#1.营业收入]}-{Q[金额#2.营业成本]}-{Q[金额#3.营业税金及附加]}-{Q[金额#4.销售费用]}-{Q[金额#5.管理费用]}-{Q[金额#6.财务费用]}-{Q[金额#7.资产减值损失]}+{Q[金额#8.公允价值变动收益]}+{Q[金额#9.投资收益]}','A100000年度纳税申报表#金额#10.营业利润','1','1','1336294713250031616','qysdsnb','tccit_qysds_a100000','yylr','1',' ','if({Q[tccit_qysds_a100000#1#yysr]}-{Q[tccit_qysds_a100000#1#yycb]}-{Q[tccit_qysds_a100000#1#yysjfj]}-{Q[tccit_qysds_a100000#1#xsfy]}-{Q[tccit_qysds_a100000#1#glfy]}-{Q[tccit_qysds_a100000#1#cwfy]}-{Q[tccit_qysds_a100000#1#zcjzss]}+{Q[tccit_qysds_a100000#1#gyjzbdsy]}+{Q[tccit_qysds_a100000#1#tzsy]}!=0,{Q[tccit_qysds_a100000#1#yysr]}-{Q[tccit_qysds_a100000#1#yycb]}-{Q[tccit_qysds_a100000#1#yysjfj]}-{Q[tccit_qysds_a100000#1#xsfy]}-{Q[tccit_qysds_a100000#1#glfy]}-{Q[tccit_qysds_a100000#1#cwfy]}-{Q[tccit_qysds_a100000#1#zcjzss]}+{Q[tccit_qysds_a100000#1#gyjzbdsy]}+{Q[tccit_qysds_a100000#1#tzsy]},{S[select famount from t_tccit_dg_a100000_1_sum where fitemtype =''002'' and forgid = ''#orgid'' and fskssqq =''#startDate'' and fskssqz =''#endDate'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1336294730782223254;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1336294730782223254,{ts'2022-05-07  00:00:00'},' ',' ','CTCIT2021','tccit_qysds_a100000#1#xsfy','{Q[销售费用#26.合计]}','A100000年度纳税申报表#金额#4.销售费用','1','1','1336294713250031616','qysdsnb','tccit_qysds_a100000','xsfy','1',' ','if({Q[tccit_qysds_a104000#1#hj]}!=0,{Q[tccit_qysds_a104000#1#hj]},{S[select famount from t_tccit_dg_a100000_1_sum where fitemtype =''001_03'' and forgid = ''#orgid'' and fskssqq =''#startDate'' and fskssqz =''#endDate'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1336294730782223256;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1336294730782223256,{ts'2022-05-07  00:00:00'},' ',' ','CTCIT2021','tccit_qysds_a100000#1#cwfy','{Q[财务费用#26.合计]}','A100000年度纳税申报表#金额#6.财务费用','1','1','1336294713250031616','qysdsnb','tccit_qysds_a100000','cwfy','1',' ','if({Q[tccit_qysds_a104000#5#hj]}!=0,{Q[tccit_qysds_a104000#5#hj]},{S[select famount from t_tccit_dg_a100000_1_sum where fitemtype =''001_05'' and forgid = ''#orgid'' and fskssqq =''#startDate'' and fskssqz =''#endDate'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1336294730782223271;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1336294730782223271,{ts'2022-05-07  00:00:00'},' ',' ','CTCIT2021','tccit_qysds_a100000#1#yywsr','{Q[金额#16.营业外收入]}','A100000年度纳税申报表#金额#11.营业外收入','1','1','1336294713250031616','qysdsnb','tccit_qysds_a100000','yywsr','1',' ','{Q[tccit_qysds_a101010#1#yywsr]}+{Q[tccit_qysds_a101020#1#yywsr]}'); 
DELETE FROM t_tctb_formula WHERE FID = 1336294730782223273;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1336294730782223273,{ts'2022-05-07  00:00:00'},' ',' ','CTCIT2021','tccit_qysds_a100000#1#yycb','{Q[金额#1.营业成本]}','A100000年度纳税申报表#金额#2.营业成本','1','1','1336294713250031616','qysdsnb','tccit_qysds_a100000','yycb','1',' ','if({Q[tccit_qysds_a102010#1#yycb]}+{Q[tccit_qysds_a102020#1#yyzc]}+{Q[tccit_qysds_a103000#1#syzc]}+{Q[tccit_qysds_a103000#1#sjsjzc]}+{Q[tccit_qysds_a103000#1#dfsdwbz]}+{Q[tccit_qysds_a103000#1#jyzc]}+{Q[tccit_qysds_a103000#1#ywhdcb]}+{Q[tccit_qysds_a103000#1#glfy]}+{Q[tccit_qysds_a103000#1#zzfy]}!=0,{Q[tccit_qysds_a102010#1#yycb]}+{Q[tccit_qysds_a102020#1#yyzc]}+{Q[tccit_qysds_a103000#1#syzc]}+{Q[tccit_qysds_a103000#1#sjsjzc]}+{Q[tccit_qysds_a103000#1#dfsdwbz]}+{Q[tccit_qysds_a103000#1#jyzc]}+{Q[tccit_qysds_a103000#1#ywhdcb]}+{Q[tccit_qysds_a103000#1#glfy]}+{Q[tccit_qysds_a103000#1#zzfy]},{S[select famount from t_tccit_dg_a100000_1_sum where fitemtype =''001_01'' and forgid = ''#orgid'' and fskssqq =''#startDate'' and fskssqz =''#endDate'']})'); 
DELETE FROM t_tctb_formula WHERE FID = 1336294730799000126;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1336294730799000126,{ts'2022-05-07  00:00:00'},' ',' ','CTCIT2021','tccit_qysds_a100000#1#yywzc','{Q[金额#16.营业外支出]}','A100000年度纳税申报表#金额#12.营业外支出','1','1','1336294713250031616','qysdsnb','tccit_qysds_a100000','yywzc','1',' ','{Q[tccit_qysds_a102010#1#yywzc]}+{Q[tccit_qysds_a102020#1#yywzc]}'); 
DELETE FROM t_tctb_formula WHERE FID = 1415107075670873088;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1415107075670873088,{ts'2022-05-07  00:00:00'},' ',' ','CTCIT2021','tccit_qysds_a100000#1#glfy',' ','A100000年度纳税申报表#1#5.管理费用','1','1','1336294713250031616','qysdsnb','tccit_qysds_a100000','glfy',' ',' ','if({Q[tccit_qysds_a104000#3#hj]}!=0,{Q[tccit_qysds_a104000#3#hj]},{S[select famount from t_tccit_dg_a100000_1_sum where fitemtype =''001_04'' and forgid = ''#orgid'' and fskssqq =''#startDate'' and fskssqz =''#endDate'']})'); 
