/*增加海外发票类型*/

DELETE FROM T_ER_INVOICETYPE WHERE FID = 1825476792631274496;
INSERT INTO T_ER_INVOICETYPE(FID,FISEINVOICE,FISVATINVOICE,FISDEFAULT,FMASTERID,FSTATUS,FUDRDISPLAY,FJS,FNUMBER,FCREATETIME,FUSERDEFINERULE,FMODIFIERID,FENABLE,FISSPECIALINVOICE,FREMARK,FMODIFYTIME,FISOFFSET,FISTRANSPORTINVOICE,FCREATORID) VALUES (1825476792631274496,'0','0','0',1825476792631274496,'C',' ',' ','30',{ts'2023-11-24  00:00:00'},' ',1680468111436139520,'1','0',' ',{ts'2023-11-24  00:00:00'},'0','0',1680468111436139520);

DELETE FROM T_ER_INVOICETYPE_L WHERE FPKID = '3Q7OH5HIAVW+';
INSERT INTO T_ER_INVOICETYPE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1825476792631274496,'3Q7OH5HIAVW+','zh_CN','形式发票');
DELETE FROM T_ER_INVOICETYPE_L WHERE FPKID = '3Q7OH5HIAVW/';
INSERT INTO T_ER_INVOICETYPE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1825476792631274496,'3Q7OH5HIAVW/','zh_TW','形式發票');


/*发票合并规则*/

DELETE FROM T_ER_INVOICEMERGERULE WHERE FID = 1825499048656874496;
INSERT INTO T_ER_INVOICEMERGERULE(FINVOICEDATEDETAILEQUAL,FGOODCODEEQUAL,FINVOICEDATEEQUAL,FMASTERID,FUDRDISPLAY,FTAXRATEEQUAL,FJS,FISMERGE,FOFFSETEQUAL,FCREATETIME,FENABLE,FINVOICETYPE,FORDER,FGOODNAMEEQUAL,FTAXNUMEQUAL,FID,FSEATGRADEQUAL,FFROMEQUAL,FSTATUS,FBUYERNAMEEQUAL,FTOEQUAL,FSALERNAMEEQUAL,FNUMBER,FUSERDEFINERULE,FMODIFIERID,FPASSENGEREQUAL,FMODIFYTIME,FMERGETYPE,FITEMEQUAL,FAMOUNTEQUAL,FCREATORID) VALUES ('1','0','1',1825499048656874496,' ','1',' ','1','1',{ts'2023-11-24  00:00:00'},'1','30',0,'0','0',1825499048656874496,'0','0','A','0','0','0','FPHBGZ030',' ',1680468111436139520,'0',{ts'2023-11-27  00:00:00'},'1','1','1',1680468111436139520);

DELETE FROM T_ER_INVOICEMERGERULE_L WHERE FPKID = '3QGBI8IWYP9B';
INSERT INTO T_ER_INVOICEMERGERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1825499048656874496,'3QGBI8IWYP9B','zh_CN','形式发票');
DELETE FROM T_ER_INVOICEMERGERULE_L WHERE FPKID = '3QGBI8IWYP9C';
INSERT INTO T_ER_INVOICEMERGERULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1825499048656874496,'3QGBI8IWYP9C','zh_TW','形式發票');

/**/