/**往来组织导入模板预置 add by qingmao**/
delete from T_BAS_IMPORTTEMPLATE where fid = 647529635021668352;
delete from T_BAS_IMPORTTEMPLATE_L where fid = 647529635021668352;
delete from T_BAS_IMPORTTEMPLATEENTRY where fid = 647529635021668352;

insert into T_BAS_IMPORTTEMPLATE (FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE, FENABLEIMPORT)
values ('647529635021668352', {ts'2018-08-08 18:08:08'}, {ts'2018-08-08 18:08:08'}, '89559110', 'bcm_icmembertree_IMPT_S', ' ', 'bcm_icmembertree', 'A', '89559110', '1', ' ', '647529635021668352', 'IMPT', '1');

insert into T_BAS_IMPORTTEMPLATE_L (FPKID, FID, FLOCALEID, FNAME, FCOMMENT)
values ('0/I83BWDZHA4', '647529635021668352', 'zh_CN', '往来组织成员引入模板', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527616915521536', '0', '1', 'bcm_icmembertree', '往来组织成员树型', '0', ' ', '0', '0', ' ');

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

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617695662080', '647527617687273472', '3', 'number', '编码*', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050688', '647527617687273472', '4', 'name', '名称*', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050689', '647527617687273472', '5', 'simplename', '简码', '0', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050690', '647527617687273472', '6', 'parentname', '父级名称', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050691', '647527617687273472', '7', 'creator', '创建人', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050692', '647527617687273472', '8', 'enable', '使用状态', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050693', '647527617687273472', '9', 'fullname', '长名称', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050694', '647527617687273472', '10', 'longnumber', '长编码', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050695', '647527617687273472', '11', 'isleaf', '是否叶子', '0', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050696', '647527617687273472', '12', 'level', '级次', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050697', '647527617687273472', '13', 'parent', '上级', '0', ' ', '1', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050698', '647527617687273472', '14', 'member', '维度成员', '0', ' ', '1', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050699', '647527617687273472', '15', 'storagetype', '存储类型*', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050700', '647527617687273472', '16', 'isshare', '共享所有下级成员', '0', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050701', '647527617687273472', '17', 'aggoprt', '聚合算法*', '1', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050702', '647527617687273472', '18', 'addtext', '增加平级下级', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050703', '647527617687273472', '19', 'startshare', '开始共享标识', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050704', '647527617687273472', '20', 'description', '说明', '0', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050705', '647527617687273472', '21', 'dpropertyid10', '自定义属性id10', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050706', '647527617687273472', '22', 'dpropertyid9', '自定义属性id9', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050707', '647527617687273472', '23', 'dpropertyid8', '自定义属性id8', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050708', '647527617687273472', '24', 'dpropertyid7', '自定义属性id7', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050709', '647527617687273472', '25', 'dpropertyid6', '自定义属性id6', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050710', '647527617687273472', '26', 'dpropertyid5', '自定义属性id5', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050711', '647527617687273472', '27', 'dpropertyid4', '自定义属性id4', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050712', '647527617687273472', '28', 'dpropertyid3', '自定义属性id3', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050713', '647527617687273472', '29', 'dpropertyid2', '自定义属性id2', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050714', '647527617687273472', '30', 'dpropertyid1', '自定义属性id1', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050715', '647527617687273472', '31', 'addstatus', '新增状态', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050716', '647527617687273472', '32', 'createtime', '创建时间', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050717', '647527617687273472', '33', 'status', '数据状态', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050718', '647527617687273472', '34', 'disabler', '禁用人', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050719', '647527617687273472', '35', 'disabledate', '禁用时间', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050720', '647527617687273472', '36', 'dimension', '维度', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050721', '647527617687273472', '37', 'model', '体系', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050722', '647527617687273472', '38', 'org', '创建组织', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050723', '647527617687273472', '39', 'dseq', '层级内顺序', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050724', '647527617687273472', '40', 'issysmember', '是否预置成员', '0', ' ', '1', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050725', '647527617687273472', '41', 'share', '整体共享标志', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050726', '647527617687273472', '42', 'copyfrom', '复制地点ID', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050727', '647527617687273472', '43', 'referid', '公有维度成员引用', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050728', '647527617687273472', '44', 'baseusergroup', '用户组', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050729', '647527617687273472', '45', 'baseuser', '用户', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617704050730', '647527616915521536', '46', 'treeentryentity', '树形单据体', '0', ' ', '0', '0', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617712439296', '647527617704050730', '47', 'xnumber', '编码', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617712439297', '647527617704050730', '48', 'xname', '名称', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617712439298', '647527617704050730', '49', 'did', '本行主键', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617712439299', '647527617704050730', '50', 'xparent', '父主键', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617712439300', '647527616915521536', '51', 'disentry', '权限分配单据体', '0', ' ', '0', '0', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617720827904', '647527617712439300', '52', 'type', '类型', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617720827905', '647527617712439300', '53', 'users', '用户组/用户', '0', ' ', '0', '1', 'number');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617720827906', '647527617712439300', '54', 'range', '成员范围*', '0', ' ', '0', '1', ' ');

insert into T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('647529635021668352', '647527617720827907', '647527617712439300', '55', 'permission', '权限*', '0', ' ', '0', '1', ' ');



