/* 预置组织和人员的引入模板 */
delete from t_bas_importtemplate where fnumber in ('bos_user_IMPT_S','bos_org_IMPT_S','bos_adminorg_IMPT_S','bos_adminorg_structure_IMPT_S');
delete from t_bas_importtemplate_l where fid in (select fid from t_bas_importtemplate where fnumber in ('bos_user_IMPT_S','bos_org_IMPT_S','bos_adminorg_IMPT_S','bos_adminorg_structure_IMPT_S'));
delete from t_bas_importtemplateentry where fid in (select fid from t_bas_importtemplate where fnumber in ('bos_user_IMPT_S','bos_org_IMPT_S','bos_adminorg_IMPT_S','bos_adminorg_structure_IMPT_S'));

DELETE FROM t_bas_importtemplate WHERE FID = 1025998177959970816;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1025998177959970816,'1',1025998177959970816,'C','bos_adminorg_IMPT_S','行政组织','IMPT',{ts'2018-08-08  18:08:08'},1,'1','0',{ts'2018-08-08  18:08:08'},' ',1,'bos_adminorg');
DELETE FROM t_bas_importtemplate WHERE FID = 678158543513261056;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (678158543513261056,'1',678158543513261056,'C','bos_adminorg_structure_IMPT_S','行政组织结构','IMPT',{ts'2018-08-08  18:08:08'},1,'1','0',{ts'2018-08-08  18:08:08'},' ',1,'bos_adminorg_structure');
DELETE FROM t_bas_importtemplate WHERE FID = 1021012548306087936;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1021012548306087936,'1',1021012548306087936,'C','bos_org_IMPT_S','业务单元','IMPT',{ts'2018-08-08  18:08:08'},1,'1','0',{ts'2018-08-08  18:08:08'},' ',1,'bos_org');
DELETE FROM t_bas_importtemplate WHERE FID = 678191414810548224;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (678191414810548224,'1',678191414810548224,'C','bos_user_IMPT_S','人员','IMPT',{ts'2018-08-08  18:08:08'},1,'1','0',{ts'2018-08-08  18:08:08'},' ',1,'bos_user');

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '03=++OVFMD87';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (678158543513261056,'03=++OVFMD87','zh_CN','预置模板（按长名称）','行政组织结构');
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '03=447ME6JKE';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (678191414810548224,'03=447ME6JKE','zh_CN','预置模板','人员');
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '17/FB9UD5+TH';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1025998177959970816,'17/FB9UD5+TH','zh_CN','预置模板','行政组织');
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '16DJSZHDS9J2';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1021012548306087936,'16DJSZHDS9J2','zh_CN','预置模板（按职能类型）','业务单元');

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1025997811419745280;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1025998177959970816,'0','0',' ',0,1025997811419745280,'bos_adminorg',1,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1025997811444910080;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1025998177959970816,'0','0',' ',1025997811419745280,1025997811444910080,'billhead',2,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1025997811453299712;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1025998177959970816,'0','1',' ',1025997811444910080,1025997811453299712,'id',3,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1025997811453298688;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1025998177959970816,'1','1',' ',1025997811444910080,1025997811453298688,'number',4,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1025997811453299713;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1025998177959970816,'1','1',' ',1025997811444910080,1025997811453299713,'name',5,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1025997811453298689;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1025998177959970816,'1','1','number',1025997811444910080,1025997811453298689,'orgpattern',6,'0','参照“行政组织”新增页面的“形态”；新增未填写时默认为“部门”','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1025997811453299714;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1025998177959970816,'1','1','number',1025997811444910080,1025997811453299714,'parent',7,'1','按照上下级关系排序，上级的数据须在前面','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1025997811453298690;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1025998177959970816,'1','1',' ',1025997811444910080,1025997811453298690,'fcomment',8,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 678661489996894208;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678158543513261056,'1','0',' ',0,678661489996894208,'bos_adminorg_structure',1,'0','引入数据按照组织架构层级排序，上级组织在前',' ','行政组织结构');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 678661490105944064;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678158543513261056,'1','0',' ',678661489996894208,678661490105944064,'billhead',2,'0',' ',' ','单据头');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 678661490105944065;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678158543513261056,'1','1',' ',678661490105944064,678661490105944065,'fullname',5,'1','包含本组织名称以及所有上级的名称，组织层级间用下横线"_"隔开：如，某某公司_某某事业部_某某部门',' ','长名称*');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 678661490105944066;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678158543513261056,'1','1',' ',678661490105944064,678661490105944066,'comment',7,'0',' ',' ','描述');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 678661490105946112;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678158543513261056,'1','1','number',678661490105944064,678661490105946112,'org',4,'0','填写组织的编码。为空时，根据编码规则自动填写','name','组织');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 678661490105946113;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678158543513261056,'1','1','number',678661490105944064,678661490105946113,'orgpattern',6,'0','参照“行政组织”新增页面的“形态”；新增未填写时默认为“部门”','name','形态');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1026865321270599680;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678158543513261056,'0','1',' ',678661490105944064,1026865321270599680,'id',3,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210438138880;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','0',' ',0,1021012210438138880,'bos_org',1,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677952;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','0',' ',1021012210438138880,1021012210471677952,'billhead',2,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693312;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471693312,'id',4,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677953;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'1','1',' ',1021012210471677952,1021012210471677953,'number',5,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693313;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'1','1',' ',1021012210471677952,1021012210471693313,'name',6,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677954;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1','number',1021012210471677952,1021012210471677954,'country',10,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693314;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1','number',1021012210471677952,1021012210471693314,'city',11,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677955;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1','number',1021012210471677952,1021012210471677955,'timezone',12,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693315;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471693315,'postcode',13,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677956;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471677956,'contactphone',14,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693316;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471693316,'contactaddress',15,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677957;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471677957,'simplename',16,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693317;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'1','1','number',1021012210471677952,1021012210471693317,'orgpattern',8,'0','参照“业务单元”新增页面的“形态”；新增未填写时默认为“公司”','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677958;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'1','1','number',1021012210471677952,1021012210471677958,'parent',7,'1','按照上下级关系排序，上级的数据须在前面','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693318;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'1','1',' ',1021012210471677952,1021012210471693318,'fcomment',9,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693347;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471693347,'uniformsocialcreditcode',17,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677988;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471677988,'ffirmname',18,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693348;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471693348,'ffirmtype',19,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677989;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471677989,'frepresentative',20,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471693349;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471693349,'faddress',21,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210471677990;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210471677990,'registeredcapital',22,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210480081920;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210480081920,'establishmentdate',23,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210480066560;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210480066560,'businessterm',24,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210480081921;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210480081921,'fbizscope',25,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210480066561;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210480066561,'ftaxregnum',26,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210480081922;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210480081922,'phone',27,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210480066562;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210480066562,'depositbank',28,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1021012210480081923;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'0','1',' ',1021012210471677952,1021012210480081923,'bankaccount',29,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1026731181455966211;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1021012548306087936,'1','1','number',1021012210471677952,1026731181455966211,'orgbizfunction',3,'1','通过“组织职能类型”菜单进入查询列表获取','fname',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026691585;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026691585,'phone',11,'0','手机或者邮箱至少录入一项',' ','手机');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026718210;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026718210,'email',12,'0','手机或者邮箱至少录入一项',' ','邮箱');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1020970356904570880;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,1020970356904570880,'id',3,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1020970356921363459;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,1020970356921363459,'externaluuid',16,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1020970356938140672;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724026718212,1020970356938140672,'entryentity.id',18,'0','执行更新时，需要根据“引入模板”引出“内码”',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1020970356971695104;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','0',' ',763608724001552384,1020970356971695104,'contactentity',24,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1020970356971679744;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',1020970356971695104,1020970356971679744,'contactentity.id',25,'0','执行更新时，需要根据“引入模板”引出“内码”',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1020970356971695105;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',1020970356971695104,1020970356971695105,'contact',26,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1020970356971679745;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1','number',1020970356971695104,1020970356971679745,'contacttype',27,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1020970356971695106;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',1020970356971695104,1020970356971695106,'isdefault',28,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724001552384;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','0',' ',0,763608724001552384,'bos_user',1,'0',' ',' ','人员');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724018302976;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','0',' ',763608724001552384,763608724018302976,'billhead',2,'0',' ',' ','单据头');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724018329600;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724018329600,'picturefield',4,'0',' ',' ','人员头像');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724018302977;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724018302977,'name',5,'1',' ',' ','姓名*');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724018329601;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724018329601,'simplepinyin',6,'0',' ',' ','姓名简拼');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724018302978;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724018302978,'fullpinyin',7,'0',' ',' ','姓名全拼');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026718208;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724026718208,'username',8,'0',' ',' ','用户名');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026691584;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'0','1',' ',763608724018302976,763608724026691584,'usertype',9,'0',' ',' ','类型*');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026718209;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026718209,'number',10,'1',' ',' ','工号*');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026691586;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026691586,'idcard',13,'0',' ',' ','身份证号');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026718211;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026718211,'birthday',14,'0',' ',' ','生日');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026691587;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724018302976,763608724026691587,'gender',15,'0',' ',' ','性别');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724026718212;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','0',' ',763608724001552384,763608724026718212,'entryentity',17,'0',' ',' ','单据体');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724035080192;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1','number',763608724026718212,763608724035080192,'dpt',19,'1',' ','name','部门*');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724035106816;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724026718212,763608724035106816,'position',20,'1',' ',' ','职位*');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724035080193;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724026718212,763608724035080193,'isincharge',21,'0',' ',' ','负责人');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724035106817;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1',' ',763608724026718212,763608724035106817,'ispartjob',22,'0',' ',' ','兼职');
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 763608724035080194;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (678191414810548224,'1','1','number',763608724026718212,763608724035080194,'superior',23,'0',' ','name','直接上级');
