--减值单引入模板
--单头
DELETE FROM t_bas_importtemplate WHERE FID = 783231480347586560;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (783231480347586560,'1',783231480347586560,'C',' ','fa_asset_devalue_IMPT_S','IMPT',{ts'2019-12-17  15:38:21'},'1','1',{ts'2019-12-17  15:41:08'},' ','1','fa_asset_devalue'); 
--多语言
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0F6CECZD8GMU';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (783231480347586560,'0F6CECZD8GMU','zh_CN','系统预置模板','减值单标准引入模板'); 
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0F6CECZD8GMV';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (783231480347586560,'0F6CECZD8GMV','zh_TW','係統預置模板','減值單標準引入模板'); 

--分录

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080280380416;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','0',' ',0,783230080280380416,'fa_asset_devalue','0',1,' ',' ','资产减值单'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080322465792;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','0',' ',783230080280380416,783230080322465792,'billhead','0',2,' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330712064;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1','number',783230080322465792,783230080330712064,'creator','0',3,' ','name','创建人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330854400;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080322465792,783230080330854400,'createtime','0',4,' ',' ','创建时间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330712065;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1','number',783230080322465792,783230080330712065,'auditor','0',5,' ','name','审核人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330854401;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080322465792,783230080330854401,'auditdate','0',6,' ',' ','审核日期'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330712066;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'1','1',' ',783230080322465792,783230080330712066,'billno','1',7,' ',' ','单据编号*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330854402;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'1','1','number',783230080322465792,783230080330854402,'org','1',8,' ','name','核算组织*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330712067;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080322465792,783230080330712067,'vounchernumber','0',9,' ',' ','凭证号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330854403;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'1','1','number',783230080322465792,783230080330854403,'depreuse','1',10,' ','name','折旧用途*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330712068;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080322465792,783230080330712068,'businessdate','0',11,' ',' ','业务日期'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330854404;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1','number',783230080322465792,783230080330854404,'devalueperiod','0',12,' ','name','减值期间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330712069;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080322465792,783230080330712069,'decvalsum','0',13,' ',' ','本期减值总额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330854405;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080322465792,783230080330854405,'billstatus','0',14,' ',' ','单据状态*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330712070;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080322465792,783230080330712070,'hasvoucher','0',15,' ',' ','凭证'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080330854406;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','0',' ',783230080280380416,783230080330854406,'changebillentry','0',16,' ',' ','减值明细分录'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080339100672;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'1','1','number',783230080330854406,783230080339100672,'realcard','1',17,' ','name','卡片编号*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080339243008;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1','number',783230080330854406,783230080339243008,'fincard','0',18,' ','name','财务卡片'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080339100673;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080330854406,783230080339100673,'networth','0',19,' ',' ','账面净值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080339243009;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'0','1',' ',783230080330854406,783230080339243009,'accumdevalue','0',20,' ',' ','累计减值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 783230080339100674;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (783231480347586560,'1','1',' ',783230080330854406,783230080339100674,'decval','1',21,' ',' ','本期减值'); 

