--重估单引入模板
--单头
DELETE FROM t_bas_importtemplate WHERE FID = 767881035672313856;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (767881035672313856,'1',767881035672313856,'C',' ','fa_clearbill_IMPT_S1','IMPT',{ts'2019-11-26  11:20:33'},'1',13466739,{ts'2020-02-19  13:54:06'},' ',17222181,'fa_clearbill'); 

--多语言
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0D=U8Z9QOZP+';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (767881035672313856,'0D=U8Z9QOZP+','zh_CN','出厂预置模板','清理单部分清理引入模板'); 
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0D=U8Z9QOZP/';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (767881035672313856,'0D=U8Z9QOZP/','zh_TW','出廠預置模板','清理單部分清理引入模板'); 


--分录
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245637289984;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','0',' ',0,833998245637289984,'fa_clearbill','0',1,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245670966272;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','0',' ',833998245637289984,833998245670966272,'billhead','0',2,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245670844416;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',833998245670966272,833998245670844416,'billno','0',3,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245670966273;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',833998245670966272,833998245670966273,'cleardate','1',4,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245670844417;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1','number',833998245670966272,833998245670844417,'org','1',5,' ','name',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245670966274;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',833998245670966272,833998245670966274,'reason','0',6,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679233024;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','0',' ',833998245637289984,833998245679233024,'detail_entry','0',7,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679354880;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',833998245679233024,833998245679354880,'number','1',8,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679233025;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1','number',833998245679233024,833998245679233025,'depreuse','1',9,' ','name',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679354881;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',833998245679233024,833998245679354881,'clearqty','0',10,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679233026;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',833998245679233024,833998245679233026,'clearfare','0',11,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679354882;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',833998245679233024,833998245679354882,'clearincome','0',12,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679233027;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',833998245679233024,833998245679233027,'assetvalue','0',13,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679354883;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',833998245679233024,833998245679354883,'bizdate','1',14,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679233028;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',833998245679233024,833998245679233028,'remark','0',15,' ',' ',null); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 833998245679354884;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',833998245679233024,833998245679354884,'isclearall','0',16,' ',' ',null); 


