-- 采购转固单导入模板
DELETE FROM t_bas_importtemplate WHERE FID = 779732930481153024;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNAME,FNUMBER,FTEMPLATETYPE,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (779732930481153024,'0',779732930481153024,'C',' ','fa_purchasebill_IMPT_S','IMPT',{ts'2019-12-12  19:46:38'},'1',777250039784303616,{ts'2019-12-13  09:46:21'},' ',777250039784303616,'fa_purchasebill'); 

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0ERLQHY9XMIF';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (779732930481153024,'0ERLQHY9XMIF','zh_CN','采购转固单导入模板(出厂预置)','采购转固单导入模板(出厂预置)'); 
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0ERLQHY9XMIG';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (779732930481153024,'0ERLQHY9XMIG','zh_TW','采購轉固單導入模板(出廠預置)','采購轉固單導入模板(出廠預置)'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887597122560;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','0',' ',0,780337887597122560,'fa_purchasebill','0',1,' ',' ','采购转固单'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887638993920;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','0',' ',780337887597122560,780337887638993920,'billhead','0',2,' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887639065600;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1','number',780337887638993920,780337887639065600,'creator','0',3,' ','name','创建人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887638993921;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887638993920,780337887638993921,'createtime','0',4,' ',' ','创建时间'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887639065601;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1','number',780337887638993920,780337887639065601,'auditor','0',5,' ','name','审核人'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887638993922;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887638993920,780337887638993922,'auditdate','0',6,' ',' ','审核日期'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887639065602;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887638993920,780337887639065602,'billno','0',7,' ',' ','转固单号*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887638993923;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887638993920,780337887638993923,'assetunit','1',8,' ','name','资产组织*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887639065603;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887638993920,780337887639065603,'org','1',9,' ','name','核算组织*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887638993924;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887638993920,780337887638993924,'purchasedate','1',10,' ',' ','业务日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887639065604;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887638993920,780337887639065604,'buildway','0',11,' ',' ','建卡方式*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887647382528;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887638993920,780337887647382528,'handler','1',12,' ','name','经办人*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887647454208;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887638993920,780337887647454208,'handleorg','1',13,' ','name','经办部门*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887647382529;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887638993920,780337887647382529,'remark','0',14,' ',' ','备注'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887647454209;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887638993920,780337887647454209,'billstatus','0',15,' ',' ','单据状态*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887647382530;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887638993920,780337887647382530,'sourcebillno','0',16,' ',' ','来源单据编码'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887647454210;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887638993920,780337887647454210,'sourcebillsign','0',17,' ',' ','来源单据标识'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159744;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','0',' ',780337887597122560,780337887664159744,'assetsentry','0',18,' ',' ','资产信息'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231424;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887664159744,780337887664231424,'materielfield','0',19,' ','name','物料'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159745;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887664159744,780337887664159745,'assetcat','1',20,' ','name','资产类别*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231425;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664231425,'assetname','1',21,' ',' ','资产名称*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159746;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664159746,'model','0',22,' ',' ','规格型号'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231426;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887664159744,780337887664231426,'unit','1',23,' ','name','计量单位*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159747;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664159747,'assetqty','1',24,' ',' ','数量*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231427;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887664159744,780337887664231427,'storeplace','1',25,' ','name','存放地点*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159748;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664159748,'realaccountdate','1',26,' ',' ','实物入账日期*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231428;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1','number',780337887664159744,780337887664231428,'currency','0',27,' ','name','币别'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159749;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1','number',780337887664159744,780337887664159749,'supplier','0',28,' ','name','供应商'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231429;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664231429,'unitprice','0',29,' ',' ','单价'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159750;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664159750,'taxunitprice','0',30,' ',' ','含税单价'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231430;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664231430,'notaxamount','1',31,' ',' ','无税金额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159751;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664159751,'taxamount','1',32,' ',' ','税额'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231431;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887664159744,780337887664231431,'assetqtyleft','0',33,' ',' ','可生成卡片数量'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159752;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664159752,'totalamount','1',34,' ',' ','价税合计*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231432;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664231432,'entryremark','0',35,' ',' ','备注'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664159753;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'1','1',' ',780337887664159744,780337887664159753,'isdeductiontax','0',36,' ',' ','是否专票'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 780337887664231433;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (779732930481153024,'0','1',' ',780337887664159744,780337887664231433,'sourceentryid','0',37,' ',' ','来源分录id'); 
