/**组织导入模板预置**/
delete from T_BAS_IMPORTTEMPLATE where fid = 772300762582738944;
delete from T_BAS_IMPORTTEMPLATE_L where fid = 772300762582738944;
delete from T_BAS_IMPORTTEMPLATEENTRY where fid = 772300762582738944;

INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (772300762582738944,'1',772300762582738944,'C','bcm_entitymemberimp_IMPT_S',' ','IMPT',{ts'2018-08-08  18:08:08'},1,'1',{ts'2018-08-08  18:08:08'},' ',1,'bcm_entitymemberimp'); 

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (772300762582738944,'0DV/1ES2QG7G','zh_CN','出厂预置模板','组织导入模板'); 


INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','0',' ',0,772298295803504640,'bcm_entitymemberimp',1,'0',' ',' ','组织-导入'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','0',' ',772298295803504640,772298295811886080,'billhead',2,'0',' ',' ','单据头'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893248,'number',3,'1',' ',' ','编码*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886081,'name',4,'1',' ',' ','名称*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893249,'simplename',5,'0',' ',' ','简称'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886082,'storagetype',6,'1',' ',' ','存储类型*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893250,'aggoprt',7,'0',' ',' ','聚合算法'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811886083,'ctrlorg',8,'0',' ','name','控股组织'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886084,'isinnerorg',10,'0',' ',' ','内部往来组织'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893252,'isouterorg',11,'0',' ',' ','外部往来组织'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886085,'isindependentorg',12,'0',' ',' ','是否独立法人公司'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893253,'effdate',13,'0',' ',' ','生效日期'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886086,'expdate',14,'0',' ',' ','失效日期'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893254,'isclearorg',15,'0',' ',' ','是否清算'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886087,'description',16,'0',' ',' ','说明'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811893255,'parent',17,'1',' ','name','上级*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811886088,'model',18,'1',' ','name','体系*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811893256,'dimension',19,'1',' ','name','维度*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886089,'definedpropertyvalue',20,'0',' ',' ','自定义属性值'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811893251,'currency',9,'1',' ','name','默认币别'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,873962862454862850,'cslscheme',21,'1',' ','name','组织视图'); 


/**科目导入模板预置**/

delete from T_BAS_IMPORTTEMPLATE where fid = 409827330681223168;
delete from T_BAS_IMPORTTEMPLATE_L where fid = 409827330681223168;
delete from T_BAS_IMPORTTEMPLATEENTRY where fid = 409827330681223168;

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

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (409827330681223168,'/9AEFQC41NDN','zh_CN','出厂预置模板','科目导入模板'); 

INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','0',NULL,0,409827147658573824,'bcm_accountmemberimp',1,'0',' ',' ','科目-导入'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','0',NULL,409827147658573824,409827148245776384,'billhead',2,'0',' ',' ','单据头'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148254164992,'name',3,'1',' ',' ','名称*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148262553600,'number',4,'1',' ',' ','编码*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148262553601,'simplename',5,'0',' ',' ','别名'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','number',409827148245776384,409827148279330816,'parent',6,'1',' ','name','上级*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148279330817,'storagetype',7,'1',' ',' ','存储类型'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148279330818,'aggoprt',8,'0',' ',' ','聚合算法'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148279330820,'accounttype',10,'0',' ',' ','科目类型'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148279330821,'drcrdirect',11,'0',' ',' ','借贷算法'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108032,'datatype',12,'0',' ',' ','数据类型'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108033,'value',13,'0',' ',' ','枚举'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108034,'exchange',14,'0',' ',' ','折算汇率'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108035,'isparticipmerge',15,'0',' ',' ','是否参与合并'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108036,'isrelateorg',16,'0',' ',' ','是否关联往来组织'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148304496640,'isyearendcarried',17,'0',' ',' ','年结时是否自动结转'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148304496641,'islosscarry',18,'0',' ',' ','是否损益年结科目'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','number',409827148245776384,409827148304496642,'losscarryto',19,'0',' ','name','年度结转至科目'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148304496643,'description',20,'0',' ',' ','说明'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148312885248,'longnumber',21,'0',' ',' ','长编码'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','number',409827148245776384,409827148312885249,'dimension',22,'1',' ','name','维度*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','number',409827148245776384,409827148312885250,'model',23,'1',' ','name','体系*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148312885251,'definedpropertyvalue',24,'0',' ',' ','自定义属性值'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'0','1',' ',599738021637683200,599738021646071814,'accountuse',9,'0',' ',' ','科目用途'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',599738021637683200,599738021646071830,'isaccountoffset',25,'0',' ',' ','是否对账抵销'); 


/**自定义维度导入模板预置**/

delete from T_BAS_IMPORTTEMPLATE where fid = 412102866623307776;
delete from T_BAS_IMPORTTEMPLATE_L where fid = 412102866623307776;
delete from T_BAS_IMPORTTEMPLATEENTRY where fid = 412102866623307776;

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


INSERT INTO T_BAS_IMPORTTEMPLATE_L (FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('/9LAMI8/XWQI', 412102866623307776, 'zh_CN', '自定义维度导入模板', '出厂预置模板');

INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','0',NULL,0,412102549710086144,'bcm_userdefinedmemberimp',1,'0',' ',' ','自定义维度-导入'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','0',NULL,412102549710086144,412102553157804032,'billhead',2,'0',' ',' ','单据头'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524288,'number',3,'1',' ',' ','编码*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524289,'name',4,'1',' ',' ','名称*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1','number',412102553157804032,412102553216524290,'parent',5,'1',' ','name','上级*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524291,'aggoprt',6,'0',' ',' ','聚合算法'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524292,'storagetype',7,'1',' ',' ','存储类型'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524293,'datatype',8,'0',' ',' ','数据类型'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524294,'value',9,'0',' ',' ','枚举'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524295,'description',10,'0',' ',' ','说明'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1','number',412102553157804032,412102553216524296,'dimension',11,'1',' ','name','维度*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1','number',412102553157804032,412102553216524297,'model',12,'1',' ','name','体系*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524298,'longnumber',13,'0',' ',' ','长编码'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524299,'definedpropertyvalue',14,'0',' ',' ','自定义属性值'); 

/**变动类型导入模板预置**/

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,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (409830069813393408,'1',409830069813393408,'A','bcm_changetypememberimp_IMPT_S',' ','IMPT',{ts'2018-08-08  18:08:08'},1,'1',{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','出厂预置模板','变动类型导入模板'); 

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',' ',' ','变动类型-导入'); 
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',' ',' ','单据头'); 
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',' ',' ','编码*'); 
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',' ',' ','名称*'); 
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',' ',' ','存储类型'); 
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',' ',' ','聚合算法'); 
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',' ',' ','变动方式'); 
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',' ',' ','是否年结冲销'); 
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',' ',' ','说明'); 
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','上级*'); 
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',' ',' ','自定义属性值'); 
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','维度*'); 
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','体系*'); 
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,'0','1',' ',409828627190921216,873962583483357184,'datatype',15,'0',' ',' ',NULL); 
