/** 单元测试覆盖率mob端参数 **/
delete from t_er_stdconfig where fid = 1293553462344286208 or fkey = 'invoice.show.simulator.mob';
INSERT INTO t_er_stdconfig (fid,fvalue,fdesc,fkey) VALUES 
(1293553462344286208,'true','调试环境导入发票，只有将intranet会true时，才会使用到此参数，此参数控制移动端导入发票是以前的模式（false），还是选择数据库中数据的模式（true）','invoice.show.simulator.mob');

/** 单元测试覆盖率PC端参数 **/
delete from t_er_stdconfig where fid = 1293440446311345152 or fkey = 'invoice.show.simulator.pc';
INSERT INTO t_er_stdconfig (fid,fvalue,fdesc,fkey) VALUES 
(1293440446311345152,'false','调试环境导入发票，只有将intranet会true时，才会使用到此参数，此参数控制移动端导入发票是以前的模式（false），还是选择数据库中数据的模式（true）','invoice.show.simulator.pc');

/** 预置单元测试数据 */
--DELETE FROM t_er_invoicedatapre WHERE FID = 1293555207342396416;
--INSERT INTO t_er_invoicedatapre(FID,FINVOICEJSON,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FMASTERID,FINVOICEJSON_TAG,FSTATUS,FCREATORID,FNUMBER)
--VALUES (1293555207342396416,'{"errcode": "0000","description": "操作成功","data": [{"salerName": "深圳市深投物业发展有限公司","invoiceMoney": "87143.96","proxyMark": "","downloadUrl": "https: //api.kingdee.com/kdrive/user/file/public?client_idu003d200242u0026file_idu003d65149340u0026scodeu003dRXRR...',{ts'2021-11-20  00:00:00'},1160063587109202944,'1',{ts'2021-11-22  00:00:00'},1293555207342396416,'{"errcode": "0000","description": "操作成功","data": [{"salerName": "深圳市深投物业发展有限公司","invoiceMoney": "87143.96","proxyMark": "","downloadUrl": "https: //api.kingdee.com/kdrive/user/file/public?client_idu003d200242u0026file_idu003d65149340u0026scodeu003dRXRRMGloNmgwU3YzWkxjWWY3bnhCu0026signu003d3b766d2b98dbea973266cdee00509df13c05de88","remark": "投资大厦14楼B4-5,F1-5区","authenticateFlag": 1,"payee": "","checkStatus": "1","salerTaxNo": "91440300279371676C","invoiceType": "4","invoiceNo": "24770357","buyerAddressPhone": "深圳市福田区深南大道40009号投资大厦16楼83883106","salerAccount": "中信银行福南支行7441310182600028010","originalGraphUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_idu003d200242u0026file_idu003d73257535u0026qualityu003d100u0026scodeu003dQWNOb1Q5SE50R1phRjd3V2grSEs5u0026signu003dfae83719f656c923f6762d98d2e42ba3c9997aeau0026widthu003d800","amount": "87143.96","buyerTaxNo": "91440300664187170P","validateMessage": "发票已在报销中,发票抬头与企业名称不一致,发票抬头与企业税号不一致","drawer": "","reviewer": "","invoiceDate": "2019-04-02","buyerName": "环宇机器人（美国）有限公司","invoiceCode": "4403182130","serialNo": "836506eee8e04906acc8a15ea255ab7f0","checkCode": "","checkFlag": 1,"totalAmount": "92605.29","salerAddressPhone": "深圳市福田区投资大厦15楼 0755-83883283","checkTime": "","buyerAccount": "中信银行福南支行7441310182600070147","authenticateTime": "","rotationAngle": "0","snapshotUrl": "https://api.kingdee.com/kdrive/user/file/snapshot?client_idu003d200242u0026file_idu003d65149340u0026qualityu003d100u0026scodeu003dUkhIL0RMRmFLY2FYUUs3L2toTUpyu0026signu003d9456b2a4703dd07da0d293eff146c8eb600bdaf6u0026widthu003d800","taxAmount": "5461.33","totalAmountCn": "","invoiceStatus": "0","items": [{"unitPrice": "69464.3207547170","taxRate": "0.060000","unit": " ","num": "1.0000000000","detailAmount": "69464.32","specModel": " ","goodsCode": "3040801000000000000","taxAmount": "4167.86","goodsName": "*企业管理服务*2019年4月管理费"},{"unitPrice": "14273.4905660377","taxRate": "0.060000","unit": " ","num": "1.0000000000","detailAmount": "14273.49","specModel": " ","goodsCode": "3040000000000000000","taxAmount": "856.41","goodsName": "*现代服务*2019年4月空调服务费"},{"unitPrice": "24.5283018868","taxRate": "0.060000","unit": " ","num": "1.0000000000","detailAmount": "24.53","specModel": " ","goodsCode": "3040000000000000000","taxAmount": "1.47","goodsName": "*现代服务*2019年3月服务费(维修费)"},{"unitPrice": "1.0265486726","taxRate": "0.130000","unit": " ","num": "3255.0000000000","detailAmount": "3341.42","specModel": " ","goodsCode": "1100101020000000000","taxAmount": "434.38","goodsName": "*供电*2019年3月电费"},{"unitPrice": "3.2524271845","taxRate": "0.030000","unit": " ","num": "12.3600000000","detailAmount": "40.20","specModel": " ","goodsCode": "1100300000000000000","taxAmount": "1.21","goodsName": "*水冰雪*2019年3月水费"}],"expenseStatus": "30"},{"salerName": "深圳市深投物业发展有限公司","invoiceMoney": "64773.62","proxyMark": "","downloadUrl": "https://api.kingdee.com/kdrive/user/file/public?client_idu003d200242u0026file_idu003d67155291u0026scodeu003dYTZZekhfS1kwPXlpWnBGZzJySmJnu0026signu003dc639946c91cc28cd6e7ee5f458148ad380734440","remark": "投资大厦14楼C区","authenticateFlag": 1,"payee": "","checkStatus": "1","salerTaxNo": "91440300279371676C","invoiceType": "4","invoiceNo": "21433383","buyerAddressPhone": "深圳市福田区深南大道40009号投资大厦16楼83883106","salerAccount": "中信银行福南支行7441310182600028010","originalGraphUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_idu003d200242u0026file_idu003d73257252u0026qualityu003d100u0026scodeu003dR1V2X04tdXlYUnNmekZjSmlrdEZmu0026signu003dba60245a62746871cd45eb914cc5b09a5835354du0026widthu003d800","amount": "64773.62","buyerTaxNo": "91440300664187170P","validateMessage": "发票抬头与企业名称不一致,发票抬头与企业税号不一致","drawer": "","reviewer": "","invoiceDate": "2020-01-01","buyerName": "深圳市远致投资有限公司","invoiceCode": "4403181130","serialNo": "e901bafdc2dc4a838f82e5f638f7992c0","checkCode": "","checkFlag": 1,"totalAmount": "68512.97","salerAddressPhone": "深圳市福田区投资大厦15楼 0755-83883283","checkTime": "","buyerAccount": "中信银行福南支行7441310182600070147","authenticateTime": "","rotationAngle": "0","snapshotUrl": "https://api.kingdee.com/kdrive/user/file/snapshot?client_idu003d200242u0026file_idu003d67155291u0026qualityu003d100u0026scodeu003dNnJrMSt2VUtKRktKK1pzMStNUnJTu0026signu003dfc02ef55ceb53a4b8b7de30493d50d7bf961ffb9u0026widthu003d800","taxAmount": "3739.35","totalAmountCn": "","invoiceStatus": "0","items": [{"unitPrice": "41996.2857142857","taxRate": "0.050000","unit": " ","num": "1.0000000000","detailAmount": "41996.29","specModel": " ","goodsCode": "3040502000000000000","taxAmount": "2099.81","goodsName": "*经营租赁*2019年1月房屋租金"},{"unitPrice": "16356.8207547170","taxRate": "0.060000","unit": " ","num": "1.0000000000","detailAmount": "16356.82","specModel": " ","goodsCode": "3040801000000000000","taxAmount": "981.41","goodsName": "*企业管理服务*2019年1月管理费"},{"unitPrice": "3644.0094339623","taxRate": "0.060000","unit": " ","num": "1.0000000000","detailAmount": "3644.01","specModel": " ","goodsCode": "3040000000000000000","taxAmount": "218.64","goodsName": "*现代服务*2019年1月空调服务费"},{"unitPrice": "1.0000000000","taxRate": "0.160000","unit": " ","num": "2740.0000000000","detailAmount": "2740.00","specModel": " ","goodsCode": "1100101020000000000","taxAmount": "438.40","goodsName": "*供电*2018年12月电费"},{"unitPrice": "3.2524271845","taxRate": "0.030000","unit": " ","num": "11.2200000000","detailAmount": "36.50","specModel": " ","goodsCode": "1100300000000000000","taxAmount": "1.09","goodsName": "*水冰雪*2018年12月水费"}],"expenseStatus": "1"},{"passengerName": "李志伟","salerName": "","downloadUrl": "https://api.kingdee.com/kdrive/user/file/public?client_id=200242&file_id=77357885&scode=LVhNNz1xOGtmV2twdVpJLVFFOGE3&sign=5ac89634f4b56c06d618b9982ba0b491f9b61d44","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "北京 - 深圳","salerTaxNo": "","airportConstructionFee": "50.00","invoiceType": "10","invoiceNo": "9994532261726","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "","insurancePremium": "0","amount": "730.00","buyerTaxNo": "","otherTotalTaxAmount": "0","validateMessage": "发票已在报销中","invoiceDate": "2019-05-25","buyerName": "","invoiceCode": "20190525","serialNo": "b3a43e7f8a2346f1867a40c426615e0c0","checkFlag": 1,"totalAmount": "780.00","seatGrade": "K","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "0","snapshotUrl": "https://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=77357885&quality=100&scode=QWNOb1Q5SE50R1phRjd3V2grSEs5&sign=1066144b51f9b04bdb84d9f60dbd95c8a07ffac6&width=800","taxAmount": "60.27","totalAmountCn": "","fuelSurcharge": "0","expenseStatus": "60"},{"passengerName": "胡庆松","salerName": "","downloadUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=75607008&quality=100&scode=RGNjVG5FcUc1WlVUcGJpRkFpWlJW&sign=f96b1097cd82c4b0640e3d054f98ece0132982a8&width=800","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "南京 - 大丰","salerTaxNo": "","invoiceType": "16","invoiceNo": "12312900","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=75607008&quality=100&scode=RGNjVG5FcUc1WlVUcGJpRkFpWlJW&sign=f96b1097cd82c4b0640e3d054f98ece0132982a8&width=800","amount": "701.00","buyerTaxNo": "","validateMessage": "","invoiceDate": "2019-05-20","buyerName": "","invoiceCode": "132011881313","serialNo": "26e2c235e83e4a9d933bfdadc5c10a570","checkFlag": 1,"totalAmount": "701.00","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "180","snapshotUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=75607008&quality=100&scode=RGNjVG5FcUc1WlVUcGJpRkFpWlJW&sign=f96b1097cd82c4b0640e3d054f98ece0132982a8&width=800","taxAmount": "0","totalAmountCn": "","expenseStatus": "1"},{"passengerName": "李志伟","salerName": "","downloadUrl": "https://api.kingdee.com/kdrive/user/file/public?client_id=200242&file_id=77357943&scode=X3RrM19wai1KcS8zK01mL0JjRjl1&sign=1630331715830ae9f359b1136dbf4ecf5bc52d97","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "深圳 - 北京","salerTaxNo": "","airportConstructionFee": "50.00","invoiceType": "10","invoiceNo": "8804532397082","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "","insurancePremium": "0","amount": "1350.00","buyerTaxNo": "","otherTotalTaxAmount": "0","validateMessage": "发票已在报销中","invoiceDate": "2019-05-19","buyerName": "","invoiceCode": "20190519","serialNo": "ff0283a0a41842feb1ed65777ee126550","checkFlag": 1,"totalAmount": "1400.00","seatGrade": "X","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "0","snapshotUrl": "https://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=77357943&quality=100&scode=WTI1PUtyYnhKbnBoaFlZYklZV0xu&sign=cb0b18489bbce350c784a8f342afdcd2c34fe033&width=800","taxAmount": "111.47","totalAmountCn": "","fuelSurcharge": "0","expenseStatus": "60"},{"passengerName": "庄嘉盛","salerName": "","downloadUrl": "https://api.kingdee.com/kdrive/user/file/public?client_id=200242&file_id=76695942&scode=dmtxPXRhb3F1eFdqbl9qYl95bUNV&sign=4b08f18b2965c3c120629872b46372ac9bc67259","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "昆明 - 成都","salerTaxNo": "","invoiceType": "9","invoiceNo": "A013415","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "","amount": "138.50","buyerTaxNo": "","validateMessage": "","invoiceDate": "2019-05-02","buyerName": "","invoiceCode": "20190502","serialNo": "aadf75cfec584963b2bd437f53bcf81b0","checkFlag": 1,"totalAmount": "138.50","seatGrade": "新空调硬座","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "0","snapshotUrl": "https://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=76695942&quality=100&scode=M2xLNWZqUW42RC1ubURINjBIN05q&sign=e8d62752dc703443f6912650244f502c07f417d7&width=800","taxAmount": "0","totalAmountCn": "","expenseStatus": "1"},{"passengerName": "张恩琴","salerName": "","downloadUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=69103850&quality=100&scode=Y3ZmUDlValNIampnQm0yTzFBK25p&sign=d0c0129bf58c4aa0808dcfcd5096b95f852b0c44&width=800","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "深圳 - 北京","salerTaxNo": "","airportConstructionFee": "50.00","invoiceType": "10","invoiceNo": "8802188971952","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=69103850&quality=100&scode=Y3ZmUDlValNIampnQm0yTzFBK25p&sign=d0c0129bf58c4aa0808dcfcd5096b95f852b0c44&width=800","insurancePremium": "0","amount": "1695.00","buyerTaxNo": "","otherTotalTaxAmount": "0","validateMessage": "","invoiceDate": "2019-04-10","buyerName": "","invoiceCode": "20190410","serialNo": "65e116d17a2643b0bf18ddc831764e220","checkFlag": 1,"totalAmount": "1745.00","seatGrade": "L","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "90","snapshotUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=69103850&quality=100&scode=Y3ZmUDlValNIampnQm0yTzFBK25p&sign=d0c0129bf58c4aa0808dcfcd5096b95f852b0c44&width=800","taxAmount": "0","totalAmountCn": "","fuelSurcharge": "0","expenseStatus": "1"},{"passengerName": "徐莎莎","salerName": "","downloadUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=66601001&quality=100&scode=YTNzZ2FTRUlMaU56TDhMR3lySm95&sign=f6184303bda424427d884c3e1ae45cc1068a05ae&width=800","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "晋江 - 深圳","salerTaxNo": "","invoiceType": "9","invoiceNo": "C078011","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=66601001&quality=100&scode=YTNzZ2FTRUlMaU56TDhMR3lySm95&sign=f6184303bda424427d884c3e1ae45cc1068a05ae&width=800","amount": "273.50","buyerTaxNo": "","validateMessage": "发票已在报销中","invoiceDate": "2019-02-17","buyerName": "","invoiceCode": "20190217","serialNo": "798b5942a08b4193a2a360db3d1ac7d30","checkFlag": 1,"totalAmount": "273.50","seatGrade": "新空调硬卧","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "0","snapshotUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=66601001&quality=100&scode=YTNzZ2FTRUlMaU56TDhMR3lySm95&sign=f6184303bda424427d884c3e1ae45cc1068a05ae&width=800","taxAmount": "0","totalAmountCn": "","expenseStatus": "60"},{"passengerName": "段友爱","salerName": "","downloadUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=73908833&quality=100&scode=X3RrM19wai1KcS8zK01mL0JjRjl1&sign=d76e964331b4d2550ffedea0893e44c3c800dc5c&width=800","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "九江 - 深圳","salerTaxNo": "","invoiceType": "9","invoiceNo": "B026623","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=73908833&quality=100&scode=X3RrM19wai1KcS8zK01mL0JjRjl1&sign=d76e964331b4d2550ffedea0893e44c3c800dc5c&width=800","amount": "294.50","buyerTaxNo": "","validateMessage": "发票已在报销中","invoiceDate": "2019-02-17","buyerName": "","invoiceCode": "20190217","serialNo": "7820fab00aef4a6ab9bc43169ea9116d0","checkFlag": 1,"totalAmount": "294.50","seatGrade": "新空调硬卧","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "90","snapshotUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=73908833&quality=100&scode=X3RrM19wai1KcS8zK01mL0JjRjl1&sign=d76e964331b4d2550ffedea0893e44c3c800dc5c&width=800","taxAmount": "0","totalAmountCn": "","expenseStatus": "30"},{"passengerName": "段友爱","salerName": "","downloadUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=76566814&quality=100&scode=SUMtRDVNRFZ2Rm5wL2NKdnVMVUxi&sign=a14e2c0cfa676bd165882c2c2031d83cccfa924d&width=800","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "九江 - 深圳","salerTaxNo": "","invoiceType": "9","invoiceNo": "B626623","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=76566814&quality=100&scode=SUMtRDVNRFZ2Rm5wL2NKdnVMVUxi&sign=a14e2c0cfa676bd165882c2c2031d83cccfa924d&width=800","amount": "294.50","buyerTaxNo": "","validateMessage": "","invoiceDate": "2019-02-17","buyerName": "","invoiceCode": "20190217","serialNo": "0057ec38b49e4315a03d0f995c90ae8f0","checkFlag": 1,"totalAmount": "294.50","seatGrade": "新空调硬卧","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "90","snapshotUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=76566814&quality=100&scode=SUMtRDVNRFZ2Rm5wL2NKdnVMVUxi&sign=a14e2c0cfa676bd165882c2c2031d83cccfa924d&width=800","taxAmount": "0","totalAmountCn": "","expenseStatus": "1"},{"passengerName": "谢少云","salerName": "","downloadUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=75678558&quality=100&scode=clNST2U0UUh5YjYySD0yT08yRWR6&sign=7d80d71ac00af38bd14c535f5ce53f799e044fc9&width=800","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "台州路桥 - 武汉","salerTaxNo": "","airportConstructionFee": "50.00","invoiceType": "10","invoiceNo": "8112319255180","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=75678558&quality=100&scode=clNST2U0UUh5YjYySD0yT08yRWR6&sign=7d80d71ac00af38bd14c535f5ce53f799e044fc9&width=800","insurancePremium": "0","amount": "510.00","buyerTaxNo": "","otherTotalTaxAmount": "0","validateMessage": "发票已在报销中","invoiceDate": "2019-03-23","buyerName": "","invoiceCode": "20180323","serialNo": "18911fd08e0c4011b4789924028fb8b00","checkFlag": 1,"totalAmount": "560.00","seatGrade": "E","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "0","snapshotUrl": "http://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=75678558&quality=100&scode=clNST2U0UUh5YjYySD0yT08yRWR6&sign=7d80d71ac00af38bd14c535f5ce53f799e044fc9&width=800","taxAmount": "0","totalAmountCn": "","fuelSurcharge": "0","expenseStatus": "60"},{"passengerName": "徐华云","salerName": "","downloadUrl": "https://api.kingdee.com/kdrive/user/file/public?client_id=200242&file_id=77357819&scode=RWwtTmFqY2hBNkJ6ZjlQNE5yVXE2&sign=2758c5ac6fafaab411e853741383af3dcb5f9756","remark": "","authenticateFlag": 1,"checkStatus": "1","trip": "深圳 - 台州路桥","salerTaxNo": "","airportConstructionFee": "50.00","invoiceType": "10","invoiceNo": "4792117406499","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "","insurancePremium": "0","amount": "1130.00","buyerTaxNo": "","otherTotalTaxAmount": "0","validateMessage": "发票已在报销中","invoiceDate": "2019-03-18","buyerName": "","invoiceCode": "20180318","serialNo": "a98d2a19c4254651a57d4b28a08eee696","checkFlag": 1,"totalAmount": "1180.00","seatGrade": "Y","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "90","snapshotUrl": "https://api.kingdee.com/kdrive/user/file/thumbnail?client_id=200242&file_id=77357819&quality=100&scode=OGEzZWRzWTNOaWV5R3dkYU5SMVJh&sign=e23ce4a26c34adcfe333a52ce75d773de8939ceb&width=800","taxAmount": "0","totalAmountCn": "","fuelSurcharge": "0","expenseStatus": "30"},{"currencyType": "RMB","passengerName": "李伟康","stationGetOn": "淄博","salerName": "","downloadUrl": "https://api.kingdee.com/kdrive/user/file/public?client_id\u003d200242\u0026file_id\u003d128390419\u0026scode\u003dTlIzY1A1SFNlSUVnSDJ4RXNVaGxF\u0026sign\u003d5df9289e1212984af596c482ac6a0ebe6fa961eb","authenticateFlag": 1,"departurePosition": {"area": "张店区","province": "山东省","city": "淄博市"},"checkStatus": 3,"trip": "淄博 - 淄博","stationGetOff": "淄博","salerTaxNo": "","invoiceType": "16","invoiceNo": "00421180","pixel": "755,396","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "https://api.kingdee.com/kdrive/user/file/public?client_id\u003d200242\u0026file_id\u003d128390419\u0026scode\u003dTlIzY1A1SFNlSUVnSDJ4RXNVaGxF\u0026sign\u003d5df9289e1212984af596c482ac6a0ebe6fa961eb","amount": "19.42","buyerTaxNo": "","validateMessage": "发票已在报销中","buyerName": "","invoiceDate": "2019-06-15","invoiceCode": "137031992002","serialNo": "aa451ea848c649ea93f2b25804b5c04d0","checkFlag": 1,"totalAmount": "20.00","taxRate": "0.030000","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "0","snapshotUrl": "https://api.kingdee.com/kdrive/user/file/thumbnail?client_id\u003d200242\u0026file_id\u003d128390419\u0026quality\u003d100\u0026scode\u003dcldyRm5zTDhqT3hWRDRqVDVnODZr\u0026sign\u003d92c4acf511f39ba7c444fed5367ea84063f68de8\u0026width\u003d800","isRevise": "1","destinationPosition": {"area": "张店区","province": "山东省","city": "淄博市"},"time": "","taxAmount": "0.58","totalAmountCn": "","region": "[0,0,755,396]","expenseStatus": "60"},{"currencyType": "RMB","passengerName": "李伟康","stationGetOn": "淄博","salerName": "","downloadUrl": "https://api.kingdee.com/kdrive/user/file/public?client_id\u003d200242\u0026file_id\u003d128390509\u0026scode\u003ddmtxPXRhb3F1eFdqbl9qYl95bUNV\u0026sign\u003daa372b6c6bd38580a89a889750d3997751b02317","authenticateFlag": 1,"departurePosition": {"area": "张店区","province": "山东省","city": "淄博市"},"checkStatus": 3,"trip": "淄博 - 淄博","stationGetOff": "淄博","salerTaxNo": "","invoiceType": "16","invoiceNo": "04216007","pixel": "722,401","buyerAddressPhone": "","salerAccount": "","originalGraphUrl": "https://api.kingdee.com/kdrive/user/file/public?client_id\u003d200242\u0026file_id\u003d128390509\u0026scode\u003ddmtxPXRhb3F1eFdqbl9qYl95bUNV\u0026sign\u003daa372b6c6bd38580a89a889750d3997751b02317","amount": "19.42","buyerTaxNo": "","validateMessage": "发票已在报销中","buyerName": "","invoiceDate": "2019-06-06","invoiceCode": "137031892002","serialNo": "997798241cb342299daa60df226d148a0","checkFlag": 1,"totalAmount": "20.00","taxRate": "0.030000","salerAddressPhone": "","checkTime": "","buyerAccount": "","authenticateTime": "","rotationAngle": "0","snapshotUrl": "https://api.kingdee.com/kdrive/user/file/thumbnail?client_id\u003d200242\u0026file_id\u003d128390509\u0026quality\u003d100\u0026scode\u003dSk9rRlVPTldiR3JkLUIxbz1CUFlE\u0026sign\u003df6dbbd77e0dfcf101a1940119d7f7634f0513ff2\u0026width\u003d800","isRevise": "2","destinationPosition": {"area": "张店区","province": "山东省","city": "淄博市"},"time": "","taxAmount": "0.58","totalAmountCn": "","region": "[0,0,722,401]","expenseStatus": "60"}]}','A',1160063587109202944,'unittest');

/** 预置单元测试数据多语言 */
delete from t_er_invoicedatapre_l where fpkid = '20W=7NPRVE0M';
INSERT INTO t_er_invoicedatapre_l (fpkid,fid,flocaleid,fname) VALUES 
('20W=7NPRVE0M',1293555207342396416,'zh_CN','单元测试用的发票:增值税票+飞机票+火车票+汽车票');

delete from t_er_invoicedatapre_l where fpkid = '20W=7NPRVE0N';
INSERT INTO t_er_invoicedatapre_l (fpkid,fid,flocaleid,fname) VALUES 
('20W=7NPRVE0N',1293555207342396416,'zh_TW','單元測試用的發票:增值稅票+飛機票+火車票+汽車票');