-- 在sys库执行以下数据["库管员-物料关系设置引入模板"]
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1945576175355146240;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLESETNULL,FENABLEIMPORT,FMASTERID,FEXCHANGENAMEANDMARK,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FHIDEFIELDROW,FENABLE,FAPPLYSCOPE,FMODIFIERID,FSPLITSUBENTRIES,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FMODIFYTIME,FCREATORID,FBIZOBJECT) VALUES (1945576175355146240,'1','1',1945576175355146240,'0','C','im_invoperatormat_IMPT_S','库管员-物料关系设置引入模板','IMPT',{ts'2018-08-08  00:00:00'},'0','1','0',1,'0','0',' ',{ts'2018-08-08  00:00:00'},1,'im_invoperatormat'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '43+1JEJ2NAEO';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1945576175355146240,'43+1JEJ2NAEO','zh_CN','库管员-物料关系设置引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '43+1JEJ2NAEP';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1945576175355146240,'43+1JEJ2NAEP','zh_TW','庫管員-物料關係設置引入模板'); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051491389440;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051491389440,'0','0',' ',' ','0','0',' ',' ',0,'im_invoperatormat',1,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541722115;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051541722115,'0','1',' ',' ','0','1','dateformat6',' ',1945575051499779072,'createtime',15,'YYYY-MM-dd HH:mm:ss',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541722116;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051541722116,'0','1',' ',' ','0','1','dateformat6',' ',1945575051499779072,'modifytime',17,'YYYY-MM-dd HH:mm:ss',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051499779072;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051499779072,'0','0',' ',' ','0','0',' ',' ',1945575051491389440,'billhead',2,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051533332480;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051533332480,'0','0',' ',' ','0','1',' ',' ',1945575051499779072,'id',3,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051533333504;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051533333504,'1','0',' ',' ','1','1',' ',' ',1945575051499779072,'number',5,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051533332481;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051533332481,'1','0',' ',' ','1','1',' ',' ',1945575051499779072,'name',6,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051533333505;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051533333505,'1','0',' ',' ','1','1',' ',' ',1945575051499779072,'controldimension',7,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051550110720;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051550110720,'0','0',' ',' ','0','1',' ',' ',1945575051499779072,'status',18,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051558498304;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051558498304,'0','0',' ',' ','0','1',' ',' ',1945575051499779072,'description',19,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051558499328;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,' ',1945575051558499328,'0','0',' ',' ','0','1',' ',' ',1945575051499779072,'enable',20,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541721093;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541721093,'1','0',' ','name','1','1',' ',' ',1945575051499779072,'org',4,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541721088;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541721088,'0','0',' ','operatorname','1','1',' ',' ',1945575051499779072,'operator',8,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541722112;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541722112,'0','0',' ','name','1','1',' ',' ',1945575051499779072,'operatorgroup',9,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541721089;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541721089,'0','0',' ','name','1','1',' ',' ',1945575051499779072,'dept',10,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541722113;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541722113,'0','0',' ','name','1','1',' ',' ',1945575051499779072,'material',11,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541721090;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541721090,'0','0',' ','name','1','1',' ',' ',1945575051499779072,'materialgroup',12,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541722114;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541722114,'0','0',' ','name','0','1',' ',' ',1945575051499779072,'materialmasterid',13,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541721091;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541721091,'0','0',' ','name','0','1',' ',' ',1945575051499779072,'creator',14,' ',' '); 
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1945575051541721092;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (1945576175355146240,0,'number',1945575051541721092,'0','0',' ','name','0','1',' ',' ',1945575051499779072,'modifier',16,' ',' '); 

-- 在sys库执行编码规则
DELETE FROM T_CR_CODERULE WHERE FID = '42T9859KOX96';
INSERT INTO T_CR_CODERULE(FFILTERCONDITION,FISMATCHCODERULE,FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FISUNIQUE,FMASTERID,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FISUPDATERECOVER,FENABLE,FISAPPORG,FISSERIALNUMBER,FISCHECKNUMBER,FISCHECKCODE,FID,FCTRLMODE,FSPLITSIGN,FISFILLWITHZERO,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID,FCONDITIONDESC) VALUES (' ','0',' ','2','1','0','0','42T9859KOX96','1',{ts'2024-05-06  00:00:00'},'im_invoperatormat','0','1','1','1','0','0','42T9859KOX96','1','-','1','0','C','42T931E8J2E9',' ','1',13466739,'0',{ts'2024-05-13  00:00:00'},0,' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '43FDQ0K07X++';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('42T9859KOX96',1,'1',' ','0','43FDQ0K07X++','1',1,'1',0,8,'1','INVOP','1',' ','0',' ',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '43FDQ0K07X+/';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('42T9859KOX96',1,'1','-','0','43FDQ0K07X+/','1',1,' ',1,8,'1','MAT','1',' ','1',' ',' '); 
DELETE FROM T_CR_CODERULEENTRY WHERE FENTRYID = '43FDQ0K07X+0';
INSERT INTO T_CR_CODERULEENTRY(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FCUTSTYLE,FSTEP,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FADDSTYLE,FSETTINGVALUE,FISSPLITSIGN,FVALUEATRIBUTE,FADDCHAR) VALUES ('42T9859KOX96',1,'16','-','0','43FDQ0K07X+0','1',1,' ',2,8,'1',' ','1',' ','1',' ',' '); 
DELETE FROM T_CR_CODERULE_l WHERE FPKID = '42T9859O98+O';
INSERT INTO T_CR_CODERULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('42T9859KOX96','42T9859O98+O','zh_CN','库管员-物料关系设置'); 
