DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1226200876742416384;
INSERT INTO t_bas_importtemplate
(fid, fcreatetime, fmodifytime, fmodifierid, fnumber, fbizobject, fstatus, fcreatorid, fenable, fcomment, fmasterid, ftemplatetype, fenableimport, fname, fapplyscope)
VALUES(1226200876742416384, {ts'2021-08-19 19:55:15'}, {ts'2021-08-19 20:04:11'}, 1224569107366647808, 'er_expense_detaildata_EXPT_S', 'er_expense_detaildata', 'C', 1224569107366647808, '1', ' ', 1226200876742416384, 'EXPT', '1', '费用明细数据源导出模版', '0');


DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FID = 1226200876742416384;
INSERT INTO t_bas_importtemplate_l
(fpkid, fid, flocaleid, fname, fcomment)
VALUES('1ULLBTCYXCUL', 1226200876742416384, 'zh_CN', '费用明细数据源导出模版', ' ');
INSERT INTO t_bas_importtemplate_l
(fpkid, fid, flocaleid, fname, fcomment)
VALUES('1ULLBTCYXCUM', 1226200876742416384, 'zh_TW', '費用明細數據源导出模版', ' ');

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID = 1226200876742416384;
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198514057418752, 1226198513629672448, 30, 'year', NULL, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198514091045888, 1226198513629672448, 31, 'quarter', NULL, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198514107750400, 1226198513629672448, 32, 'yearmonth', NULL, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198514124600320, 1226198513629672448, 33, '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(1226200876742416384, 1226198514141304832, 1226198513629672448, 34, 'auditdate', NULL, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198514158154752, 1226198513629672448, 35, 'createtime', NULL, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198514174859264, 1226198513629672448, 36, 'modifytime', NULL, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198512346142720, 0, 1, 'er_expense_detaildata', NULL, '0', ' ', '0', '0', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513679931392, 1226198513629672448, 5, '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(1226200876742416384, 1226198513696781312, 1226198513629672448, 6, 'auditor', NULL, '0', ' ', '0', '1', ' ', 'number,name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513738724352, 1226198513629672448, 7, 'company', NULL, '0', ' ', '1', '1', ' ', 'number,name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513705097216, 1226198513629672448, 8, 'org', NULL, '0', ' ', '1', '1', ' ', 'number,name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513763890176, 1226198513629672448, 11, 'applier', NULL, '0', ' ', '1', '1', ' ', 'number,name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513780594688, 1226198513629672448, 12, 'costcompany', NULL, '0', ' ', '1', '1', ' ', 'number,name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513797444608, 1226198513629672448, 13, 'costdept', NULL, '0', ' ', '1', '1', ' ', 'number,name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513805760512, 1226198513629672448, 14, '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(1226200876742416384, 1226198513847776256, 1226198513629672448, 15, 'travelitem', NULL, '0', ' ', '1', '1', ' ', 'number,name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513864480768, 1226198513629672448, 16, 'stdproject', NULL, '0', ' ', '1', '1', ' ', 'number,name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513973532672, 1226198513629672448, 19, 'oricurrency', NULL, '0', ' ', '1', '1', ' ', 'number');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198514007087104, 1226198513629672448, 27, 'reimbursers', NULL, '0', ' ', '1', '1', ' ', 'name');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513990382592, 1226198513629672448, 21, 'currency', NULL, '0', ' ', '1', '1', ' ', 'number');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513629672448, 1226198512346142720, 2, 'billhead', NULL, '0', ' ', '0', '0', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513713558528, 1226198513629672448, 3, 'billtype', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513646376960, 1226198513629672448, 4, 'billno', NULL, '1', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513730263040, 1226198513629672448, 9, 'billid', NULL, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513755428864, 1226198513629672448, 10, 'bizdate', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513889719296, 1226198513629672448, 17, 'orientryamount', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513914812416, 1226198513629672448, 18, 'entryamount', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513931662336, 1226198513629672448, 20, 'orientryappamount', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513948366848, 1226198513629672448, 22, 'entryappamount', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513671615488, 1226198513629672448, 26, 'billstatus', NULL, '1', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198513965216768, 1226198513629672448, 28, 'happendate', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1226198514023937024, 1226198513629672448, 29, 'encashamount', NULL, '0', ' ', '0', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1231859844122750977, 1226198513629672448, 23, 'price', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1231859844122750976, 1226198513629672448, 24, 'curprice', NULL, '0', ' ', '1', '1', ' ', ' ');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop)
VALUES(1226200876742416384, 1231859844122752000, 1226198513629672448, 25, 'deductibletax', NULL, '0', ' ', '1', '1', ' ', ' ');
