DELETE FROM t_er_trip_fieldmapping WHERE FID = 1753688526471369728;
DELETE FROM t_er_trip_fieldmapping_l WHERE FID = 1753688526471369728;
DELETE FROM t_er_trip_queryentry WHERE FID = 1753688526471369728;
DELETE FROM t_er_trip_filterentry WHERE FID = 1753688526471369728;
DELETE FROM t_er_trip_fieldmapentry WHERE FID = 1753688526471369728;
DELETE FROM t_er_trip_ignoreexentry WHERE FID = 1753688526471369728;


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 (1753688526471369728,139500340868311041,'{
	"status":{
		"success":true,
		"errorCode":0,
		"message":""
	}
}','https://corpsz.ctrip.com/PreApproval/saveBudget','1',1753688526471369728,'POST','C','C_Budget','携程-预算数据落地','1','已录入参数',{ts'2023-08-17  00:00:00'},'push','0',13466739,'er_tripreqbill',{ts'2023-10-23  00:00:00'},'{
	"ActionType":"cover",
	"Language":{},
	"BudgetInfoList":[
		{
			"Products":543,
			"BudgetAmount":123
		}
	],
	"Signature":"string",
	"Auth":{
		"Ticket":"ticket",
		"AppKey":"appKey"
	},
	"ApprovalNumber":"billNo"
}','kd.fi.er.business.trip.v2.server.ctrip.CtripBudgetInvoke#execute',13466739,'已录入参数');

INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1753688526471369728,'3HDR5=HE2+IF','zh_CN','携程-预算数据落地');
INSERT INTO t_er_trip_fieldmapping_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1753688526471369728,'3HDR5=HE2+IG','zh_TW','攜程-預算數據落地');

INSERT INTO t_er_trip_queryentry(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1753688526471369728,'=',' ',' ',1753688527058572288,' ',' ','1',{ts'2023-08-17  00:00:00'},{ts'2023-10-23  00:00:00'},'billno','单据头.单据编号',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams');

INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1753688526471369728,' ','1',' ','操作类型，覆盖更新','操作类型',' ',1753688527058571266,'1',{ts'2023-08-17  00:00:00'},' ',{ts'2023-08-17  00:00:00'},'cover',1,'2','ActionType','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1753688526471369728,' ','1',' ','单据头.单据编号','审批单号',' ',1753688527058571267,'1',{ts'2023-08-17  00:00:00'},'billno',{ts'2023-08-17  00:00:00'},' ',2,'1','ApprovalNumber','1');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1753688526471369728,' ','1',' ','单据头.核定金额','预算金额',' ',1753688527058571268,'1',{ts'2023-08-17  00:00:00'},'approveamount',{ts'2023-08-17  00:00:00'},' ',3,'1','BudgetInfoList.[0].BudgetAmount','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1753688526471369728,' ','1',' ','管控产品类型编号综合，固定值543','预算管控产品值',' ',1753688527058571269,'1',{ts'2023-08-17  00:00:00'},' ',{ts'2023-08-17  00:00:00'},'543',4,'2','BudgetInfoList.[0].Products','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1753688526471369728,' ','1',' ','通过传参，hash计算出签名','签名',' ',1753688527058571270,'1',{ts'2023-08-17  00:00:00'},' ',{ts'2023-08-24  00:00:00'},'kd.fi.er.business.trip.v2.plugin.ctrip.CtripPlugin#createBudgetSign',5,'4','Signature','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1753688526471369728,' ','1',' ','token','token',' ',1753688527058571271,'1',{ts'2023-08-17  00:00:00'},' ',{ts'2023-08-17  00:00:00'},'C_ticket',6,'5','Auth.Ticket','0');
INSERT INTO t_er_trip_fieldmapentry(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1753688526471369728,' ','1',' ','appKey',' ',' ',1753688527058571272,'1',{ts'2023-08-17  00:00:00'},' ',{ts'2023-08-17  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey',7,'4','Auth.AppKey','0');

INSERT INTO t_er_trip_ignoreexentry(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1753688526471369728,' ','1','true',{ts'2023-08-24  00:00:00'},'status.success',1758721717905584128,'1',1,{ts'2023-10-23  00:00:00'});
INSERT INTO t_er_trip_ignoreexentry(FID,FEXDESC,FEXISDEFAULT,FEXNUMBER,FEXCREATETIME,FEXFIELD,FENTRYID,FEXSTATUS,FSEQ,FEXMODIFYTIME) VALUES (1753688526471369728,' ','1','0',{ts'2023-08-24  00:00:00'},'status.errorCode',1758721717905584129,'1',2,{ts'2023-10-23  00:00:00'});
