--预置部门分配业务单元引入模板
DELETE FROM t_bas_importtemplate WHERE FID = 1812361661464637440;
INSERT INTO t_bas_importtemplate(FID,FENABLESETNULL,FENABLEIMPORT,FMASTERID,FEXCHANGENAMEANDMARK,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FHIDEFIELDROW,FMODIFIERID,FENABLE,FAPPLYSCOPE,FSPLITSUBENTRIES,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1812361661464637440,'1','1',1812361661464637440,'0','C','bos_org_relation_deptunit_IMPT_S','IMPT','部门分配业务单元引入模板',{ts'2023-11-06  00:00:00'},'0',13466739,'1','0','0','0',' ',{ts'2023-11-06  00:00:00'},' ',13466739,'bos_org_orgrelation_dept'); 


DELETE FROM t_bas_importtemplate_l WHERE FPKID = '3OLV+KZXIXCH';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1812361661464637440,'3OLV+KZXIXCH','zh_CN','系统预置，仅部门分配业务单元使用','部门分配业务单元引入模板'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1812358134566678534;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1812361661464637440,'0','number',1812358134566678534,'0','0',' ','name','0','1',' ',' ',1812358134566678529,'orgduty',8,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1812358135312306178;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1812361661464637440,'0',' ',1812358135312306178,'0','0',' ',' ','1','1',' ',' ',1812358134566678529,'isdefaultfromorg',6,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1812358134566678528;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1812361661464637440,'0',' ',1812358134566678528,'0','0',' ',' ','0','0',' ',' ',0,'bos_org_orgrelation_dept',1,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1812358134566678529;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1812361661464637440,'0',' ',1812358134566678529,'0','0',' ',' ','0','0',' ',' ',1812358134566678528,'billhead',2,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1812358134566678530;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1812361661464637440,'0',' ',1812358134566678530,'0','0',' ',' ','1','1',' ',' ',1812358134566678529,'id',3,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1812358134566678533;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1812361661464637440,'0',' ',1812358134566678533,'0','0',' ',' ','0','1',' ',' ',1812358134566678529,'isdefaulttoorg',7,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1812358134566678531;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1812361661464637440,'0','number',1812358134566678531,'1','0',' ','name','1','1',' ',' ',1812358134566678529,'fromorg',5,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1812358134566678532;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1812361661464637440,'0','number',1812358134566678532,'1','0',' ','name','1','1',' ',' ',1812358134566678529,'toorg',4,NULL,' ',' '); 


--修改预置业务单元分配部门引入模板
DELETE FROM t_bas_importtemplate WHERE FID = 1581807165889361920;
INSERT INTO t_bas_importtemplate(FID,FENABLESETNULL,FENABLEIMPORT,FMASTERID,FEXCHANGENAMEANDMARK,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FHIDEFIELDROW,FMODIFIERID,FENABLE,FAPPLYSCOPE,FSPLITSUBENTRIES,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1581807165889361920,'1','1',1581807165889361920,'0','C','bos_org_orgrelation_dept_IMPT_S','IMPT','业务单元分配部门引入模板',{ts'2022-12-23  00:00:00'},'0',13466739,'1','0','0','0',' ',{ts'2023-01-30  00:00:00'},' ',13466739,'bos_org_orgrelation_dept'); 

DELETE FROM t_bas_importtemplate_l WHERE FID = 1581807165889361920;
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1581807165889361920,'2Z=9VRDT9+IG','zh_CN','系统预置，仅业务单元分配部门使用','业务单元分配部门引入模板'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1581806672295279616;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1581807165889361920,'0',' ',1581806672295279616,'0','0',' ',' ','1','0',' ',' ',0,'bos_org_orgrelation_dept',1,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1581806672353998848;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1581807165889361920,'0',' ',1581806672353998848,'0','0',' ',' ','1','0',' ',' ',1581806672295279616,'billhead',2,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1581806672370777088;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1581807165889361920,'0',' ',1581806672370777088,'0','0',' ',' ','1','1',' ',' ',1581806672353998848,'id',3,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1581806672379164672;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1581807165889361920,'0','number',1581806672379164672,'1','0',' ','name','1','1',' ',' ',1581806672353998848,'fromorg',4,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1581806672387554304;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1581807165889361920,'0','number',1581806672387554304,'1','0',' ','name','1','1',' ',' ',1581806672353998848,'toorg',5,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1581806672395941888;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1581807165889361920,'0',' ',1581806672395941888,'0','0',' ',' ','1','1',' ',' ',1581806672353998848,'isdefaulttoorg',6,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1581806672404331520;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1581807165889361920,'0','number',1581806672404331520,'0','0',' ','name','1','1',' ',' ',1581806672353998848,'orgduty',7,NULL,' ',' '); 