----委托代销清单列表常用方案预制
DELETE FROM t_bas_filterscheme WHERE FSCHEMEID = '1J2SVZ9750DA';
INSERT INTO t_bas_filterscheme(FSCHEMEID,FISSHARE,FFORMID,FSCHEME,FENTRYENTITY,FISDEFAULT,FSCHEMENAME,FNEXTENTRYSCHEME,FCREATETIME,FSEQ,FMODIFYTIME,FISFIXED,FUSERID) VALUES ('1J2SVZ9750DA','0','sm_salesagency','','billentry','0','待结算','0',{ts'2018-08-08 18:08:00'},0,NULL,'1',0); 

DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2SVZ=80KUP';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2SVZ9750DA','1J2SVZ9750DA','1J2SVZ=80KUP','zh_CN','物料明细.累计结算数量 等于 0  ','待结算'); 
DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2SVZ=80LHZ';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2SVZ9750DA','1J2SVZ9750DA','1J2SVZ=80LHZ','en_US','物料明细.累计结算数量 等于 0  ','待结算'); 
DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2SVZ=80KUQ';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2SVZ9750DA','1J2SVZ9750DA','1J2SVZ=80KUQ','zh_TW','物料明细.累计结算数量 等于 0  ','待结算'); 



DELETE FROM t_bas_filterscheme WHERE FSCHEMEID = '1J2TNU27GJNP';
INSERT INTO t_bas_filterscheme(FSCHEMEID,FISSHARE,FFORMID,FSCHEME,FENTRYENTITY,FISDEFAULT,FSCHEMENAME,FNEXTENTRYSCHEME,FCREATETIME,FSEQ,FMODIFYTIME,FISFIXED,FUSERID) VALUES ('1J2TNU27GJNP','0','sm_salesagency','','billentry','0','已结算','0',{ts'2018-08-08 18:08:00'},0,NULL,'1',0); 

DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2TNU27GJ+F';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2TNU27GJNP','1J2TNU27GJNP','1J2TNU27GJ+F','zh_CN','物料明细.未结算数量 等于 0  ','已结算'); 
DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2TNU27GJNQ';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2TNU27GJNP','1J2TNU27GJNP','1J2TNU27GJNQ','en_US','物料明细.未结算数量 等于 0  ','已结算'); 
DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2TNU27GJ+G';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2TNU27GJNP','1J2TNU27GJNP','1J2TNU27GJ+G','zh_TW','物料明细.未结算数量 等于 0  ','已结算'); 



DELETE FROM t_bas_filterscheme WHERE FSCHEMEID = '1J2T/KG60W3N';
INSERT INTO t_bas_filterscheme(FSCHEMEID,FISSHARE,FFORMID,FSCHEME,FENTRYENTITY,FISDEFAULT,FSCHEMENAME,FNEXTENTRYSCHEME,FCREATETIME,FSEQ,FMODIFYTIME,FISFIXED,FUSERID) VALUES ('1J2T/KG60W3N','0','sm_salesagency',' ','billentry','0','部分结算','0',{ts'2018-08-08 18:08:00'},0,NULL,'1',0); 


DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2T/KG60VFD';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2T/KG60W3N','1J2T/KG60W3N','1J2T/KG60VFD','zh_CN', '物料明细.累计结算数量 大于 0  并且    物料明细.未结算数量 大于 0  ','部分结算'); 
DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2T/KG60W3O';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2T/KG60W3N','1J2T/KG60W3N','1J2T/KG60W3O','en_US', '物料明细.累计结算数量 大于 0  并且    物料明细.未结算数量 大于 0  ','部分结算'); 
DELETE FROM t_bas_filterscheme_l WHERE FPKID = '1J2T/KG60VFE';
INSERT INTO t_bas_filterscheme_l(FID,FSCHEMEID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('1J2T/KG60W3N','1J2T/KG60W3N','1J2T/KG60VFE','zh_TW', '物料明细.累计结算数量 大于 0  并且    物料明细.未结算数量 大于 0  ','部分结算'); 
