-- 销售员-物料可销控制引入模板
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1627469664235817984;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1627469664235817984,'1',1627469664235817984,'C','msbd_salopermaterctrl_IMPT_default','销售员-物料可销控制引入模板','IMPT',{ts'2018-08-08  00:00:00'},1625950775484331008,'1',{ts'2023-02-24  00:00:00'},' ',13466739,'msbd_salopermaterctrl'); 


DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '32X0PLCEXPHE';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1627469664235817984,'32X0PLCEXPHE','zh_CN','系统预置模板','销售员-物料可销控制引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '32X0PLCEXPHF';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1627469664235817984,'32X0PLCEXPHF','zh_TW','係統預置模板','銷售員-物料可銷控製引入模板'); 


DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045810859008;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'0','0',' ',0,1627469045810859008,'msbd_salopermaterctrl',1,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045819370496;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'0','0',' ',1627469045810859008,1627469045819370496,'billhead',2,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045819247616;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'0','1',' ',1627469045819370496,1627469045819247616,'id',3,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045819370497;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1',' ',1627469045819370496,1627469045819370497,'number',5,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045819247617;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1',' ',1627469045819370496,1627469045819247617,'name',6,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045819370498;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1',' ',1627469045819370496,1627469045819370498,'controldimension',7,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045819247618;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1',' ',1627469045819370496,1627469045819247618,'controltype',8,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045819247619;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1',' ',1627469045819370496,1627469045819247619,'description',9,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852924928;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'0','0',' ',1627469045810859008,1627469045852924928,'entryentity',10,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852802048;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'0','1',' ',1627469045852924928,1627469045852802048,'entryentity.id',11,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045819370499;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1','number',1627469045819370496,1627469045819370499,'org',4,'1',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852924929;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1','number',1627469045852924928,1627469045852924929,'operator',12,'0',' ','operatorname',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852802049;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1','number',1627469045852924928,1627469045852802049,'operatorgroup',13,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852924930;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1','number',1627469045852924928,1627469045852924930,'dept',14,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852802050;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'0','1','number',1627469045852924928,1627469045852802050,'customer',15,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852924931;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'0','1','number',1627469045852924928,1627469045852924931,'customergroup',16,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852802051;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1','number',1627469045852924928,1627469045852802051,'material',17,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627469045852924932;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627469664235817984,'1','1','number',1627469045852924928,1627469045852924932,'materialgroup',18,'0',' ','name',NULL); 

-- 销售员-客户可销控制引入模板
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1627540320952642560;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1627540320952642560,'1',1627540320952642560,'C','msbd_salopercusctrl_IMPT_default','销售员-客户可销控制引入模板','IMPT',{ts'2018-08-08  00:00:00'},1625950775484331008,'1',{ts'2018-08-08  00:00:00'},' ',13466739,'msbd_salopercusctrl'); 

DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '32XCXGG0EXSH';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1627540320952642560,'32XCXGG0EXSH','zh_CN','系统预置模板','销售员-客户可销控制引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '32XCXGG0EXSI';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1627540320952642560,'32XCXGG0EXSI','zh_TW','係統預置模板','銷售員-客戶可銷控製引入模板'); 

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546390400000;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'0','0',' ',0,1627539546390400000,'msbd_salopercusctrl',1,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546390522880;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'0','0',' ',1627539546390400000,1627539546390522880,'billhead',2,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546398788608;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'0','0',' ',1627539546390522880,1627539546398788608,'id',3,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546398911490;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1','number',1627539546390522880,1627539546398911490,'org',4,'1',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546398911488;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1',' ',1627539546390522880,1627539546398911488,'number',5,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546398788609;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1',' ',1627539546390522880,1627539546398788609,'name',6,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546398911489;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1',' ',1627539546390522880,1627539546398911489,'controldimension',7,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546398788610;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1',' ',1627539546390522880,1627539546398788610,'controltype',8,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546398788611;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1',' ',1627539546390522880,1627539546398788611,'description',9,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546415688704;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'0','0',' ',1627539546390400000,1627539546415688704,'entryentity',10,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546423954432;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'0','0',' ',1627539546415688704,1627539546423954432,'entryentity.id',11,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546424077312;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1','number',1627539546415688704,1627539546424077312,'operator',12,'0',' ','operatorname',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546423954433;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1','number',1627539546415688704,1627539546423954433,'operatorgroup',13,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546424077313;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1','number',1627539546415688704,1627539546424077313,'dept',14,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546423954434;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1','number',1627539546415688704,1627539546423954434,'customer',15,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546424077314;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'1','1','number',1627539546415688704,1627539546424077314,'customergroup',16,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546423954435;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'0','1','number',1627539546415688704,1627539546423954435,'material',17,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627539546424077315;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627540320952642560,'0','1','number',1627539546415688704,1627539546424077315,'materialgroup',18,'0',' ','name',NULL); 

-- 客户-物料可销控制引入模板
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1627562490902735872;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1627562490902735872,'1',1627562490902735872,'C','msbd_cusmaterctrl_IMPT_default','客户-物料可销控制引入模板','IMPT',{ts'2018-08-08  00:00:00'},1625950775484331008,'1',{ts'2018-08-08  00:00:00'},' ',13466739,'msbd_cusmaterctrl'); 


DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '32XH10+I249B';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1627562490902735872,'32XH10+I249B','zh_CN','系统预置模板','客户-物料可销控制引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '32XH10+I249C';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1627562490902735872,'32XH10+I249C','zh_TW','係統預置模板','客戶-物料可銷控製引入模板'); 


DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972380160;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'0','0',' ',0,1627561810972380160,'msbd_cusmaterctrl',1,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972503040;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'0','0',' ',1627561810972380160,1627561810972503040,'billhead',2,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972380161;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'0','0',' ',1627561810972503040,1627561810972380161,'id',3,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972503043;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1','number',1627561810972503040,1627561810972503043,'org',4,'1',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972503041;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1',' ',1627561810972503040,1627561810972503041,'number',5,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972380162;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1',' ',1627561810972503040,1627561810972380162,'name',6,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972503042;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1',' ',1627561810972503040,1627561810972503042,'controldimension',7,'1',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972380163;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1',' ',1627561810972503040,1627561810972380163,'controltype',8,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810972380164;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1',' ',1627561810972503040,1627561810972380164,'description',9,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561810989280256;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'0','0',' ',1627561810972380160,1627561810989280256,'entryentity',10,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561811005934592;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'0','0',' ',1627561810989280256,1627561811005934592,'entryentity.id',11,'0',' ',' ',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561811006057472;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'0','1','number',1627561810989280256,1627561811006057472,'operator',12,'0',' ','operatorname',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561811005934593;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'0','1','number',1627561810989280256,1627561811005934593,'operatorgroup',13,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561811006057473;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'0','1','number',1627561810989280256,1627561811006057473,'dept',14,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561811005934594;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1','number',1627561810989280256,1627561811005934594,'customer',15,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561811006057474;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1','number',1627561810989280256,1627561811006057474,'customergroup',16,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561811005934595;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1','number',1627561810989280256,1627561811005934595,'material',17,'0',' ','name',NULL); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1627561811006057475;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1627562490902735872,'1','1','number',1627561810989280256,1627561811006057475,'materialgroup',18,'0',' ','name',NULL); 
