delete from T_ER_TRIP_FIELDMAPPING  where fid = 1687611640763512832;
delete from T_ER_TRIP_QUERYENTRY  where fid = 1687611640763512832;
delete from T_ER_TRIP_FILTERENTRY  where fid = 1687611640763512832;
delete from T_ER_TRIP_IGNOREEXENTRY  where fid = 1687611640763512832;
delete from T_ER_TRIP_FIELDMAPENTRY  where fid = 1687611640763512832;
delete from T_ER_TRIP_FIELDMAPPING_L  where fid = 1687611640763512832;

INSERT INTO t_er_trip_fieldmapping (fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fserver, fporttype, ffunction, furl, fparamsjson, fparamsjson_tag, fdatajson, fdatajson_tag, fisdefault, fclassforname, fmethod, fsynctype) VALUES (1687611640763512832, 'C_trip_status', '携程_出差申请单状态同步', 'C', 1205612035459523584, 1205612035459523584, '0', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'}, 1687611640763512832, 139500340868311041, 'push', 'er_tripreqbill', 'https://ct.ctrip.com/switchapi/approval.svc/rest/setapproval', '已录入参数', '{"request":{
	"Status":0,
	"Auth":{
		"Ticket":"1",
		"AppKey":"obk_kingdee"
	},
	"ApprovalNumber":"CCSQ",
	"FlightEndorsementDetails":[
		{
			"ProductType":"1",
			"FlightWay":"2"
		}
	],
	"EmployeeID":"ID-0008140"
}}', '已录入参数', '
{"SetApprovalResult":{"Status":{"ErrorCode":0,"Message":"","Success":true}}}', '1', 'kd.fi.er.business.trip.v2.server.ctrip.CtripReqInvoke#execute',  'POST', '2');

INSERT INTO t_er_trip_fieldmapping_l (fpkid, fid, flocaleid, fname) VALUES ('3==6+5/B5ZTF', 1687611640763512832, 'zh_CN', '携程_出差申请单状态同步');
INSERT INTO t_er_trip_fieldmapping_l (fpkid, fid, flocaleid, fname) VALUES ('3==6+5/B5ZTG', 1687611640763512832, 'zh_TW', '攜程_出差申請單狀態同步');
INSERT INTO t_er_trip_queryentry (fid, fentryid, fseq,  fqueryfield, fqueryvalue, fquerypluginvalue,fquerydesc, fqueryleftbracket, fquerycondition, fqueryrightbracket, fquerylogic, fqueryisdefault, fquerystatus, fquerypluginvalueext, fquerycreatetime, fquerymodifytime) VALUES (1687611640763512832, 1687611640797067265, 2, 'billstatus', 'A,D,H,I', ' ',  '单据头.单据状态', ' ', 'in', ' ', ' ', '1', '1', ' ', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_queryentry (fid, fentryid, fseq,  fqueryfield, fqueryvalue, fquerypluginvalue,fquerydesc, fqueryleftbracket, fquerycondition, fqueryrightbracket, fquerylogic, fqueryisdefault, fquerystatus, fquerypluginvalueext, fquerycreatetime, fquerymodifytime) VALUES (1687611640763512832, 1687611640797067264, 1,  'billno', ' ', 'kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getValueByParams',  '单据头.编号', ' ', '=', ' ', 'and', '1', '1', ' ',{ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_fieldmapentry (fid, fentryid, fseq, fmaptargetfield, fmaptargetfielddesc, fmapsourcefield, fmaptype, fmapdesign, fmapsourcefieldext, fmaptypeext, fmapdesignext, fmapprimarykey, fmapdesc, fmapisdefault, fmapstatus, fmapcreatetime, fmapmodifytime) VALUES (1687611640763512832, 1687615798551902208, 1, 'request.Status', '状态', ' ', '2', '0', ' ', ' ', ' ', '0', ' ', '1', '1', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_fieldmapentry (fid, fentryid, fseq, fmaptargetfield, fmaptargetfielddesc, fmapsourcefield, fmaptype, fmapdesign, fmapsourcefieldext, fmaptypeext, fmapdesignext, fmapprimarykey, fmapdesc, fmapisdefault, fmapstatus, fmapcreatetime, fmapmodifytime) VALUES (1687611640763512832, 1687615798551902210, 3, 'request.Auth.AppKey', 'appkey', ' ', '4', 'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey', ' ', ' ', ' ', '0', ' ', '1', '1', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_fieldmapentry (fid, fentryid, fseq, fmaptargetfield, fmaptargetfielddesc, fmapsourcefield, fmaptype, fmapdesign, fmapsourcefieldext, fmaptypeext, fmapdesignext, fmapprimarykey, fmapdesc, fmapisdefault, fmapstatus, fmapcreatetime, fmapmodifytime) VALUES (1687611640763512832, 1687615798551902211, 4, 'request.ApprovalNumber', '审批单号', 'billno', '1', ' ', ' ', ' ', ' ', '1', '单据头.单据编号', '1', '1', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_fieldmapentry (fid, fentryid, fseq, fmaptargetfield, fmaptargetfielddesc, fmapsourcefield, fmaptype, fmapdesign, fmapsourcefieldext, fmaptypeext, fmapdesignext, fmapprimarykey, fmapdesc, fmapisdefault, fmapstatus, fmapcreatetime, fmapmodifytime) VALUES (1687611640763512832, 1687615798551902212, 5, 'request.FlightEndorsementDetails.[0].ProductType', '1:国内机票 ,2国际机票', ' ', '2', '1', ' ', ' ', ' ', '0', ' ', '1', '1', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_fieldmapentry (fid, fentryid, fseq, fmaptargetfield, fmaptargetfielddesc, fmapsourcefield, fmaptype, fmapdesign, fmapsourcefieldext, fmaptypeext, fmapdesignext, fmapprimarykey, fmapdesc, fmapisdefault, fmapstatus, fmapcreatetime, fmapmodifytime) VALUES (1687611640763512832, 1687615798551902213, 6, 'request.FlightEndorsementDetails.[0].FlightWay', '1:单程,2:往返', ' ', '2', '2', ' ', ' ', ' ', '0', ' ', '1', '1', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_fieldmapentry (fid, fentryid, fseq, fmaptargetfield, fmaptargetfielddesc, fmapsourcefield, fmaptype, fmapdesign, fmapsourcefieldext, fmaptypeext, fmapdesignext, fmapprimarykey, fmapisdefault, fmapstatus, fmapdesc, fmapcreatetime, fmapmodifytime) VALUES (1687611640763512832, 1687615798551902214, 7, 'request.EmployeeID', '员工工号', ' ', '3', 'creator.number+'',''+ applier.number', ' ', ' ', ' ', '0', '1', '1', 'number', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_fieldmapentry (fid, fentryid, fseq, fmaptargetfield, fmaptargetfielddesc, fmapsourcefield, fmaptype, fmapdesign, fmapsourcefieldext, fmaptypeext, fmapdesignext, fmapprimarykey, fmapdesc, fmapisdefault, fmapstatus, fmapcreatetime, fmapmodifytime) VALUES (1687611640763512832, 1687615798551902209, 2, 'request.Auth.Ticket', 'ticket', ' ', '5', 'C_ticket', ' ', ' ', ' ', '0', ' ', '1', '1', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});
INSERT INTO t_er_trip_ignoreexentry (fid, fseq, fentryid, fexnumber, fexfield, fexdesc, fexisdefault, fexstatus, fexcreatetime, fexmodifytime) VALUES (1687611640763512832, 1, 1690484334655832064, 'true', 'SetApprovalResult.Status.Success', ' ', '1', '1', {ts'2023-05-10  00:00:00'}, {ts'2023-05-10  00:00:00'});

