-- 清理单清理模板添加业务日期引出项
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691547540575239;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'1','1',' ',768691547532186624,768691547540575239,'bizdate','1',38,' ',' ','业务日期*');
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '06USUUX6BJ7U';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (707133519423557632,'06USUUX6BJ7U','zh_CN','出厂预置模板','清理单完全清理引入模板'); 
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '06USUUX6BJ7V';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (707133519423557632,'06USUUX6BJ7V','zh_TW','出廠預置模板','清理單完全清理引入模板'); 


-- 添加部分清理引入引出模板
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',17222181,{ts'2019-11-27  14:13:37'},' ',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 = 768691844581219328;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','0',' ',768691844480521216,768691844581219328,'detail_entry','0',18,' ',' ','清理资产详情分录'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581184512;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1','number',768691844581219328,768691844581184512,'realcard','0',19,' ','name','卡片编号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581219329;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',768691844581219328,768691844581219329,'number','1',20,' ',' ','资产编码'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581184513;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844581184513,'assetname','0',21,' ',' ','资产名称'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581219330;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1','number',768691844581219328,768691844581219330,'depreuse','1',22,' ','name','折旧用途'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581184514;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844581184514,'clearqty','0',23,' ',' ','清理数量'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581219331;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1','number',768691844581219328,768691844581219331,'measureunit','0',24,' ','name','计量单位'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581184515;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1','number',768691844581219328,768691844581184515,'basecurrency','0',25,' ','name','本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581219332;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',768691844581219328,768691844581219332,'clearfare','0',26,' ',' ','清理费用（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581184516;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',768691844581219328,768691844581184516,'clearincome','0',27,' ',' ','清理收入（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581219333;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',768691844581219328,768691844581219333,'assetvalue','1',28,' ',' ','清理资产原值（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844581184517;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844581184517,'addupdepre','0',29,' ',' ','清理累计折旧（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589607936;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844589607936,'decval','0',30,' ',' ','清理减值准备（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589573120;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844589573120,'netamount','0',31,' ',' ','清理资产净额（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589607937;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844589607937,'preresidualval','0',32,' ',' ','清理资产残值（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589573121;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',768691844581219328,768691844589573121,'remark','0',33,' ',' ','备注'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589607938;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1','number',768691844581219328,768691844589607938,'fincard','0',34,' ','name','财务卡片'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589573122;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844589573122,'entry','0',35,' ',' ','分录'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589607939;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844589607939,'clearrate','0',36,' ',' ','清理率'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589573123;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844581219328,768691844589573123,'isclearall','0',37,' ',' ','是否完全清理'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844589607940;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1',' ',768691844581219328,768691844589607940,'bizdate','1',38,' ',' ','业务日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844480521216;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','0',' ',0,768691844480521216,'fa_clearbill','0',1,' ',' ','清理单'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844556053504;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','0',' ',768691844480521216,768691844556053504,'billhead','0',2,' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844556018688;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1','number',768691844556053504,768691844556018688,'creator','0',3,' ','name','创建人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844556053505;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844556053505,'createtime','0',4,' ',' ','创建时间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844556018689;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1','number',768691844556053504,768691844556018689,'auditor','0',5,' ','name','审核人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564442112;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564442112,'auditdate','0',6,' ',' ','审核日期'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564407296;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564407296,'billno','0',7,' ',' ','清理单号*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564442113;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564442113,'cleardate','0',8,' ',' ','记账日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564407297;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'1','1','number',768691844556053504,768691844564407297,'org','1',9,' ','name','核算组织*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564442114;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1','number',768691844556053504,768691844564442114,'changemode','0',10,' ','name','减少方式*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564407298;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564407298,'reason','0',11,' ',' ','清理原因'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564442115;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564442115,'vounchernumber','0',12,' ',' ','凭证号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564407299;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564407299,'billstatus','0',13,' ',' ','单据状态*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564442116;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564442116,'srcbill','0',14,' ',' ','来源单据id'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564407300;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564407300,'clearsource','0',15,' ',' ','清理来源'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564442117;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1',' ',768691844556053504,768691844564442117,'hasvoucher','0',16,' ',' ','凭证'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 768691844564407301;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (767881035672313856,'0','1','number',768691844556053504,768691844564407301,'clearperiod','0',17,' ','name','清理期间'); 
