DELETE FROM t_bas_importtemplate WHERE FID = 409830069813393408;
DELETE FROM t_bas_importtemplate_l WHERE FID = 409830069813393408;
DELETE FROM t_bas_importtemplateentry WHERE FID = 409830069813393408;

INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (409830069813393408,'1',409830069813393408,'A','bcm_changetypememberimp_IMPT_S',' ','IMPT',{ts'2018-08-08  18:08:08'},1,'1','0',{ts'2018-08-08  18:08:08'},' ',1,'bcm_changetypememberimp'); 

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (409830069813393408,'/9AEZOT=VIZY','zh_CN','出厂预置模板','变动类型导入模板'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828622652684288;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','0',NULL,0,409828622652684288,'bcm_changetypememberimp',1,'0',' ',' ','变动类型-导入'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627190921216;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','0',NULL,409828622652684288,409828627190921216,'billhead',2,'0',' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627190921217;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627190921217,'number',3,'1',' ',' ','编码*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627190921218;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627190921218,'name',4,'1',' ',' ','名称*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627190921219;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627190921219,'storagetype',5,'1',' ',' ','存储类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627190921220;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627190921220,'aggoprt',6,'0',' ',' ','聚合算法'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627190921221;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627190921221,'changeway',7,'0',' ',' ','变动方式'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627190921222;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627190921222,'isyearendchargeagaint',8,'0',' ',' ','是否年结冲销'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627190921223;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627190921223,'description',9,'0',' ',' ','说明'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627216087040;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1','number',409828627190921216,409828627216087040,'parent',10,'1',' ','name','上级*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627216087041;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627216087041,'definedpropertyvalue',11,'0',' ',' ','自定义属性值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627216087042;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1','number',409828627190921216,409828627216087042,'dimension',12,'1',' ','name','维度*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627216087043;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1','number',409828627190921216,409828627216087043,'model',13,'1',' ','name','体系*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409828627216087044;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',NULL,409828627190921216,409828627216087044,'longnumber',14,'0',' ',' ','长编码'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 873962583483357184;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'0','1',' ',409828627190921216,873962583483357184,'datatype',15,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',' ',409828627190921216,1039031203035983879,'memberpermissions',16,'0','数据格式：作用范围函数（用户类型，用户编码/用户组编码，读写权限）',' ',NULL); 
