DELETE FROM T_ER_INVOICESETTING WHERE FID = 1952145195629833216;
DELETE FROM T_ER_INVOICESETTINGENTRY WHERE FID = 1952145195629833216;
DELETE FROM T_ER_INVOICESETTING_L WHERE FID = 1952145195629833216;

INSERT INTO T_ER_INVOICESETTING (FID, FISP, FNUMBER, FSTATUS, FCREATETIME, FMODIFYTIME, FMASTERID, FORGID, FCREATEORGID, FENABLE, FCTRLSTRATEGY, FCREATORID, FMODIFIERID, FNAME) VALUES (1952145195629833216, 'QICHENG', 'QICHENG001', 'C', {ts'2024-05-17 10:43:28'},  {ts'2024-05-17 10:43:28'}, 1952145195629833216, 0, 0, '1', ' ', 1924580445052322816, 1924580445052322816, ' ');
INSERT INTO T_ER_INVOICESETTING_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('43SIYNAECHAF', 1952145195629833216, 'zh_CN', '企橙开票设置');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1952145195998931968, 1, '2', 'ITINERARY', '1', '3', 9.0000000000, '1');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1952145195998931971, 4, '1', 'TICKET', '9', '1', 6.0000000000, '1');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1952145195998931970, 2, '2', 'SERVICE', '3', '1', 6.0000000000, '1');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1986336270179663873, 6, '6', 'TICKET', '7', '4', 9.0000000000, '1');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1986336270179663872, 5, '1', 'SERVICE', '3', '1', 6.0000000000, '1');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1986336270179663874, 7, '6', 'SERVICE', '3', '1', 6.0000000000, '1');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1952145195998931969, 3, '2', 'TICKREFUND', '2', '0', 0.0000000000, '0');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1986336270179663876, 8, '3', 'TICKET', '16', '2', 3.0000000000, '1');
INSERT INTO T_ER_INVOICESETTINGENTRY (FID, FENTRYID, FSEQ, FOPERATIONTYPE, FSERVICEITEM, FBRIEF, FINVOICETYPE, FDEDUCTRATE, FISDEDUCTIBLE) VALUES (1952145195629833216, 1986336270179663877, 9, '3', 'SERVICE', '3', '2', 3.0000000000, '1');
