--主表
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1020955874300082176;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1020955874300082176,'1',1020955874300082176,'C','mds_productfamily_IMPT_S','IMPT','产品族',{ts'2018-08-08  18:08:08'},1,'1',{ts'2018-08-08  18:08:08'},' ',1,'mds_productfamily');

--分类
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1028785035647635467;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1','number',1020942866295371776,1028785035647635467,'materialplan',26,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866278693888;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','0',' ',0,1020942866278693888,'mds_productfamily',1,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866295371776;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','0',' ',1020942866278693888,1020942866295371776,'billhead',2,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866295471104;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1',' ',1020942866295371776,1020942866295471104,'id',3,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866295371777;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1','number',1020942866295371776,1020942866295371777,'materielitem',4,'1',' ','number',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866295471105;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1','number',1020942866295371776,1020942866295471105,'materielpbom',5,'0',' ','number',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866295371778;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1020942866295371778,'productfamily',7,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866295471106;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1',' ',1020942866295371776,1020942866295471106,'itemstatus',8,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866295371779;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1020942866295371779,'supmodel',9,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303859712;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1','name',1020942866295371776,1020942866303859712,'planuser',10,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303760384;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1020942866303760384,'bomtype',13,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303859713;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1020942866303859713,'remark',14,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303760385;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1020942866303760385,'planusercode',17,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303859714;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1',' ',1020942866295371776,1020942866303859714,'generaltag',15,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303760387;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1',' ',1020942866295371776,1020942866303760387,'status',18,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303859716;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1',' ',1020942866295371776,1020942866303859716,'enable',19,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303760388;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1','number',1020942866295371776,1020942866303760388,'creator',20,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020942866303859717;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1',' ',1020942866295371776,1020942866303859717,'createtime',21,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020992989721443337;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1020992989721443337,'offeringshow',6,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020992989721344009;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1020992989721344009,'pbomnameshow',12,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1020992989721443338;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1020992989721443338,'itemnameshow',16,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1022415393626695689;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1','number',1020942866295371776,1022415393626695689,'createorg',22,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1022415393626809353;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1','number',1020942866295371776,1022415393626809353,'useorg',23,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1022415393626695690;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1',' ',1020942866295371776,1022415393626695690,'ctrlstrategy',24,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1022415393626809354;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'0','1','number',1020942866295371776,1022415393626809354,'org',25,'0',' ','name',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1048706119725466628;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1048706119725466628,'approvedateshow',27,'0',' ',' ',NULL);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1048706119750507520;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1020955874300082176,'1','1',' ',1020942866295371776,1048706119750507520,'pbomnameedit',11,'0',' ',' ',NULL);
--多语言表
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '16D=7+5XHA79';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1020955874300082176,'16D=7+5XHA79','zh_CN',' ','产品族');
