DELETE from t_er_invoicesetting where fid='767289452472170496';
INSERT INTO t_er_invoicesetting (FID, FISP, FNUMBER, FSTATUS, FCREATETIME, FMODIFYTIME, FCREATORID, FMODIFIERID, FMASTERID, FORGID, FCREATEORGID, FENABLE, FCTRLSTRATEGY) VALUES ('767289452472170496', 'CHAILVYIHAO', 'CL001', 'C', {ts'2019-11-25 15:46:29'}, {ts'2019-11-27 14:35:41'}, '467068', '467068', '767289452472170496', '0', '0', '0', ' ');

DELETE from t_er_invoicesetting_l where FPKID in ('0D8+Q2W/USGP','0D8+Q2W/USGQ');
INSERT INTO t_er_invoicesetting_l (FPKID, FID, FNAME, FLOCALEID) VALUES ('0D8+Q2W/USGP', '767289452472170496', '差旅壹号开票设置', 'zh_CN');
INSERT INTO t_er_invoicesetting_l (FPKID, FID, FNAME, FLOCALEID) VALUES ('0D8+Q2W/USGQ', '767289452472170496', '差旅壹號開票設置', 'zh_TW');

DELETE from t_er_invoicesettingentry where fid='767289452472170496';
INSERT INTO t_er_invoicesettingentry (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES ('767289452472170496', '767289452556056576', '1', '2', 'ITINERARY', '1', '3', '6.0000000000', '1');
INSERT INTO t_er_invoicesettingentry (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES ('767289452472170496', '767289452556056577', '2', '2', 'INSURANCE', '10', '2', '3.0000000000', '1');
INSERT INTO t_er_invoicesettingentry (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES ('767289452472170496', '767289452556056578', '3', '2', 'SERVICE', '3', '1', '4.0000000000', '1');
INSERT INTO t_er_invoicesettingentry (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES ('767289452472170496', '767289452556056579', '4', '1', 'TICKET', '9', '1', '7.0000000000', '1');
INSERT INTO t_er_invoicesettingentry (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES ('767289452472170496', '767289452556056580', '5', '1', 'SERVICE', '9', '0', '8.0000000000', '1');
INSERT INTO t_er_invoicesettingentry (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES ('767289452472170496', '767289452556056581', '6', '4', 'TICKET', '1', '0', '5.0000000000', '1');
INSERT INTO t_er_invoicesettingentry (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES ('767289452472170496', '767289452556056582', '7', '2', 'TICKREFUND', '1', '0', '1.0000000000', '1');
