/**组织导入模板预置**/
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, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE, FENABLEIMPORT) VALUES (772300762582738944, {ts'2018-08-08 18:08:08'}, {ts'2018-08-08 18:08:08'}, 1, 'bcm_entitymemberimp_IMPT_S', ' ', 'bcm_entitymemberimp', 'C', 1, '1', ' ', 772300762582738944, 'IMPT', '1');

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

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

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

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

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

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_L (FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('/9LAMI8/XWQI', 412102866623307776, 'zh_CN', '自定义维度导入模板', '出厂预置模板');

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

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


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

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_L (FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('/9AEZOT=VIZY', 409830069813393408, 'zh_CN', '变动类型导入模板', '出厂预置模板');

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

INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828622652684288, 0, 1, 'bcm_changetypememberimp', '变动类型-导入', '0', ' ', '1', '0', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627190921216, 409828622652684288, 2, 'billhead', '单据头', '0', ' ', '1', '0', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627190921217, 409828627190921216, 3, 'number', '编码*', '1', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627190921218, 409828627190921216, 4, 'name', '名称*', '1', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627190921219, 409828627190921216, 5, 'storagetype', '存储类型', '1', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627190921220, 409828627190921216, 6, 'aggoprt', '聚合算法', '0', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627190921221, 409828627190921216, 7, 'changeway', '变动方式', '0', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627190921222, 409828627190921216, 8, 'isyearendchargeagaint', '是否年结冲销', '0', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627190921223, 409828627190921216, 9, 'description', '说明', '0', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627216087040, 409828627190921216, 10, 'parent', '上级*', '1', ' ', '1', '1', 'number', 'name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627216087041, 409828627190921216, 12, 'definedpropertyvalue', '自定义属性值', '0', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627216087042, 409828627190921216, 13, 'dimension', '维度*', '1', ' ', '1', '1', 'number', 'name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627216087043, 409828627190921216, 14, 'model', '体系*', '1', ' ', '1', '1', 'number', 'name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 409828627216087044, 409828627190921216, 15, 'longnumber', '长编码', '0', ' ', '1', '1', null, ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 873962583483315201, 409828627190921216, 11, 'parentlongnumber', '上级长编码', '1', ' ', '1', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES (409830069813393408, 873962583483357184, 409828627190921216, 16, 'datatype', null, '0', ' ', '0', '1', ' ', ' ');

