
--预置组织协作按委托组织引入模板
DELETE FROM t_bas_importtemplate WHERE FID = 1804555011989577728;
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 (1804555011989577728,'1','1',1804555011989577728,'0','C','bos_org_orgrelation_IMPT_From2To','IMPT','组织协作按委托组织引入模板',{ts'2023-10-26  00:00:00'},'0',13466739,'1','0','0','0','[{"FPK":"","Type":0,"Description":"组织协作引入模板插件","RowKey":0,"ClassName":"kd.bos.org.duty.OrgRelationImportTemplatePlugin","DisplayName":"","Enabled":true,"BizAppId":"","Inherit":false}]',{ts'2023-12-01  00:00:00'},' ',13466739,'bos_org_orgrelation'); 


DELETE FROM t_bas_importtemplate_l WHERE FID = 1804555011989577728;
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1804555011989577728,'3NNESGMFVWCI','zh_CN','系统预置，仅按委托组织引入使用','组织协作按委托组织引入模板'); 


DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804550842776481793;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804555011989577728,'0','number',1804550842776481793,'1','0','{"zh_TW":{"number":"","name":""},"en_US":{"number":"","name":""},"zh_CN":{"number":"[accounting2scc：核算组织委托共享中心][sale2inventory：销售委托库存发货][org2purchase：需求委托采购][purchase2inventory：采购委托库存收货][accounting2inventory：核算组织委托库存保管][inventory2inventory：库存调拨委托][org2qcc：需求委托质检][accounting2capital：核算组织委托资金管理][accounting2asset：核算组织委托资产管理][sale2accounting：销售组织委托结算][Accounting_TO_Production_S：核算组织委托生产协作][Production_TO_Inventory_S：生产委托库存供应][orgunit2accounting：采购组织委托结算][orgunit2tax：核算组织委托税务管理][tax2accounting：税务组织委托结算]","name":""},"DE":{"number":"","name":""}}','name','1','1',' ',' ',1804550842776481792,'typerelation',4,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804550842767515648;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804555011989577728,'0',' ',1804550842767515648,'0','0',' ',' ','0','0',' ',' ',0,'bos_org_orgrelation',1,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804550842776481792;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804555011989577728,'0',' ',1804550842776481792,'0','0',' ',' ','0','0',' ',' ',1804550842767515648,'billhead',2,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804550842775904256;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804555011989577728,'0',' ',1804550842775904256,'0','0',' ',' ','1','1',' ',' ',1804550842776481792,'id',3,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804550842775904258;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804555011989577728,'0',' ',1804550842775904258,'0','0',' ',' ','1','1',' ',' ',1804550842776481792,'isdefaulttoorg',7,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804550842776481795;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804555011989577728,'0',' ',1804550842776481795,'0','0',' ',' ','0','1',' ',' ',1804550842776481792,'isdefaultfromorg',8,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804550842776481794;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804555011989577728,'0','number',1804550842776481794,'1','0',' ','name','1','1',' ',' ',1804550842776481792,'fromorg',5,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804550842775904257;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804555011989577728,'0','number',1804550842775904257,'1','0',' ','name','1','1',' ',' ',1804550842776481792,'toorg',6,NULL,' ',' '); 



--预置组织协作按受托组织引入模板

DELETE FROM t_bas_importtemplate WHERE FID = 1804551989323034624;
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 (1804551989323034624,'1','1',1804551989323034624,'0','C','bos_org_orgrelation_IMPT_To2From','IMPT','组织协作按受托组织引入模板',{ts'2023-10-26  00:00:00'},'0',13466739,'1','0','0','0','[{"FPK":"","Type":0,"Description":"组织协作引入模板插件","RowKey":0,"ClassName":"kd.bos.org.duty.OrgRelationImportTemplatePlugin","DisplayName":"","Enabled":true,"BizAppId":"","Inherit":false}]',{ts'2023-12-01  00:00:00'},' ',13466739,'bos_org_orgrelation'); 


DELETE FROM t_bas_importtemplate_l WHERE FID = 1804551989323034624;
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1804551989323034624,'3NNFBHJD22VQ','zh_CN','系统预置，仅按受托组织引入使用','组织协作按受托组织引入模板'); 


DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804554561101897728;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804551989323034624,'0',' ',1804554561101897728,'0','0',' ',' ','0','0',' ',' ',0,'bos_org_orgrelation',1,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804554561102475264;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804551989323034624,'0',' ',1804554561102475264,'0','0',' ',' ','0','0',' ',' ',1804554561101897728,'billhead',2,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804554561101897729;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804551989323034624,'0',' ',1804554561101897729,'0','0',' ',' ','1','1',' ',' ',1804554561102475264,'id',3,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804554561101897731;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804551989323034624,'0',' ',1804554561101897731,'0','0',' ',' ','0','1',' ',' ',1804554561102475264,'isdefaulttoorg',8,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804554561102475267;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804551989323034624,'0',' ',1804554561102475267,'0','0',' ',' ','1','1',' ',' ',1804554561102475264,'isdefaultfromorg',7,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804554561102475265;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804551989323034624,'0','number',1804554561102475265,'1','0','{"zh_TW":{"number":"","name":""},"en_US":{"number":"","name":""},"zh_CN":{"number":"[accounting2scc：核算组织委托共享中心][sale2inventory：销售委托库存发货][org2purchase：需求委托采购][purchase2inventory：采购委托库存收货][accounting2inventory：核算组织委托库存保管][inventory2inventory：库存调拨委托][org2qcc：需求委托质检][accounting2capital：核算组织委托资金管理][accounting2asset：核算组织委托资产管理][sale2accounting：销售组织委托结算][Accounting_TO_Production_S：核算组织委托生产协作][Production_TO_Inventory_S：生产委托库存供应][orgunit2accounting：采购组织委托结算][orgunit2tax：核算组织委托税务管理][tax2accounting：税务组织委托结算]","name":""},"DE":{"number":"","name":""}}','name','1','1',' ',' ',1804554561102475264,'typerelation',4,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804554561101897730;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804551989323034624,'0','number',1804554561101897730,'1','0',' ','name','1','1',' ',' ',1804554561102475264,'toorg',5,NULL,' ',' '); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1804554561102475266;
INSERT INTO t_bas_importtemplateentry(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1804551989323034624,'0','number',1804554561102475266,'1','0',' ','name','1','1',' ',' ',1804554561102475264,'fromorg',6,NULL,' ',' '); 
