DELETE FROM t_tpo_rule_fetch WHERE FID = 2000167278183730176;
INSERT INTO t_tpo_rule_fetch(FID,FMODELID,FDATATYPE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFITTYPE,FCREATORID,FFORMULA) VALUES (2000167278183730176,1532683517396254720,'number',' ',2000167278183730176,'A','CN-BBXGZ-000144907',{ts'2024-07-22  00:00:00'},13466739,'1',{ts'2024-07-22  00:00:00'},'BBXGZ',13466739,'if(''{P[sjjtdraftstatus]}''==''C'',if(''{P[sjjttype]}''==''draft_zzsybnsr_sjjt'',{M[select sum(ybxm) from tcvat_zlb_ybnsr where sbbid in (select sbbid from tcvat_dg_ybnsr where mainid>0 and mainid in (select id from tpo_declare_main_tsd where billstatus=''C'' and org = ''#orgid'' and skssqq >= ''#startDate'' AND skssqz <= ''#endDate'' and templatetype = ''#sjjttype'')) and ewblxh=''105'']},{M[select sum(ybxm) from tcvat_zlb_zzsybnsr_ybhz where sbbid in (select sbbid from tcvat_dg_ybnsr_ybhz where mainid>0 and mainid in (select id from tpo_declare_main_tsd where billstatus=''C'' and org = ''#orgid'' and skssqq >= ''#startDate'' AND skssqz <= ''#endDate'' and templatetype = ''#sjjttype'')) and ewblxh=''112'']}),0)'); 
DELETE FROM t_tpo_rule_fetch WHERE FID = 2000168109243123712;
INSERT INTO t_tpo_rule_fetch(FID,FMODELID,FDATATYPE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFITTYPE,FCREATORID,FFORMULA) VALUES (2000168109243123712,1532683517396254720,'number',' ',2000168109243123712,'A','CN-BBXGZ-000144908',{ts'2024-07-22  00:00:00'},13466739,'1',{ts'2024-07-22  00:00:00'},'BBXGZ',13466739,'{M[select syslnsjcybjse from tcvat_ybnsr_zb where ewblxh = ''1'' and sbbid = ''#sbbid'']}'); 
DELETE FROM t_tpo_rule_fetch WHERE FID = 2000169255194085376;
INSERT INTO t_tpo_rule_fetch(FID,FMODELID,FDATATYPE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFITTYPE,FCREATORID,FFORMULA) VALUES (2000169255194085376,1532683517396254720,'number',' ',2000169255194085376,'A','CN-BBXGZ-000144909',{ts'2024-07-22  00:00:00'},13466739,'1',{ts'2024-07-22  00:00:00'},'BBXGZ',13466739,' {Q[nszlbd_dkse_12_1_nsjcybjse#ybxm_sbje]} - {Q[nszlbd_dkse_12_1_nsjcybjse#ybxm_jtje]}'); 
DELETE FROM t_tpo_rule_fetch WHERE FID = 2000174009102126080;
INSERT INTO t_tpo_rule_fetch(FID,FMODELID,FDATATYPE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFITTYPE,FCREATORID,FFORMULA) VALUES (2000174009102126080,1532683517396254720,'number',' ',2000174009102126080,'A','CN-BBXGZ-000144910',{ts'2024-07-22  00:00:00'},13466739,'1',{ts'2024-07-22  00:00:00'},'BBXGZ',13466739,'if(''{P[sjjtdraftstatus]}''==''C'',if(''{P[sjjttype]}''==''draft_zzsybnsr_sjjt'',{M[select sum(ybxm) from tcvat_zlb_ybnsr where sbbid in (select sbbid from tcvat_dg_ybnsr where mainid>0 and mainid in (select id from tpo_declare_main_tsd where billstatus=''C'' and org = ''#orgid'' and skssqq >= ''#startDate'' AND skssqz <= ''#endDate'' and templatetype = ''#sjjttype'')) and ewblxh=''106'']},{M[select sum(ybxm) from tcvat_zlb_zzsybnsr_ybhz where sbbid in (select sbbid from tcvat_dg_ybnsr_ybhz where mainid>0 and mainid in (select id from tpo_declare_main_tsd where billstatus=''C'' and org = ''#orgid'' and skssqq >= ''#startDate'' AND skssqz <= ''#endDate'' and templatetype = ''#sjjttype'')) and ewblxh=''129'']}),0)'); 
DELETE FROM t_tpo_rule_fetch WHERE FID = 2000185041975527424;
INSERT INTO t_tpo_rule_fetch(FID,FMODELID,FDATATYPE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFITTYPE,FCREATORID,FFORMULA) VALUES (2000185041975527424,1532683517396254720,'number',' ',2000185041975527424,'A','CN-BBXGZ-000144911',{ts'2024-07-22  00:00:00'},13466739,'1',{ts'2024-07-22  00:00:00'},'BBXGZ',13466739,'{M[select jybfnsjcybjse from tcvat_ybnsr_zb where ewblxh = ''1'' and sbbid = ''#sbbid'']}'); 
DELETE FROM t_tpo_rule_fetch WHERE FID = 2000185809264724992;
INSERT INTO t_tpo_rule_fetch(FID,FMODELID,FDATATYPE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFITTYPE,FCREATORID,FFORMULA) VALUES (2000185809264724992,1532683517396254720,'number',' ',2000185809264724992,'A','CN-BBXGZ-000144912',{ts'2024-07-22  00:00:00'},13466739,'1',{ts'2024-07-22  00:00:00'},'BBXGZ',13466739,'{Q[nszlbd_zzse_25_1_jyjsnsjcybjse#ybxm_sbje]}-{Q[nszlbd_zzse_25_1_jyjsnsjcybjse#ybxm_jtje]}'); 
