DELETE FROM t_tctb_formula WHERE FID = 1386788771537664000;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664000,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#4#sfsyybjsff',' ',' ','1','4','1386788769012694016','zzsyjskb','tcvat_prepay','sfsyybjsff',' ',' ','#if(''{S[SELECT a.flevytype FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'']}'' == ''normal'') 1 #else 0 #end');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664001;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664001,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#4#sfsyybjsff','[{"val":"1","text":"是"},{"val":"0","text":"否"}]',' ','3','4','1386788769012694016','zzsyjskb','tcvat_prepay','sfsyybjsff','4',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664002;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664002,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#4#projectaddress',' ',' ','4','4','1386788769012694016','zzsyjskb','tcvat_prepay','projectaddress',' ',' ','{S[SELECT faddress FROM t_tcvat_prepay_project where fid = ''#projectid'']}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664003;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664003,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#4#projectnum',' ',' ','4','4','1386788769012694016','zzsyjskb','tcvat_prepay','projectnum',' ',' ','#if(''{S[SELECT a.fprepaytype FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fdeclareserialno = ''#declareserialno'' ]}'' != ''VAT_YJXMLX_004'' && ''{S[SELECT a.fprepaytype  FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fdeclareserialno = ''#declareserialno'']}'' != ''VAT_YJXMLX_005'') {S[SELECT flicensecode FROM t_tcvat_project_account where fprojectid = ''#projectid'' and fstartdate= ''#startDate'' AND fenddate = ''#endDate'' and fdeclareserialno = ''#declareserialno'']} #else #end');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664004;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664004,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#4#projectname',' ',' ','4','4','1386788769012694016','zzsyjskb','tcvat_prepay','projectname',' ',' ','#if(''{S[SELECT a.fprepaytype FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fdeclareserialno = ''#declareserialno'']}'' != ''VAT_YJXMLX_004'' && ''{S[SELECT a.fprepaytype  FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fdeclareserialno = ''#declareserialno'']}'' != ''VAT_YJXMLX_005'')  {S[SELECT fname FROM t_tcvat_project_account where fprojectid = ''#projectid'' and fstartdate= ''#startDate'' AND fenddate = ''#endDate'' and fdeclareserialno = ''#declareserialno'']} #else #end');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664005;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664005,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#1#sale',' ',' ','1','1','1386788769012694016','zzsyjskb','tcvat_prepay','sale',' ',' ','{S[SELECT fsalesamount FROM T_TCVAT_PROJECT_ACCOUNT WHERE forgid = ''#orgid'' AND fprojectid= ''#projectid'' AND fprepaytype IN (''VAT_YJXMLX_001'',''VAT_YJXMLX_002'') AND fstartdate= ''#startDate'' AND fenddate = ''#endDate'' and fdeclareserialno = ''#declareserialno'' ]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664006;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664006,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#2#sale',' ',' ','1','2','1386788769012694016','zzsyjskb','tcvat_prepay','sale',' ',' ','{S[SELECT fsalesamount FROM T_TCVAT_PROJECT_ACCOUNT WHERE forgid = ''#orgid'' AND fprojectid= ''#projectid'' AND fprepaytype IN (''VAT_YJXMLX_003'',''VAT_YJXMLX_004'') AND fstartdate= ''#startDate'' AND fenddate = ''#endDate'' and fdeclareserialno = ''#declareserialno'' ]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664007;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664007,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#3#sale',' ',' ','1','3','1386788769012694016','zzsyjskb','tcvat_prepay','sale',' ',' ','{S[SELECT fsalesamount FROM T_TCVAT_PROJECT_ACCOUNT WHERE forgid = ''#orgid'' AND fprojectid= ''#projectid'' AND fprepaytype=''VAT_YJXMLX_005'' AND fstartdate= ''#startDate'' AND fenddate = ''#endDate'' and fdeclareserialno = ''#declareserialno'' ]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664008;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664008,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#5#sale',' ',' ','1','5','1386788769012694016','zzsyjskb','tcvat_prepay','sale',' ',' ','{Q[tcvat_prepay#1#sale]}+{Q[tcvat_prepay#2#sale]}+{Q[tcvat_prepay#3#sale]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664009;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664009,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#1#crossclaim',' ',' ','1','1','1386788769012694016','zzsyjskb','tcvat_prepay','crossclaim',' ',' ','{S[SELECT fdeductionamount FROM T_TCVAT_PROJECT_ACCOUNT WHERE forgid = ''#orgid'' AND fprojectid= ''#projectid'' AND fprepaytype IN (''VAT_YJXMLX_001'',''VAT_YJXMLX_002'') AND fstartdate= ''#startDate'' AND fenddate = ''#endDate'' and fdeclareserialno = ''#declareserialno'' ]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664010;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664010,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#2#crossclaim',' ',' ','1','2','1386788769012694016','zzsyjskb','tcvat_prepay','crossclaim',' ',' ','{S[SELECT fdeductionamount  FROM T_TCVAT_PROJECT_ACCOUNT WHERE forgid = ''#orgid'' AND fprojectid= ''#projectid'' AND fprepaytype IN (''VAT_YJXMLX_003'',''VAT_YJXMLX_004'') AND fstartdate= ''#startDate'' AND fenddate = ''#endDate'' and fdeclareserialno = ''#declareserialno'' ]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664011;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664011,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#3#crossclaim',' ',' ','1','3','1386788769012694016','zzsyjskb','tcvat_prepay','crossclaim',' ',' ','0');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664012;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664012,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#5#crossclaim',' ',' ','1','5','1386788769012694016','zzsyjskb','tcvat_prepay','crossclaim',' ',' ','{Q[tcvat_prepay#1#crossclaim]}+{Q[tcvat_prepay#2#crossclaim]}+{Q[tcvat_prepay#3#crossclaim]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664013;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664013,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#1#advancescale',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay','advancescale',' ',' ','{S[SELECT e.fprepayrate FROM  t_tcvat_account_entry e  WHERE  e.ftaxtype = ''增值税'' and e.fid = (select fid from T_TCVAT_PROJECT_ACCOUNT a where a.forgid = ''#orgid'' AND a.fprojectid= ''#projectid'' and a.fprepaytype IN (''VAT_YJXMLX_001'',''VAT_YJXMLX_002'') and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664014;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664014,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#2#advancescale',' ',' ','4','2','1386788769012694016','zzsyjskb','tcvat_prepay','advancescale',' ',' ','{S[SELECT e.fprepayrate FROM  t_tcvat_account_entry e  WHERE  e.ftaxtype = ''增值税'' and e.fid = (select fid from T_TCVAT_PROJECT_ACCOUNT a where a.forgid = ''#orgid'' AND a.fprojectid= ''#projectid'' and a.fprepaytype IN (''VAT_YJXMLX_003'',''VAT_YJXMLX_004'') and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664015;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664015,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#3#advancescale',' ',' ','4','3','1386788769012694016','zzsyjskb','tcvat_prepay','advancescale',' ',' ','{S[SELECT e.fprepayrate FROM  t_tcvat_account_entry e  WHERE  e.ftaxtype = ''增值税'' and e.fid = (select fid from T_TCVAT_PROJECT_ACCOUNT a where a.forgid = ''#orgid'' AND a.fprojectid= ''#projectid'' and a.fprepaytype = ''VAT_YJXMLX_005'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664016;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664016,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#1#advanceamount',' ',' ','1','1','1386788769012694016','zzsyjskb','tcvat_prepay','advanceamount',' ',' ','#if(''{S[SELECT a.flevytype FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'']}'' == ''normal'')  ({Q[tcvat_prepay#1#sale]}-{Q[tcvat_prepay#1#crossclaim]})/1.09*{Q[tcvat_prepay#1#advancescale]}/100  #else  #if(''{C[#type]}'' == ''0'') ({Q[tcvat_prepay#1#sale]}-{Q[tcvat_prepay#1#crossclaim]})/1.03*{Q[tcvat_prepay#1#advancescale]}/100 #else  ({Q[tcvat_prepay#1#sale]}-{Q[tcvat_prepay#1#crossclaim]})/1.01*{Q[tcvat_prepay#1#advancescale]}/100   #end  #end');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664017;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664017,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#2#advanceamount',' ',' ','1','2','1386788769012694016','zzsyjskb','tcvat_prepay','advanceamount',' ',' ','#if(''{S[SELECT a.fprepaytype FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'']}'' == ''VAT_YJXMLX_003'')  #if(''{S[SELECT a.flevytype FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'']}'' == ''normal'')  {Q[tcvat_prepay#2#sale]}/1.09*{Q[tcvat_prepay#2#advancescale]}/100 #else  {Q[tcvat_prepay#2#sale]}/1.05*{Q[tcvat_prepay#2#advancescale]}/100  #end  #else #if(''{S[SELECT a.fprepaytype FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'']}'' == ''VAT_YJXMLX_004'')   ({Q[tcvat_prepay#2#sale]}-{Q[tcvat_prepay#2#crossclaim]})/1.05*{Q[tcvat_prepay#2#advancescale]} /100#else 0 #end  #end');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664018;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664018,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#3#advanceamount',' ',' ','1','3','1386788769012694016','zzsyjskb','tcvat_prepay','advanceamount',' ',' ','#if(''{S[SELECT a.flevytype FROM T_TCVAT_PROJECT_ACCOUNT a WHERE a.fprojectid= ''#projectid'' AND a.forgid = ''#orgid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'']}'' == ''normal'')  {Q[tcvat_prepay#3#sale]} / 1.09 * {Q[tcvat_prepay#3#advancescale]}/100  #else  {Q[tcvat_prepay#3#sale]} / 1.05 * {Q[tcvat_prepay#3#advancescale]}/100  #end');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664019;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664019,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay#5#advanceamount',' ',' ','1','5','1386788769012694016','zzsyjskb','tcvat_prepay','advanceamount',' ',' ','{Q[tcvat_prepay#1#advanceamount]}+{Q[tcvat_prepay#2#advanceamount]}+{Q[tcvat_prepay#3#advanceamount]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664020;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664020,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#1#yjse',' ',' ','1','1','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','yjse',' ',' ','{Q[tcvat_prepay#5#advanceamount]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664021;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664021,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#2#yjse',' ',' ','1','2','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','yjse',' ',' ','{Q[tcvat_prepay#5#advanceamount]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664022;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664022,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#3#yjse',' ',' ','1','3','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','yjse',' ',' ','{Q[tcvat_prepay#5#advanceamount]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664023;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664023,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#1#sl',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','sl',' ',' ','{S[SELECT e.fprepayrate FROM  t_tcvat_account_entry e  WHERE  e.ftaxtype = ''城市建设维护税'' and e.fid = (select fid from T_TCVAT_PROJECT_ACCOUNT a where a.forgid = ''#orgid'' AND a.fprojectid= ''#projectid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664024;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664024,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#2#sl',' ',' ','4','2','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','sl',' ',' ','{S[SELECT e.fprepayrate FROM  t_tcvat_account_entry e  WHERE  e.ftaxtype = ''教育附加税'' and e.fid = (select fid from T_TCVAT_PROJECT_ACCOUNT a where a.forgid = ''#orgid'' AND a.fprojectid= ''#projectid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664025;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664025,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#3#sl',' ',' ','4','3','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','sl',' ',' ','{S[SELECT e.fprepayrate FROM  t_tcvat_account_entry e  WHERE  e.ftaxtype = ''地方教育附加税'' and e.fid = (select fid from T_TCVAT_PROJECT_ACCOUNT a where a.forgid = ''#orgid'' AND a.fprojectid= ''#projectid'' and a.fstartdate= ''#startDate'' AND a.fenddate = ''#endDate'' and a.fdeclareserialno = ''#declareserialno'')]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664026;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664026,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#4#bqynse',' ',' ','1','4','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqynse',' ',' ','{Q[tcvat_prepay_flzl#1#bqynse]} + {Q[tcvat_prepay_flzl#2#bqynse]} + {Q[tcvat_prepay_flzl#3#bqynse]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664027;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664027,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#1#jmxzdm','[{"val":"tpo_taxdeduction","text":"{number}|{name}"}]',' ','3','1','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jmxzdm','5',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664028;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664028,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#2#jmxzdm','[{"val":"tpo_taxdeduction","text":"{number}|{name}"}]',' ','3','2','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jmxzdm','5',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664029;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664029,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#3#jmxzdm','[{"val":"tpo_taxdeduction","text":"{number}|{name}"}]',' ','3','3','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jmxzdm','5',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664030;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664030,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#1#bqynse',' ',' ','1','1','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqynse',' ',' ','{Q[tcvat_prepay_flzl#1#yjse]} * {Q[tcvat_prepay_flzl#1#sl]} / 100');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664031;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664031,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#2#bqynse',' ',' ','1','2','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqynse',' ',' ','{Q[tcvat_prepay_flzl#2#yjse]} * {Q[tcvat_prepay_flzl#2#sl]} / 100');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664032;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664032,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#4#jmsfe',' ',' ','1','4','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jmsfe',' ',' ','{Q[tcvat_prepay_flzl#1#jmsfe]} + {Q[tcvat_prepay_flzl#2#jmsfe]} + {Q[tcvat_prepay_flzl#3#jmsfe]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664033;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664033,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#3#bqynse',' ',' ','1','3','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqynse',' ',' ','{Q[tcvat_prepay_flzl#3#yjse]} * {Q[tcvat_prepay_flzl#3#sl]} / 100');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664034;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664034,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#1#xgmnsrjze',' ',' ','1','1','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','xgmnsrjze',' ',' ','({Q[tcvat_prepay_flzl#1#bqynse]} - {Q[tcvat_prepay_flzl#1#jmsfe]} )  * {Q[tcvat_prepay_flzl#1#jzbl]} / 100');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664035;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664035,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#2#xgmnsrjze',' ',' ','1','2','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','xgmnsrjze',' ',' ','({Q[tcvat_prepay_flzl#2#bqynse]} - {Q[tcvat_prepay_flzl#2#jmsfe]} )  * {Q[tcvat_prepay_flzl#2#jzbl]} / 100');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664036;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664036,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#3#xgmnsrjze',' ',' ','1','3','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','xgmnsrjze',' ',' ','({Q[tcvat_prepay_flzl#3#bqynse]} - {Q[tcvat_prepay_flzl#3#jmsfe]} )  * {Q[tcvat_prepay_flzl#3#jzbl]} / 100');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664037;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664037,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#4#xgmnsrjze',' ',' ','1','4','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','xgmnsrjze',' ',' ','{Q[tcvat_prepay_flzl#1#xgmnsrjze]} + {Q[tcvat_prepay_flzl#2#xgmnsrjze]} + {Q[tcvat_prepay_flzl#3#xgmnsrjze]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664038;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664038,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#1#bqsjyjsfe',' ',' ','1','1','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqsjyjsfe',' ',' ','{Q[tcvat_prepay_flzl#1#bqynse]} - {Q[tcvat_prepay_flzl#1#jmsfe]} - {Q[tcvat_prepay_flzl#1#xgmnsrjze]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664039;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664039,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#2#bqsjyjsfe',' ',' ','1','2','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqsjyjsfe',' ',' ','{Q[tcvat_prepay_flzl#2#bqynse]} - {Q[tcvat_prepay_flzl#2#jmsfe]} - {Q[tcvat_prepay_flzl#2#xgmnsrjze]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664040;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664040,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#3#bqsjyjsfe',' ',' ','1','3','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqsjyjsfe',' ',' ','{Q[tcvat_prepay_flzl#3#bqynse]} - {Q[tcvat_prepay_flzl#3#jmsfe]} - {Q[tcvat_prepay_flzl#3#xgmnsrjze]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664041;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664041,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#4#bqsjyjsfe',' ',' ','1','4','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqsjyjsfe',' ',' ','{Q[tcvat_prepay_flzl#1#bqsjyjsfe]} + {Q[tcvat_prepay_flzl#2#bqsjyjsfe]} + {Q[tcvat_prepay_flzl#3#bqsjyjsfe]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664043;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664043,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#1#jmsfe',' ',' ','3','1','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jmsfe','1',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664044;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664044,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#2#jmsfe',' ',' ','3','2','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jmsfe','1',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664045;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664045,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#3#jmsfe',' ',' ','3','3','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jmsfe','1',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664049;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664049,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#org',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bil','org','4',' ','{C[#taxorg]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664050;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664050,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#accountorg',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bil','accountorg','4',' ','{C[#orgid]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664051;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664051,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#declareserialno',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bil','declareserialno','4',' ','{C[#declareserialno]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664052;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664052,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#skssqq',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bil','skssqq','4',' ','{Q[tcvat_nsrxx#1#skssqq]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664053;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664053,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#skssqz',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bil','skssqz','4',' ','{Q[tcvat_nsrxx#1#skssqz]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664054;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664054,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#declarestatus',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','declarestatus','4',' ','{Q[tcvat_nsrxx#1#declarestatus]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664055;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664055,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#modifier',' ',' ','1','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','modifier','1',' ','{Q[tcvat_nsrxx#1#modifier]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664056;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664056,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#modifytime',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','modifytime','4',' ','{Q[tcvat_nsrxx#1#modifytime]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664057;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664057,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#billstatus',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','billstatus','4',' ','{Q[tcvat_nsrxx#1#billstatus]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664058;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664058,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#creator',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','creator','4',' ','{Q[tcvat_nsrxx#1#creator]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664059;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664059,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#prepayproject',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','prepayproject','4',' ','{C[#projectid]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664046;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664046,{ts'2022-03-31  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#1#jzbl',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jzbl',' ',' ','#if({Q[tcvat_prepay_flzl#5#bqsfsyjzzc]} == ''1'') {P[CSWHJSSJZ-2022]} #else #end');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664060;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664060,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#billno',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','billno','1',' ','{Q[tcvat_nsrxx#1#billno]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664061;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664061,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#id',' ',' ','4','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','id','4',' ','{Q[tcvat_nsrxx#1#id]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664062;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664062,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tctb_declare_entry#3#bqdybtse',' ',' ','1','3','1386788769012694016','zzsyjskb','tctb_declare_entry','bqdybtse','1',' ','{Q[tcvat_prepay_flzl#1#bqsjyjsfe]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664063;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664063,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tctb_declare_entry#4#bqdybtse',' ',' ','1','4','1386788769012694016','zzsyjskb','tctb_declare_entry','bqdybtse','1',' ','{Q[tcvat_prepay_flzl#2#bqsjyjsfe]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664064;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664064,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tctb_declare_entry#5#bqdybtse',' ',' ','1','5','1386788769012694016','zzsyjskb','tctb_declare_entry','bqdybtse','1',' ','{Q[tcvat_prepay_flzl#3#bqsjyjsfe]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664065;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664065,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tctb_declare_entry#1#bqdybtse',' ',' ','1','1','1386788769012694016','zzsyjskb','tctb_declare_entry','bqdybtse','1',' ','{Q[tcvat_prepay#5#advanceamount]}');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664066;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664066,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_declare_bill#1#bqybtse',' ','申报查询#1#合计预缴金额','1','1','1386788769012694016','zzsyjskb','tcvat_prepay_declare_bill','bqybtse','1',' ','{Q[tcvat_prepay#5#advanceamount]}+{Q[tcvat_prepay_flzl#1#bqsjyjsfe]}+{Q[tcvat_prepay_flzl#2#bqsjyjsfe]}+{Q[tcvat_prepay_flzl#3#bqsjyjsfe]}');
DELETE FROM t_tctb_formula WHERE FID = 1386957731038241792;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386957731038241792,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#5#bqsfsyjzzc','[{"val":"1","text":"是"},{"val":"0","text":"否"}]',' ','3','5','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqsfsyjzzc','4',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386958214230451200;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386958214230451200,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#6#xgmnsr','[{"val":"1","text":"是"},{"val":"0","text":"否"}]',' ','3','6','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','xgmnsr','4',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386958546293498880;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386958546293498880,{ts'2022-03-29  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#6#ybnsr','[{"val":"1","text":"个体工商户"},{"val":"0","text":"小型微利企业"}]',' ','3','6','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','ybnsr','4',' ',' ');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664048;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664048,{ts'2022-03-31  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#3#jzbl',' ',' ','4','3','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jzbl',' ',' ','#if({Q[tcvat_prepay_flzl#5#bqsfsyjzzc]} == ''1'') {P[DFJYFHJJZ-2022]} #else #end');
DELETE FROM t_tctb_formula WHERE FID = 1386788771537664047;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386788771537664047,{ts'2022-03-31  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#2#jzbl',' ',' ','4','2','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','jzbl',' ',' ','#if({Q[tcvat_prepay_flzl#5#bqsfsyjzzc]} == 1) {P[JYFFJJZ-2022]} #else #end');
DELETE FROM t_tctb_formula WHERE FID = 1388375532105805824;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388375532105805824,{ts'2022-03-31  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#7#skssqq',' ',' ','4','7','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','skssqq',' ',' ','#if(''{Q[tcvat_prepay_flzl#5#bqsfsyjzzc]}'' == ''1'')  {C[#startDate]}  #else   #end');
DELETE FROM t_tctb_formula WHERE FID = 1388375789678014464;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388375789678014464,{ts'2022-03-31  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#7#skssqz',' ',' ','4','7','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','skssqz',' ',' ','#if(''{Q[tcvat_prepay_flzl#5#bqsfsyjzzc]}'' == ''1'')  {C[#endDate]}  #else   #end');
DELETE FROM t_tctb_formula WHERE FID = 1388386759242592256;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388386759242592256,{ts'2022-04-07  00:00:00'},'若不适用小微企业 “六税两费”减免政策，则无需填写起止时间；若适用小微企业 “六税两费”减免政策，则适用减免政策的起止月份，不得超出当期申报的税款所属期限','《增值税预缴税款表附列资料》适用减免税额政策起止时间异常','VAT_PRE_202206','tcvat_prepay_flzl#7#skssqz',' ',' ','2','7','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','skssqz',' ',' ','#set($skssqz = ''{Q[tcvat_prepay_flzl#7#skssqz]}'' ) #set($startdate =  ''{C[#startDate]}'' ) #set($enddate = ''{C[#endDate]}'' ) #if(''{Q[tcvat_prepay_flzl#5#bqsfsyjzzc]}'' == ''0'') #if($skssqz  != ''0'') 0 #else 1 #end #else  #if($skssqz  != ''0'') #if($skssqz.compareTo($startdate) >= 0 && $skssqz.compareTo($enddate) <= 0) 1 #else 0 #end #else 0 #end #end ');
DELETE FROM t_tctb_formula WHERE FID = 1386957802416910336;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386957802416910336,{ts'2022-04-07  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#5#bqsfsyjzzc','#if(''{C[#taxmaininfo]}'' == ''xgmnsr'')  1  #else #if(''{C[#individual]}'' == ''1'') 1 #else 0 #end #end',' ','1','5','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqsfsyjzzc',' ',' ','if({C[#taxmaininfo]} = 0, 1,if({C[#individual]} = 1, 1,0))');
DELETE FROM t_tctb_formula WHERE FID = 1386958284686369792;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386958284686369792,{ts'2022-04-07  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#6#ybnsr',' ',' ','4','6','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','ybnsr',' ',' ',' #if(''{Q[tcvat_prepay_flzl#5#bqsfsyjzzc]}'' == ''1'')  #if(''{C[#taxmaininfo]}'' == ''1'')  #if(''{C[#individual]}'' == ''1'') 1  #else 0 #end #else 3 #end #else 3 #end');
DELETE FROM t_tctb_formula WHERE FID = 1386958149889827840;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1386958149889827840,{ts'2022-04-07  00:00:00'},' ',' ','VAT_PRE_202206','tcvat_prepay_flzl#6#xgmnsr',' ',' ','4','6','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','xgmnsr',' ',' ','#if(''{Q[tcvat_prepay_flzl#5#bqsfsyjzzc]}'' == ''1'')  #if(''{C[#taxmaininfo]}'' == ''0'') 1 #else 0 #end  #else 3 #end  ');
DELETE FROM t_tctb_formula WHERE FID = 1387550110912884736;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1387550110912884736,{ts'2022-04-07  00:00:00'},'本企业属于减免税政策的适用主体，请再次确认【本期是否适用小微企业的“六税两费”减免政策】填写内容是否恰当','《增值税预缴税款表附列资料》本期是否适用小微企业“六税两费”减免政策异常','VAT_PRE_202206','tcvat_prepay_flzl#5#bqsfsyjzzc',' ',' ','2','5','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','bqsfsyjzzc',' ',' ','if({C[#taxmaininfo]} = 0,  {Q[tcvat_prepay_flzl#5#bqsfsyjzzc]} = 1, if({C[#taxmaininfo]} = 1,if({C[#individual]}=1, {Q[tcvat_prepay_flzl#5#bqsfsyjzzc]} = 1, 1) ,0))');
DELETE FROM t_tctb_formula WHERE FID = 1388376633764917248;
INSERT INTO t_tctb_formula(FID,FUPDATETIME,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (1388376633764917248,{ts'2022-04-07  00:00:00'},'若不适用小微企业 “六税两费”减免政策，则无需填写起止时间；若适用小微企业 “六税两费”减免政策，则适用减免政策的起止月份，不得超出当期申报的税款所属期限','《增值税预缴税款表附列资料》适用减免税额政策起止时间异常','VAT_PRE_202206','tcvat_prepay_flzl#7#skssqq',' ',' ','2','7','1386788769012694016','zzsyjskb','tcvat_prepay_flzl','skssqq',' ',' ','#set($skssqq = ''{Q[tcvat_prepay_flzl#7#skssqq]}'' ) #set($startdate =  ''{C[#startDate]}'' ) #set($enddate = ''{C[#endDate]}'' ) #if(''{Q[tcvat_prepay_flzl#5#bqsfsyjzzc]}'' == ''0'') #if($skssqq  != ''0'') 0 #else 1 #end #else  #if($skssqq  != ''0'') #if($skssqq.compareTo($startdate) >= 0 && $skssqq.compareTo($enddate) <= 0) 1 #else 0 #end #else 0 #end #end ');
