--删除原有数据
--删除组织数据
delete from t_bas_importtemplate where FID = 409825039349725184;

delete from t_bas_importtemplate_l where FPKID = '/9AE00650R4R';
delete from t_bas_importtemplate_l where FPKID = '/9AE00650R4S';

delete from t_bas_importtemplateentry where FENTRYID = 409824743710013440;
delete from t_bas_importtemplateentry where FENTRYID = 409824744322381824;
delete from t_bas_importtemplateentry where FENTRYID = 409824744330770432;
delete from t_bas_importtemplateentry where FENTRYID = 409824744330770433;
delete from t_bas_importtemplateentry where FENTRYID = 409824744330770434;
delete from t_bas_importtemplateentry where FENTRYID = 409824744330770435;
delete from t_bas_importtemplateentry where FENTRYID = 409824744330770436;
delete from t_bas_importtemplateentry where FENTRYID = 409824744330770437;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713472;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713473;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713474;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713475;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713476;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713477;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713478;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713479;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713480;
delete from t_bas_importtemplateentry where FENTRYID = 409824744372713481;

--删除科目数据
delete from t_bas_importtemplate where FID = 409827330681223168;

delete from t_bas_importtemplate_l where FPKID = '/9AEFQC41NDN';
delete from t_bas_importtemplate_l where FPKID = '/9AEFQC41NDO';

delete from t_bas_importtemplateentry where FENTRYID = 409827147658573824;
delete from t_bas_importtemplateentry where FENTRYID = 409827148245776384;
delete from t_bas_importtemplateentry where FENTRYID = 409827148254164992;
delete from t_bas_importtemplateentry where FENTRYID = 409827148262553600;
delete from t_bas_importtemplateentry where FENTRYID = 409827148262553601;
delete from t_bas_importtemplateentry where FENTRYID = 409827148279330816;
delete from t_bas_importtemplateentry where FENTRYID = 409827148279330817;
delete from t_bas_importtemplateentry where FENTRYID = 409827148279330818;
delete from t_bas_importtemplateentry where FENTRYID = 409827148279330819;
delete from t_bas_importtemplateentry where FENTRYID = 409827148279330820;
delete from t_bas_importtemplateentry where FENTRYID = 409827148279330821;
delete from t_bas_importtemplateentry where FENTRYID = 409827148296108032;
delete from t_bas_importtemplateentry where FENTRYID = 409827148296108033;
delete from t_bas_importtemplateentry where FENTRYID = 409827148296108034;
delete from t_bas_importtemplateentry where FENTRYID = 409827148296108035;
delete from t_bas_importtemplateentry where FENTRYID = 409827148296108036;
delete from t_bas_importtemplateentry where FENTRYID = 409827148304496640;
delete from t_bas_importtemplateentry where FENTRYID = 409827148304496641;
delete from t_bas_importtemplateentry where FENTRYID = 409827148304496642;
delete from t_bas_importtemplateentry where FENTRYID = 409827148304496643;
delete from t_bas_importtemplateentry where FENTRYID = 409827148312885248;
delete from t_bas_importtemplateentry where FENTRYID = 409827148312885249;
delete from t_bas_importtemplateentry where FENTRYID = 409827148312885250;
delete from t_bas_importtemplateentry where FENTRYID = 409827148312885251;

--删除变动类型数据
delete from t_bas_importtemplate where FID = 409830069813393408;

delete from t_bas_importtemplate_l where FPKID = '/9AEZOT=VIZY';
delete from t_bas_importtemplate_l where FPKID = '/9AEZOT=VIZZ';

delete from t_bas_importtemplateentry where FENTRYID = 409828622652684288;
delete from t_bas_importtemplateentry where FENTRYID = 409828627190921216;
delete from t_bas_importtemplateentry where FENTRYID = 409828627190921217;
delete from t_bas_importtemplateentry where FENTRYID = 409828627190921218;
delete from t_bas_importtemplateentry where FENTRYID = 409828627190921219;
delete from t_bas_importtemplateentry where FENTRYID = 409828627190921220;
delete from t_bas_importtemplateentry where FENTRYID = 409828627190921221;
delete from t_bas_importtemplateentry where FENTRYID = 409828627190921222;
delete from t_bas_importtemplateentry where FENTRYID = 409828627190921223;
delete from t_bas_importtemplateentry where FENTRYID = 409828627216087040;
delete from t_bas_importtemplateentry where FENTRYID = 409828627216087041;
delete from t_bas_importtemplateentry where FENTRYID = 409828627216087042;
delete from t_bas_importtemplateentry where FENTRYID = 409828627216087043;
delete from t_bas_importtemplateentry where FENTRYID = 409828627216087044;

--删除自定义维度数据
delete from t_bas_importtemplate where FID = 412102866623307776;

delete from t_bas_importtemplate_l where FPKID = '/9LAMI8/XWQI';
delete from t_bas_importtemplate_l where FPKID = '/9LAMI8/XWQJ';

delete from t_bas_importtemplateentry where FENTRYID = 412102549710086144;
delete from t_bas_importtemplateentry where FENTRYID = 412102553157804032;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524288;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524289;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524290;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524291;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524292;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524293;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524294;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524295;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524296;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524297;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524298;
delete from t_bas_importtemplateentry where FENTRYID = 412102553216524299;

--预置组织导入模板
INSERT INTO t_bas_importtemplate (FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE) VALUES (409825039349725184, {ts'2018-08-08 18:08:08'}, {ts'2018-08-08 18:08:08'}, 1, 'bcm_entitymemberimp_IMPT_S', ' ', 'bcm_entitymemberimp', 'A', 1, '1', ' ', 409825039349725184,'IMPT');

INSERT INTO t_bas_importtemplate_l (FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('/9AE00650R4R', 409825039349725184, 'zh_CN', '组织导入模板', '出厂预置模板');

INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824743710013440, 0, 1, 'bcm_entitymemberimp', '组织-导入', '0', ' ', '1', '0');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744322381824, 409824743710013440, 2, 'billhead', '单据头', '0', ' ', '1', '0');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744330770432, 409824744322381824, 3, 'number', '编码*', '1', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744330770433, 409824744322381824, 4, 'name', '名称*', '1', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744330770434, 409824744322381824, 5, 'simplename', '简称', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744330770435, 409824744322381824, 6, 'storagetype', '存储类型', '1', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744330770436, 409824744322381824, 7, 'aggoprt', '聚合算法', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744330770437, 409824744322381824, 8, 'ctrlorg', '控股组织', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713472, 409824744322381824, 9, 'currency', '默认币别', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713473, 409824744322381824, 10, 'isinnerorg', '是否往来组织', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713474, 409824744322381824, 11, 'effdate', '生效日期', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713475, 409824744322381824, 12, 'expdate', '失效日期', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713476, 409824744322381824, 13, 'isclearorg', '是否清算', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713477, 409824744322381824, 14, 'description', '说明', '0', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713478, 409824744322381824, 15, 'parent', '上级*', '1', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713479, 409824744322381824, 16, 'model', '体系*', '1', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713480, 409824744322381824, 17, 'dimension', '维度*', '1', ' ', '1', '1');
INSERT INTO t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD) VALUES (409825039349725184, 409824744372713481, 409824744322381824, 18, 'definedpropertyvalue', '自定义属性值', '0', ' ', '1', '1');

--预置科目导入模板
INSERT INTO t_bas_importtemplate (FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE) 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');

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

--预置变动类型导入模板
INSERT INTO t_bas_importtemplate (FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE) 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');

INSERT INTO t_bas_importtemplate_l (FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('/9AEZOT=VIZY', 409830069813393408, 'zh_CN', '变动类型导入模板', '出厂预置模板');

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

--预置自定义维度导入模板
INSERT INTO t_bas_importtemplate (FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID,FTEMPLATETYPE) 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');

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

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