DELETE FROM T_ER_INVOICESETTING WHERE FID = 1906445138826114048;
INSERT INTO T_ER_INVOICESETTING(FID,FISP,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1906445138826114048,'TONGCHENG',{ts'2024-03-15  00:00:00'},1448586489507464192,'1',{ts'2024-03-15  00:00:00'},1906445138826114048,'C',1448586489507464192,'TONGCHENG001');

DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1906445139430093824;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,9.0000000000,'3','2',1906445139430093824,1,'1','ITINERARY','1');
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1906445139430093825;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,6.0000000000,'1','2',1906445139430093825,2,'1','SERVICE','3');
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1906445139430093826;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,0,'0','2',1906445139430093826,3,'0','TICKREFUND','1');
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1906445139430093827;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,6.0000000000,'1','1',1906445139430093827,4,'1','TICKET','9');
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1906445139430093828;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,6.0000000000,'1','1',1906445139430093828,5,'1','SERVICE','3');
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1906445139430093829;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,3.0000000000,'2','3',1906445139430093829,6,'1','TICKET','11');
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1906445139430093830;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,3.0000000000,'2','3',1906445139430093830,7,'1','SERVICE','3');
DELETE FROM t_er_invoicesettingentry WHERE FENTRYID = 1906445139430093831;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,9.0000000000,'4','6',1906445139430093831,8,'1','TICKET','7');
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1906445139430093832;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,6.0000000000,'1','6',1906445139430093832,9,'1','SERVICE','3');
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FENTRYID = 1976982560303174656;
INSERT INTO T_ER_INVOICESETTINGENTRY(FID,FDEDUCTRATE,FINVOICETYPE,FOPERATIONTYPE,FENTRYID,FSEQ,FISDEDUCTIBLE,FSERVICEITEM,FBRIEF) VALUES (1906445138826114048,0,'0','6',1976982560303174656,10,'0','TICKREFUND','2');


DELETE FROM T_ER_INVOICESETTING_L WHERE FPKID = '40DBX9Q6G3VH';
DELETE FROM T_ER_INVOICESETTING_L WHERE FPKID = '40DBX9Q6G3VI';
INSERT INTO T_ER_INVOICESETTING_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('40DBX9Q6G3VH', 1906445138826114048, 'zh_CN', '同程开票设置');
INSERT INTO T_ER_INVOICESETTING_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('40DBX9Q6G3VI', 1906445138826114048, 'zh_TW', '同程開票設置');

