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

INSERT INTO T_BAS_IMPORTTEMPLATE
(FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE, FENABLEIMPORT, FNAME)
VALUES(1007299677210765312, {ts'2020-10-21 19:23:33'}, {ts'2020-10-21 19:23:33'}, 1, 'er_rel_expense_ratetype_IMPT_S', 'er_rel_expense_ratetype', 'C', 1, '1', ' ', 1007299677210765312, 'IMPT', '1', '映射费用项目模板');

INSERT INTO T_BAS_IMPORTTEMPLATE_L
(FPKID, FID, FLOCALEID, FNAME, FCOMMENT)
VALUES('14PVLHNSSFA6H', 1007299677210765312, 'zh_CN', '映射费用项目模板', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATE_L
(FPKID, FID, FLOCALEID, FNAME, FCOMMENT)
VALUES('14PVLHNSSFA7', 1007299677210765312, 'zh_TW', '映射費用項目模板', ' ');

INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126205045760,0,1,'er_rel_expense_ratetype',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230214656,1007299126205045760,2,'billhead',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230211584,1007299126230214656,3,'id',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230211589,1007299126230214656,4,'name',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230211591,1007299126230214656,5,'number',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230214657,1007299126230214656,6,'billtype',NULL,'1',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230211585,1007299126230214656,7,'tripitem',NULL,'0',' ','0','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230214658,1007299126230214656,8,'expenseitem',NULL,'1',' ','1','1','number','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230211586,1007299126230214656,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 
(1007299677210765312,1007299126230214659,1007299126230214656,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 
(1007299677210765312,1007299126230211587,1007299126230214656,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 
(1007299677210765312,1007299126230214660,1007299126230214656,12,'createtime',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230211588,1007299126230214656,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 
(1007299677210765312,1007299126230214661,1007299126230214656,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 
(1007299677210765312,1007299126230214662,1007299126230214656,15,'status',NULL,'0',' ','0','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230211590,1007299126230214656,16,'enable',NULL,'0',' ','1','1',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126230214663,1007299126230214656,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 
(1007299677210765312,1007299126238603264,1007299126230214656,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 
(1007299677210765312,1007299126238600192,1007299126230214656,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 
(1007299677210765312,1007299126238603265,1007299126230214656,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 
(1007299677210765312,1007299126381209600,1007299126205045760,21,'entryentity',NULL,'0',' ','0','0',' ',' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY 
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES 
(1007299677210765312,1007299126381206528,1007299126381209600,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 
(1007299677210765312,1007299126381209601,1007299126381209600,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 
(1007299677210765312,1007299126381206529,1007299126381209600,24,'inv_goodnames',NULL,'0',' ','1','1',' ',' ');