delete from t_bas_importtemplate where fid = 1513216609450456064;
INSERT INTO t_bas_importtemplate (fid, fcreatetime, fmodifytime, fmodifierid, fnumber, fbizobject, fstatus, fcreatorid, fenable, fcomment, fmasterid, ftemplatetype, fenableimport, fname, fapplyscope) VALUES (1513216609450456064, {ts'2022-09-19 20:09:54'}, {ts'2022-09-30 10:50:24'}, 1158725317964077056, 'bdm_goods_info_IMPT_S_1', 'bdm_goods_info', 'C', 1158725317964077056, '1', ' ', 1513216609450456064, 'IMPT', '1', '开票项引入模板', '0');

delete from t_bas_importtemplate_l where fid = 1513216609450456064 and flocaleid='zh_CN';
INSERT INTO t_bas_importtemplate_l (fpkid, fid, flocaleid, fname, fcomment) VALUES ('2RTIP7XYHJVW', 1513216609450456064, 'zh_CN', '开票项引入模板', ' ');


delete from t_bas_importtemplateentry where fid = 1513216609450456064;
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888460, 1513215919982375936, 21, 'org', null, '0', ' ', '0', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764556, 1513215919982375936, 22, 'createorg', null, '1', ' ', '1', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888461, 1513215919982375936, 23, 'useorg', null, '0', ' ', '0', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099816449, 1513215920099940352, 30, 'material_no', null, '0', ' ', '1', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099940354, 1513215920099940352, 31, 'materialtype', null, '0', ' ', '1', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099816450, 1513215920099940352, 32, 'expenseitem', null, '0', ' ', '1', '1', 'number', 'fullname');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919982375936, 1513215919982499840, 2, 'billhead', null, '0', ' ', '0', '0', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764552, 1513215919982375936, 14, 'enable', null, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888457, 1513215919982375936, 15, 'priority', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888459, 1513215919982375936, 19, 'createtime', null, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764555, 1513215919982375936, 20, 'modifytime', null, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764557, 1513215919982375936, 24, 'status', null, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919982499840, 0, 1, 'bdm_goods_info', null, '0', ' ', '0', '0', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888454, 1513215919982375936, 9, 'taxcode', null, '1', ' ', '1', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764553, 1513215919982375936, 16, 'group', null, '0', ' ', '1', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888458, 1513215919982375936, 17, 'creator', null, '0', ' ', '0', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764554, 1513215919982375936, 18, 'modifier', null, '0', ' ', '0', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920108328960, 1513215920099940352, 37, 'baseunit', null, '0', ' ', '1', '1', 'number', 'name');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888448, 1513215919982375936, 3, 'id', null, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764544, 1513215919982375936, 4, 'number', null, '1', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888449, 1513215919982375936, 5, 'name', null, '1', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764545, 1513215919982375936, 6, 'taxrate', null, '1', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888453, 1513215919982375936, 7, 'specifications', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764549, 1513215919982375936, 8, 'unit', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764550, 1513215919982375936, 10, 'privilegeflag', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888455, 1513215919982375936, 11, 'privilegetype', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764551, 1513215919982375936, 12, 'price', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888456, 1513215919982375936, 13, 'isinclusive', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099816448, 1513215920099940352, 28, 'bdm_goods_info_item.id', null, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099940353, 1513215920099940352, 29, 'sourcetype', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099940355, 1513215920099940352, 33, 'material_name', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099816451, 1513215920099940352, 34, 'material_modelnum', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099940356, 1513215920099940352, 35, 'modelnum_unit', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920108205056, 1513215920099940352, 36, 'modelnum_rate', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990888462, 1513215919982375936, 25, 'prices', null, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215919990764558, 1513215919982375936, 26, 'filter', null, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry (fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop) VALUES (1513216609450456064, 1513215920099940352, 1513215919982499840, 27, 'bdm_goods_info_item', null, '0', ' ', '0', '0', ' ', ' ');
