--重估单引入模板
--单头
DELETE FROM t_bas_importtemplate WHERE FID = 787518735039696896;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (787518735039696896,'1',787518735039696896,'C',' ','fa_recalculate_IMPT_S','IMPT',{ts'2019-12-23  13:35:54'},'1','1',{ts'2019-12-24  15:01:59'},' ','1','fa_recalculate'); 

--多语言
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0FPXGIXUI7EB';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (787518735039696896,'0FPXGIXUI7EB','zh_CN','系统预置模板','资产重估单标准引入模板'); 
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0FPXGIXUI7EC';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (787518735039696896,'0FPXGIXUI7EC','zh_TW','係統預置模板','資產重估單標準引入模板'); 

--分录
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285068933270528;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','0',' ',0,788285068933270528,'fa_recalculate','0',1,' ',' ','资产重估单'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059084288;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','0',' ',788285068933270528,788285069059084288,'billhead','0',2,' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059099648;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1','number',788285069059084288,788285069059099648,'creator','0',3,' ','name','创建人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059084289;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069059084288,788285069059084289,'createtime','0',4,' ',' ','创建时间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059099649;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1','number',788285069059084288,788285069059099649,'auditor','0',5,' ','name','审核人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059084290;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069059084288,788285069059084290,'auditdate','0',6,' ',' ','审核日期'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059099650;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'1','1',' ',788285069059084288,788285069059099650,'billno','0',7,' ',' ','重估单号*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059084291;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'1','1','number',788285069059084288,788285069059084291,'org','1',8,' ','name','核算组织*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059099651;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'1','1',' ',788285069059084288,788285069059099651,'coefficient','1',9,' ',' ','重估系数（%）*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059084292;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'1','1','number',788285069059084288,788285069059084292,'depreuse','1',10,' ','name','折旧用途*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059099652;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'1','1',' ',788285069059084288,788285069059099652,'bizdate','1',11,' ',' ','重估日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069059084293;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069059084288,788285069059084293,'billstatus','0',12,' ',' ','单据状态*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069067488256;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','0',' ',788285068933270528,788285069067488256,'recalculateentry','0',13,' ',' ','单据体'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861504;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'1','1','number',788285069067488256,788285069075861504,'realcard','1',14,' ','name','卡片编号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876864;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876864,'bforivalue','0',15,' ',' ','重估前原值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861505;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861505,'orivalue','0',16,' ',' ','原值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876865;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876865,'bfnetworth','0',17,' ',' ','重估前净值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861506;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861506,'networth','0',18,' ',' ','净值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876866;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876866,'bfnetamount','0',19,' ',' ','重估前净额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861507;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861507,'netamount','0',20,' ',' ','净额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876867;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876867,'bfpreresidualval','0',21,' ',' ','重估前残值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861508;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861508,'preresidualval','0',22,' ',' ','残值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876868;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876868,'bfaccumdepre','0',23,' ',' ','重估前累计折旧'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861509;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861509,'accumdepre','0',24,' ',' ','累计折旧'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876869;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876869,'bfaddupyeardepre','0',25,' ',' ','重估前本年累计折旧'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861510;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861510,'addupyeardepre','0',26,' ',' ','本年累计折旧'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876870;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876870,'bfmonthdepre','0',27,' ',' ','重估前本期折旧'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861511;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861511,'monthdepre','0',28,' ',' ','本期折旧'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876871;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876871,'bfyearorigvalchg','0',29,' ',' ','重估前本年原值变动'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861512;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861512,'yearorigvalchg','0',30,' ',' ','本年原值变动'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876872;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876872,'bfmonthorigvalchg','0',31,' ',' ','重估前本期原值变动'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861513;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861513,'monthorigvalchg','0',32,' ',' ','本期原值变动'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876873;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1','number',788285069067488256,788285069075876873,'currency','0',33,' ','name','币别'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861514;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1','number',788285069067488256,788285069075861514,'fincard','0',34,' ','name','财务卡片'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075876874;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075876874,'bfdepredamount','0',35,' ',' ','重估前已折旧期间数'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 788285069075861515;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (787518735039696896,'0','1',' ',788285069067488256,788285069075861515,'depredamount','0',36,' ',' ','已折旧期间数'); 