--删除成员映射导入模板
delete from t_bas_importtemplate where FID = 636052126312860672 ;

delete from t_bas_importtemplate_l where FPKID = '0+38KYXALV7A';
delete from t_bas_importtemplate_l where FPKID = '0+38KYXALV7B';

delete from t_bas_importtemplateentry where FENTRYID = 636050167765830656;
delete from t_bas_importtemplateentry where FENTRYID = 636050175382686720;
delete from t_bas_importtemplateentry where FENTRYID = 636050175416241152;
delete from t_bas_importtemplateentry where FENTRYID = 636050175416241153;
delete from t_bas_importtemplateentry where FENTRYID = 636050175416241154;
delete from t_bas_importtemplateentry where FENTRYID = 636050175416241155;
delete from t_bas_importtemplateentry where FENTRYID = 636050175416241156;
delete from t_bas_importtemplateentry where FENTRYID = 636050175416241157;
delete from t_bas_importtemplateentry where FENTRYID = 636050175416241158;
delete from t_bas_importtemplateentry where FENTRYID = 636050175416241159;
delete from t_bas_importtemplateentry where FENTRYID = 636050175424629760;
delete from t_bas_importtemplateentry where FENTRYID = 636050175424629761;
delete from t_bas_importtemplateentry where FENTRYID = 636050175424629762;
delete from t_bas_importtemplateentry where FENTRYID = 636050175424629763;
delete from t_bas_importtemplateentry where FENTRYID = 636050175433018368;
delete from t_bas_importtemplateentry where FENTRYID = 636050175433018369;
delete from t_bas_importtemplateentry where FENTRYID = 636050175433018370;
delete from t_bas_importtemplateentry where FENTRYID = 636050175433018371;
delete from t_bas_importtemplateentry where FENTRYID = 636050175433018372;
delete from t_bas_importtemplateentry where FENTRYID = 636050175433018373;
--预置成员映射导入模板
INSERT INTO T_BAS_IMPORTTEMPLATE(FBIZOBJECT,FMODIFIERID,FCREATORID,FTEMPLATETYPE,FMASTERID,FMODIFYTIME,FCREATETIME,FENABLE,FSTATUS,FNUMBER,FID) VALUES('bcm_dimmembermappingimp',1,1,'IMPT',636052126312860672,{ts'2018-08-08 18:08:08'},{ts'2018-08-08 18:08:08'},'1','A','bcm_dimmembermappingimp_IMPT_S',636052126312860672);

INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FCOMMENT,FNAME,FLOCALEID,FPKID) VALUES(636052126312860672,'出厂预置模板','成员映射导入模板','zh_CN','0+38KYXALV7A');

INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','0','0','0',' ','bcm_dimmembermappingimp','成员映射-导入',0,'1',636050167765830656);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','0','0','0',' ','billhead','单据头',636050167765830656,'2',636050175382686720);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,'number','1','1','1',' ','model','体系*',636050175382686720,'3',636050175416241152);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,'number','1','1','1',' ','scheme','方案名称*',636050175382686720,'4',636050175416241153);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','0','0',' ','schemenumber','方案编码',636050175382686720,'5',636050175416241154);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','0','0',' ','srcsys','源系统',636050175382686720,'6',636050175416241155);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','0','0',' ','tagsys','目标系统',636050175382686720,'7',636050175416241156);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,'number','1','1','1',' ','tagdim','目标维度*',636050175382686720,'8',636050175416241157);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,'number','1','1','1',' ','srcdim','源维度*',636050175382686720,'9',636050175416241158);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','0','0','0',' ','entryentity','单据体',636050167765830656,'10',636050175416241159);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','1','1',' ','relation','关系',636050175416241159,'11',636050175424629760);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','1','1',' ','srcdimmembnumber','源值编码',636050175416241159,'12',636050175424629761);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','1','1',' ','srcdimmemb','源值名称',636050175416241159,'13',636050175424629762);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','1','1',' ','tagdimmembnumber','目标值编码',636050175416241159,'14',636050175424629763);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,'number','1','1','1',' ','tagdimmemb','目标值名称',636050175416241159,'15',636050175433018368);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','0','0',' ','tagfieldselect','目标字段选择',636050175416241159,'16',636050175433018369);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','0','0',' ','fid','fid',636050175416241159,'17',636050175433018370);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','1','0',' ','periodnumber','期间编码',636050175416241159,'18',636050175433018371);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,'number','1','1','0',' ','period','期间名称',636050175416241159,'19',636050175433018372);
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FIMPORTPROP,FISFIELD,FISIMPORT,FMUSTINPUT,FDESCRIPTION,FFIELDKEY,FFIELDNAME,FPARENTENTRYID,FSEQ,FENTRYID) VALUES(636052126312860672,' ','1','0','0',' ','periodselect','期间字段选择',636050175416241159,'20',636050175433018373);
