/** 商旅字段映射：美亚-确认账单并申请开票*/
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2102336869177362432;
INSERT INTO T_ER_TRIP_FIELDMAPPING(FID,FSERVER,FDATAJSON_TAG,FURL,FISDEFAULT,FMASTERID,FMETHOD,FSTATUS,FNUMBER,FNAME,FSYNCTYPE,FDATAJSON,FCREATETIME,FPORTTYPE,FENABLE,FMODIFIERID,FFUNCTION,FMODIFYTIME,FPARAMSJSON_TAG,FCLASSFORNAME,FCREATORID,FPARAMSJSON) VALUES (2102336869177362432,1966138761855480832,'{
	"code":"500",
	"confirmedAmount":109.89,
	"invoiceNumber":"[\"MY_ZD240000143800_train_20240816\"]",
	"errmsg":"账单确认失败。",
	"settleInfos":[
		{
			"confirmedAmount":109.89,
			"invoiceNumber":"[\"MY_ZD240000143800_train_20240816\"]"
		}
	],
	"isSucceed":true
}','http://testapi.shinetour.com/API.svc/ConfirmBillApplyInvoicing','1',2102336869177362432,'POST','C','M_ApplyInvoicing','美亚-确认账单并申请开票',' ','已录入参数。',{ts'2024-12-10  00:00:00'},'push','1',1996320338723934208,'er_checkingbill',{ts'2024-12-30  00:00:00'},'{
	"companyCode":"S118058",
	"confirmedAmount":109.89,
	"documentType":0,
	"pageIndex":1,
	"settlementBatchNumber":[
		"MY_ZD240000143800_train_20240816",
		"MY_ZD240000138890_iflight_20240802",
		"MY_ZD240000138890_hotel_20240802"
	],
	"pageSize":200,
	"invoice":{
		"bankAccount":"ABC支行8258521013300112255",
		"unit":"无",
		"specificationModel":"无",
		"contactPersonName":"刘展超",
		"invoiceRemarks":"无",
		"deliveryAddress":"广州大道北520",
		"addressAndPhone":"开发区025-12358088",
		"contactPersonPhone":"13115011234",
		"taxpayerNumber":"91320191MA1MNRW1X7",
		"invoiceTitle":"美亚营销有限公司",
		"email":"abcef@meiya.com"
	},
	"sessionId":"7f68b4d600744842b12aea8699be9146202412091539351676OA",
	"invoiceTitle":""
}','kd.fi.er.business.trip.v2.function.PushInvoke#execute',1996320338723934208,'已录入参数。'); 
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4L82LTE4056F';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2102336869177362432,'4L82LTE4056F','zh_CN','美亚-确认账单并申请开票'); 
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2102336869319968768;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2102336869177362432,'=',' ',' ',2102336869319968768,' ',' ','1',{ts'2024-12-10  00:00:00'},{ts'2024-12-10  00:00:00'},'billnum','单据头.账单编号',1,'1','and','kd.fi.er.business.trip.v2.plugin.mtrip.MTripConfirmBillPlugin#getBillnum'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844868;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','0为结算批次号',' ',' ',2102336869319844868,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'0',3,'2','documentType','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844869;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','月结账单编号',' ',' ',2102336869319844869,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripConfirmBillPlugin#getSettleSerialNos',4,'4','settlementBatchNumber','1'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844872;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','发票抬头',' ',' ',2102336869319844872,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',7,'4','invoice.invoiceTitle','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844873;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','纳税人识别号',' ',' ',2102336869319844873,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',8,'4','invoice.taxpayerNumber','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844874;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','地址电话',' ',' ',2102336869319844874,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',9,'4','invoice.addressAndPhone','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844875;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','开户行及账号',' ',' ',2102336869319844875,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',10,'4','invoice.bankAccount','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844876;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','联系人-姓名',' ',' ',2102336869319844876,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',11,'4','invoice.contactPersonName','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844877;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','配送地址 用于配送纸质发票/行程单',' ',' ',2102336869319844877,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',12,'4','invoice.deliveryAddress','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844878;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','邮箱用于接收发票',' ',' ',2102336869319844878,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',13,'4','invoice.email','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844866;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','月结账单费用承担公司在服务商设置对应的账户id',' ',' ',2102336869319844866,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',1,'4','companyCode','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844867;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','取账单确认上的发票抬头',' ',' ',2102336869319844867,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getJValueByParams',2,'4','invoiceTitle','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844870;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ','单据头.结算金额',' ',' ',2102336869319844870,'1',{ts'2024-12-10  00:00:00'},'settlementamount',{ts'2024-12-10  00:00:00'},' ',5,'1','confirmedAmount','0'); 
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2102336869319844871;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2102336869177362432,' ','1',' ',' ',' ',' ',2102336869319844871,'1',{ts'2024-12-10  00:00:00'},' ',{ts'2024-12-30  00:00:00'},'kd.fi.er.business.trip.v2.plugin.mtrip.MTripPlugin#getSessionId',6,'4','sessionId','0'); 
DELETE FROM T_ER_TRIP_IGNOREEXENTRY WHERE FENTRYID = 2102336869319968769;
INSERT INTO T_ER_TRIP_IGNOREEXENTRY(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (2102336869177362432,' ','1','200',{ts'2024-12-10  00:00:00'},'code',2102336869319968769,'1',1,{ts'2024-12-10  00:00:00'}); 
