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

delete from t_bas_importtemplate_l where FPKID = '0/9VY9+17FBR';
delete from t_bas_importtemplate_l where FPKID = '0/9VY9+17FBS';

delete from t_bas_importtemplateentry where FENTRYID = 645574908608332800;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758144;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758145;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758146;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758147;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758148;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758149;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758150;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758151;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758152;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758153;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758154;
delete from t_bas_importtemplateentry where FENTRYID = 645574909178758155;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146752;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146753;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146754;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146755;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146756;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146757;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146758;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146759;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146760;
delete from t_bas_importtemplateentry where FENTRYID = 645574909187146761;

-- 单头
insert into T_BAS_IMPORTTEMPLATE (FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE, FENABLEIMPORT)
values ('645575177270281216', {ts'2018-08-08 18:08:08'}, {ts'2018-08-08 18:08:08'}, 1, 'bcm_dimmembwelkin_EXPT_S', ' ', 'bcm_dimmembwelkin', 'A', 1, '1', ' ', '645575177270281216', 'EXPT', '1');

-- 多语言
insert into T_BAS_IMPORTTEMPLATE_l (FPKID, FID, FLOCALEID, FNAME, FCOMMENT)
values ('0/9VY9+17FBR', '645575177270281216', 'zh_CN', '成员映射反向导出模版', ' ');

-- 分录
insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574908608332800', '0', '1', 'bcm_dimmembwelkin', '成员映射', '0', ' ', '0', '0', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758144', '645574908608332800', '2', 'billhead', '单据头', '0', ' ', '0', '0', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758145', '645574909178758144', '3', 'model', '体系*', '1', ' ', '1', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758146', '645574909178758144', '4', 'scheme', '方案名称*', '1', ' ', '1', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758147', '645574909178758144', '5', 'schemenumber', '方案编码', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758148', '645574909178758144', '6', 'srcsys', '源系统', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758149', '645574909178758144', '7', 'tagsys', '目标系统', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758150', '645574909178758144', '8', 'srcdim', '源维度*', '1', ' ', '1', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758151', '645574909178758144', '9', 'tagdim', '目标维度*', '1', ' ', '1', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758152', '645574909178758144', '10', 'createtime', '创建时间', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758153', '645574909178758144', '11', 'createorg', '创建组织', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758154', '645574909178758144', '12', 'status', '状态', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909178758155', '645574908608332800', '13', 'entryentity', '单据体', '0', ' ', '0', '0', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146752', '645574909178758155', '14', 'relation', '关系', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146753', '645574909178758155', '15', 'srcdimmembnumber', '源编码', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146754', '645574909178758155', '16', 'srcdimmemb', '源值名称', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146755', '645574909178758155', '17', 'tagdimidcache', '目标ID缓存', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146756', '645574909178758155', '18', 'tagdimnumbercache', '目标编码缓存', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146757', '645574909178758155', '19', 'fid', 'fid', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146758', '645574909178758155', '20', 'tagdimmembnumber', '目标编码', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146759', '645574909178758155', '21', 'tagdimmemb', '目标值名称', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146760', '645574909178758155', '22', 'srcdimidcache', '源ID缓存', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('645575177270281216', '645574909187146761', '645574909178758155', '23', 'srcdimnumbercache', '源编码缓存', '0', ' ', '0', '1', ' ');

