DELETE FROM t_bas_importtemplate WHERE FID = 707133519423557632;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (707133519423557632,'0',707133519423557632,'C',' ','fa_clearbill_IMPT_S','IMPT',{ts'2019-09-05  15:46:08'},'1',1,{ts'2019-09-05  16:33:27'},' ',1,'fa_clearbill'); 

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_importtemplateentry WHERE FENTRYID = 708605672790621184;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','0',' ',0,708605672790621184,'fa_clearbill','0',1,' ',' ','清理单'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672899681280;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','0',' ',708605672790621184,708605672899681280,'billhead','0',2,' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672899673088;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672899673088,'billno','0',3,' ',' ','清理单号*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672899681281;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672899681281,'cleardate','0',4,' ',' ','清理日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672899673089;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'1','1','number',708605672899681280,708605672899673089,'org','1',5,' ','name','核算组织*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672899681282;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672899681280,708605672899681282,'changemode','0',6,' ','name','减少方式*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672899673090;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672899673090,'reason','0',7,' ',' ','清理原因'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672899681283;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672899681283,'vounchernumber','0',8,' ',' ','凭证号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672899673091;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672899673091,'auditdate','0',9,' ',' ','审核日期'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672908069888;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672908069888,'createtime','0',10,' ',' ','创建时间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672908061696;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672899681280,708605672908061696,'auditor','0',11,' ','name','审核人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672908069889;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672908069889,'billstatus','0',12,' ',' ','单据状态*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672908061697;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672899681280,708605672908061697,'creator','0',13,' ','name','创建人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672908069890;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672908069890,'srcbill','0',14,' ',' ','来源单据id'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672908061698;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672908061698,'clearsource','0',15,' ',' ','清理来源'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672908069891;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672899681280,708605672908069891,'hasvoucher','0',16,' ',' ','凭证'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672908061699;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672899681280,708605672908061699,'clearperiod','0',17,' ','name','清理期间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924847104;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','0',' ',708605672790621184,708605672924847104,'detail_entry','0',18,' ',' ','清理资产详情分录'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924838912;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672924847104,708605672924838912,'realcard','0',19,' ','name','卡片编号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924847105;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'1','1',' ',708605672924847104,708605672924847105,'number','1',20,' ',' ','资产编码'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924838913;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672924847104,708605672924838913,'assetname','0',21,' ',' ','资产名称'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924847106;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672924847104,708605672924847106,'depreuse','0',22,' ','name','折旧用途'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924838914;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672924847104,708605672924838914,'clearqty','0',23,' ',' ','清理数量'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924847107;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672924847104,708605672924847107,'measureunit','0',24,' ','name','计量单位'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924838915;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672924847104,708605672924838915,'basecurrency','0',25,' ','name','本位币'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924847108;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'1','1',' ',708605672924847104,708605672924847108,'clearfare','0',26,' ',' ','清理费用（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924838916;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'1','1',' ',708605672924847104,708605672924838916,'clearincome','0',27,' ',' ','清理收入（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924847109;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672924847104,708605672924847109,'assetvalue','0',28,' ',' ','资产原值（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924838917;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672924847104,708605672924838917,'addupdepre','0',29,' ',' ','累计折旧（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924847110;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672924847104,708605672924847110,'decval','0',30,' ',' ','减值准备（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924838918;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672924847104,708605672924838918,'netamount','0',31,' ',' ','资产净额（本币）'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672924847111;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'1','1',' ',708605672924847104,708605672924847111,'remark','0',32,' ',' ','备注'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672933227520;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1','number',708605672924847104,708605672933227520,'fincard','0',33,' ','name','财务卡片'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 708605672933235712;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (707133519423557632,'0','1',' ',708605672924847104,708605672933235712,'entry','0',34,' ',' ','分录'); 
