DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID IN (1007301067354102784);
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FID IN (1007301067354102784);
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID IN (1007301067354102784);

INSERT INTO T_BAS_IMPORTTEMPLATE
(FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE, FENABLEIMPORT, FNAME)
VALUES(1007301067354102784, {ts'2020-10-21 19:26:16'}, {ts'2020-10-21 19:26:16'}, 1, 'er_rel_tripitem_ratetype_IMPT_S', 'er_rel_tripitem_ratetype', 'C', 1, '1', ' ', 1007301067354102784, 'IMPT', '1', '映射差旅项目模板');

INSERT INTO T_BAS_IMPORTTEMPLATE_L
(FPKID, FID, FLOCALEID, FNAME, FCOMMENT)
VALUES('14PVVMQ1U8WH', 1007301067354102784, 'zh_CN', '映射差旅项目模板', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATE_L
(FPKID, FID, FLOCALEID, FNAME, FCOMMENT)
VALUES('14PVVMQ1U8WI', 1007301067354102784, 'zh_TW', '映射差旅項目模板', ' ');

INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817954304,0,1,'er_rel_tripitem_ratetype',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817951232,1007300497817954304,2,'billhead',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817954305,1007300497817951232,3,'id',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817954310,1007300497817951232,4,'name',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497826342913,1007300497817951232,5,'number',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817951233,1007300497817951232,6,'billtype',NULL,'1',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817954306,1007300497817951232,7,'tripitem',NULL,'1',' ','1','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817951234,1007300497817951232,8,'expenseitem',NULL,'0',' ','0','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817954307,1007300497817951232,9,'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 
(1007301067354102784,1007300497817951235,1007300497817951232,10,'inv_invoicetype',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817954308,1007300497817951232,11,'inv_ratetype',NULL,'0',' ','1','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817951236,1007300497817951232,12,'createtime',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497817954309,1007300497817951232,13,'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 
(1007301067354102784,1007300497817951237,1007300497817951232,14,'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 
(1007301067354102784,1007300497826339840,1007300497817951232,15,'status',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497826342912,1007300497817951232,16,'enable',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497826339841,1007300497817951232,17,'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 
(1007301067354102784,1007300497826339842,1007300497817951232,18,'bill_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 
(1007301067354102784,1007300497826342914,1007300497817951232,19,'bill_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 
(1007301067354102784,1007300497826339843,1007300497817951232,20,'bill_description',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497859894273,1007300497817954304,21,'entryentity',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497859897345,1007300497859894273,22,'entryentity.id',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497859894274,1007300497859894273,23,'inv_mappingtype',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007301067354102784,1007300497868285952,1007300497859894273,24,'inv_goodnames',NULL,'0',' ','1','1',' ',' ');
