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  00:00:00'},13466739,'1','0',{ts'2021-10-11  00:00:00'},' ',1,'bcm_changetypememberimp'); 

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

INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'0','0',NULL,0,409828622652684288,'bcm_changetypememberimp',1,'0',' ',' ','变动类型-导入'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'0','0',NULL,409828622652684288,409828627190921216,'billhead',2,'0',' ',' ','单据头'); 
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',4,'1',' ',' ','编码*'); 
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',5,'1',' ',' ','名称*'); 
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',6,'1',' ',' ','存储类型'); 
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',7,'0',' ',' ','聚合算法'); 
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',8,'0',' ',' ','变动方式'); 
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',9,'0',' ',' ','是否年结冲销'); 
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',10,'0',' ',' ','说明'); 
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',11,'1',' ','name','上级*'); 
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',13,'1',' ','name','维度*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'0','1',' ',409828627190921216,1082436394707584001,'id',3,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1','number',409828627190921216,1083951004732411912,'enumitem',19,'0',' ','name',NULL); 
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',12,'0',' ',' ','自定义属性值'); 
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',' ',' ','长编码'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','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,1082436394715972614,'ismerge',17,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',' ',409828627190921216,1082721439406107656,'isexchange',18,'1',' ',' ',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); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'0','1',' ',409828627190921216,1264466496470386697,'sectoryclass',20,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409830069813393408,'1','1',' ',409828627190921216,1264466496470387721,'shielddim',21,'0','请填写维度简码并用英文逗号(,)分割',' ',NULL); 
