DELETE FROM t_tctb_formula WHERE FID = 936988937086480384;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936988937086480384,' ',' ','VATYD20180101','tcvat_xgm_current_payment#1#taxableamount',' ','小规模本期缴税情况单据#1#应税销售额','1','1',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxableamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#salesexcludtax]}>{P[Tax Threshold-SS]},{Q[tcvat_xgm_current_payment#1#salesexcludtax]},{Q[tcvat_xgm_current_payment#1#specialincludtax]}),{Q[tcvat_xgm_current_payment#1#specialincludtax]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936989042027966464;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936989042027966464,' ',' ','VATYD20180101','tcvat_xgm_current_payment#2#taxableamount',' ','小规模本期缴税情况单据#2#应税销售额','1','2',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxableamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#salesexcludtax]}>{P[Tax Threshold-SS]},{Q[tcvat_xgm_current_payment#2#salesexcludtax]},{Q[tcvat_xgm_current_payment#2#specialincludtax]}),{Q[tcvat_xgm_current_payment#2#specialincludtax]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936989177462034432;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936989177462034432,' ',' ','VATYD20180101','tcvat_xgm_current_payment#3#taxableamount',' ','小规模本期缴税情况单据#3#应税销售额','1','3',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxableamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#salesexcludtax]}>{P[Tax Threshold-SS]},{Q[tcvat_xgm_current_payment#3#salesexcludtax]},{Q[tcvat_xgm_current_payment#3#specialincludtax]}-{Q[tcvat_xgm_current_payment#4#specialincludtax]}+{Q[tcvat_xgm_current_payment#4#taxableamount]}),{Q[tcvat_xgm_current_payment#3#specialincludtax]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936989313634316288;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936989313634316288,' ',' ','VATYD20180101','tcvat_xgm_current_payment#4#taxableamount',' ','小规模本期缴税情况单据#4#应税销售额','1','4',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxableamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},{Q[tcvat_xgm_current_payment#4#salesexcludtax]},{Q[tcvat_xgm_current_payment#4#specialincludtax]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936989426805018624;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936989426805018624,' ',' ','VATYD20180101','tcvat_xgm_current_payment#5#taxableamount',' ','小规模本期缴税情况单据#5#应税销售额','1','5',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxableamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#salesexcludtax]}>{P[Tax Threshold-SS]},{Q[tcvat_xgm_current_payment#5#salesexcludtax]},{Q[tcvat_xgm_current_payment#5#specialincludtax]}),{Q[tcvat_xgm_current_payment#5#specialincludtax]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936990022505238528;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936990022505238528,' ',' ','VATYD20180101','tcvat_xgm_current_payment#1#taxfreeamount',' ','小规模本期缴税情况单据#1#免税销售额','1','1',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxfreeamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#salesexcludtax]}>{P[Tax Threshold-SS]},0,{Q[tcvat_xgm_current_payment#1#salesexcludtax]}-{Q[tcvat_xgm_current_payment#1#taxableamount]}),{Q[tcvat_xgm_current_payment#1#salesexcludtax]}-{Q[tcvat_xgm_current_payment#1#taxableamount]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936990151882747904;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936990151882747904,' ',' ','VATYD20180101','tcvat_xgm_current_payment#2#taxfreeamount',' ','小规模本期缴税情况单据#2#免税销售额','1','2',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxfreeamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#salesexcludtax]}>{P[Tax Threshold-SS]},0,{Q[tcvat_xgm_current_payment#2#salesexcludtax]}-{Q[tcvat_xgm_current_payment#2#taxableamount]}),{Q[tcvat_xgm_current_payment#2#salesexcludtax]}-{Q[tcvat_xgm_current_payment#2#taxableamount]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936990261337296896;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936990261337296896,' ',' ','VATYD20180101','tcvat_xgm_current_payment#3#taxfreeamount',' ','小规模本期缴税情况单据#3#免税销售额','1','3',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxfreeamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#salesexcludtax]}>{P[Tax Threshold-SS]},0,{Q[tcvat_xgm_current_payment#3#salesexcludtax]}-{Q[tcvat_xgm_current_payment#3#taxableamount]}),{Q[tcvat_xgm_current_payment#3#salesexcludtax]}-{Q[tcvat_xgm_current_payment#3#taxableamount]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936990380799471616;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936990380799471616,' ',' ','VATYD20180101','tcvat_xgm_current_payment#4#taxfreeamount',' ','小规模本期缴税情况单据#4#免税销售额','1','4',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxfreeamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},0,{Q[tcvat_xgm_current_payment#4#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#taxableamount]})'); 
DELETE FROM t_tctb_formula WHERE FID = 936990484600098816;
INSERT INTO t_tctb_formula(FID,FCONTENT,FTITLE,FTEMPLATENUM,FFORMULAKEY,FFORMULANAME,FNAME,FFORMULATYPE,FROW,FUPDATETIME,FTEMPLATEID,FTAXTYPE,FTABLE,FCOLUMN,FCELLTYPE,FDESCRIBE,FFORMULA) VALUES (936990484600098816,' ',' ','VATYD20180101','tcvat_xgm_current_payment#5#taxfreeamount',' ','小规模本期缴税情况单据#5#免税销售额','1','5',{ts'2022-05-20  00:00:00'},'936736634886590464','zzsaccountmonth','tcvat_xgm_current_payment','taxfreeamount',' ',' ','if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}>{P[Tax Threshold-SS]},if({Q[tcvat_xgm_current_payment#8#salesexcludtax]}-{Q[tcvat_xgm_current_payment#4#salesexcludtax]}>{P[Tax Threshold-SS]},0,{Q[tcvat_xgm_current_payment#5#salesexcludtax]}-{Q[tcvat_xgm_current_payment#5#taxableamount]}),{Q[tcvat_xgm_current_payment#5#salesexcludtax]}-{Q[tcvat_xgm_current_payment#5#taxableamount]})'); 
