--映射费用项目
--去除单头费用项目导入导出必录
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1007299126230214658;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY
(FID,FENTRYID,FPARENTENTRYID,FSEQ,FFIELDKEY,FFIELDNAME,FMUSTINPUT,FDESCRIPTION,FISIMPORT,FISFIELD,FIMPORTPROP,FEXPORTPROP) VALUES
(1007299677210765312,1007299126230214658,1007299126230214656,8,'expenseitem',NULL,'0',' ','0','1',' ',' ');
--增加分录费用项目导入导出必录
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1716614005596314624;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES
 (1007299677210765312,0,' ',1716614005596314624,'0','0',' ',' ','0','0',' ',' ',1716614004866505728,'expitemrange',30,NULL,' ',' ');

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1716614005604702208;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES
(1007299677210765312,0,' ',1716614005604702208,'0','0',' ',' ','0','1',' ',' ',1716614005596314624,'expitemrange.id',31,NULL,' ',' ');

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1716614005621480448;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES
(1007299677210765312,0,' ',1716614005621480448,'0','0',' ',' ','1','1',' ',' ',1716614005596314624,'isdefault',34,NULL,' ',' ');

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1716614005613091840;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES
(1007299677210765312,0,'number',1716614005613091840,'1','0',' ','fullname','1','1',' ',' ',1716614005596314624,'entryexpenseitem',32,NULL,' ',' ');

DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1716614005613090816;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES
(1007299677210765312,0,'number',1716614005613090816,'0','0',' ','name','0','1',' ',' ',1716614005596314624,'entrytripitem',33,NULL,' ',' ');