/* 成本中心引入模板 */
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 981940931324530688;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (981940931324530688,'1',981940931324530688,'C','bos_costcenter','成本中心引入模板','IMPT',{ts'2020-09-16  19:39:46'},1,'1',{ts'2020-09-18  13:55:11'},' ',1,'bos_costcenter'); 

DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '11LCEU=SPNLT';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (981940931324530688,'11LCEU=SPNLT','zh_CN','系统预置模板','成本中心引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '11LCEU=SPNLU';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (981940931324530688,'11LCEU=SPNLU','zh_TW','係統預置模板','成本中心引入模板'); 

/* 删除脏数据 */
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126739351552 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126814842880 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126823237632 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126840008704 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126865180672 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126881951744 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126890346496 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126907117568 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126923900928 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127527874560 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127544657920 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127603372032 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127636932608 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127653703680 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147954371585 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147954372609 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147954371586 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147954372610 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147954371587 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940148096978944 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940148096977920 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940148096977921 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147895651328 AND FID = 981940931324530688; 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147945984000 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147954371584 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 981940147954372608 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 983215975363273729 AND FID = 981940931324530688;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 983215975363305474 AND FID = 981940931324530688;


DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126739351552;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'0','0',' ',0,986036126739351552,'bos_costcenter',1,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126814842880;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'0','0',' ',986036126739351552,986036126814842880,'billhead',2,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126823237632;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'0','1',' ',986036126814842880,986036126823237632,'id',3,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126840008704;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'1','1',' ',986036126814842880,986036126840008704,'number',4,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126865180672;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'1','1',' ',986036126814842880,986036126865180672,'name',5,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126881951744;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'1','1','number',986036126814842880,986036126881951744,'parent',6,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126907117568;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'1','1','number',986036126814842880,986036126907117568,'accountorg',8,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036126923900928;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'1','1',' ',986036126814842880,986036126923900928,'description',9,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127527874560;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'0','0',' ',986036126739351552,986036127527874560,'entryentity',10,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127544657920;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'0','1',' ',986036127527874560,986036127544657920,'entryentity.id',11,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127603372032;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'0','1','number',986036127527874560,986036127603372032,'sourcetype',12,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127636932608;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'1','1',' ',986036127527874560,986036127636932608,'sourcetypeobj',13,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986036127653703680;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'1','1','number',986036127527874560,986036127653703680,'data',14,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 986174303840022532;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (981940931324530688,'1','1',' ',986036126814842880,986174303840022532,'showorgduty',7,'1',' ',' ',NULL); 




