DELETE from T_BAS_IMPORTTEMPLATE WHERE fid = '685953223705722880';

Insert into T_BAS_IMPORTTEMPLATE (FID,FCREATETIME,FMODIFYTIME,FMODIFIERID,FNUMBER,FNAME,FBIZOBJECT,FSTATUS,FCREATORID,FENABLE,FCOMMENT,FMASTERID,FTEMPLATETYPE,FENABLEIMPORT) values (685953223705722880,{ts'2018-08-08 18:08:08'},{ts'2018-08-08 18:08:08'},1,'pur_bizperson_IMPT_S',' ','pur_bizperson','C',1,'1',' ',685953223705722880,'IMPT','1');

DELETE from T_BAS_IMPORTTEMPLATE_L WHERE fid = '685953223705722880';
Insert into T_BAS_IMPORTTEMPLATE_L (FPKID,FID,FLOCALEID,FNAME,FCOMMENT) values ('048ADD721NGF',685953223705722880,'zh_CN','业务员引入模板',' ');
Insert into T_BAS_IMPORTTEMPLATE_L (FPKID,FID,FLOCALEID,FNAME,FCOMMENT) values ('048ADD721NGG',685953223705722880,'zh_TW','業務員引入模板',' ');

DELETE from T_BAS_IMPORTTEMPLATEENTRY WHERE fid = '685953223705722880';
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144787970048,0,1,'pur_bizperson','业务员','0',' ','0','0',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848000,685952144787970048,2,'billhead','单据头','0',' ','0','0',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144855078912,685952144787970048,3,'entryentity','联系人分录','0',' ','0','0',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144855236608,685952144855078912,4,'supplier','供应商','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144855078913,685952144855078912,5,'entrybizscope','业务类型','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144855236609,685952144855078912,6,'contacter','联系人','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144855078914,685952144855078912,7,'default','默认','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144855236610,685952144855078912,8,'forbid','停用','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144855078915,685952144855078912,9,'note','备注','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690304,685952144846848000,10,'user','对应人员*','1',' ','1','1','name',',number,name,');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848001,685952144846848000,11,'name','业务员名称*','1',' ','1','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690305,685952144846848000,12,'phone','手机','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848002,685952144846848000,13,'group','所属业务组','1',' ','1','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690306,685952144846848000,14,'remark','备注','0',' ','1','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848003,685952144846848000,15,'number','编码','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690307,685952144846848000,16,'status','数据状态','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848004,685952144846848000,17,'creator','创建人','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690308,685952144846848000,18,'createtime','创建时间','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848005,685952144846848000,19,'auditor','审核人','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690309,685952144846848000,20,'auditdate','审核时间','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848006,685952144846848000,21,'enable','可用状态','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690310,685952144846848000,22,'org','业务组织','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848007,685952144846848000,23,'createorg','创建组织*','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690311,685952144846848000,24,'useorg','业务组织','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848008,685952144846848000,25,'ctrlstrategy','控制策略*','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690312,685952144846848000,26,'billcreator','受控的单据创建人','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848009,685952144846848000,27,'prodclass','受控的商品分类','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690313,685952144846848000,28,'matscope','物料分类','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848010,685952144846848000,29,'whascope','仓库','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690314,685952144846848000,30,'orgscope','业务组织','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848011,685952144846848000,31,'bizscope','业务范围','0',' ','0','1',' ',' ');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846690315,685952144846848000,32,'supclass','受控的供应商分组','0',' ','0','1','number','name');
Insert into T_BAS_IMPORTTEMPLATEENTRY (FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) values (685953223705722880,685952144846848012,685952144846848000,33,'supscope','受控的供应商','0',' ','0','1','number','name');