DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1913742913322848256;
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 (1913742913322848256,1015862345630818304,' ','https://api.es.xiaojukeji.com/river/Bill/getBillStructure','1',1913742913322848256,'GET','C','D_SyncCheckBill_List','滴滴-月结账单同步',' ','已录入参数',{ts'2024-03-25  00:00:00'},'pull','1',1448586489507464192,'er_checkingbill',{ts'2024-03-29  00:00:00'},'{
	"access_token":"c98157ffca54899bf7fada90bdbc24cadfb5ff6f",
	"offset":0,
	"company_id":"1125920501298861",
	"business_type":"",
	"payment_period":"2024-02-01~2024-02-29",
	"length":100,
	"sign":"9044788d45bbeabf093dd9b0d0472e10",
	"client_id":"1d7b994121c65ffe408066f9d4fac768",
	"timestamp":"1709287051"
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncCheckInvoke#execute',1448586489507464192,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4/1JMW/Y6CDI';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1913742913322848256,'4/1JMW/Y6CDI','zh_CN','滴滴-月结账单同步');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4/1JMW/Y6CDJ';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1913742913322848256,'4/1JMW/Y6CDJ','zh_TW','滴滴-月結賬單同步');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1914418925849110528;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1913742913322848256,'=',' ',' ',1914418925849110528,'D_Token',' ','1',{ts'2024-03-26  00:00:00'},{ts'2024-03-26  00:00:00'},'access_token',' ',1,'1','and','kd.fi.er.business.trip.v2.plugin.ParamsPlugin#getToken');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1914418925849110529;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1913742913322848256,'=',' ',' ',1914418925849110529,' ',' ','1',{ts'2024-03-26  00:00:00'},{ts'2024-03-26  00:00:00'},'company_id',' ',2,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1914423214684334080;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1913742913322848256,'=',' ',' ',1914423214684334080,' ',' ','1',{ts'2024-03-26  00:00:00'},{ts'2024-03-26  00:00:00'},'timestamp',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1914423214684334081;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1913742913322848256,'=',' ',' ',1914423214684334081,' ',' ','1',{ts'2024-03-26  00:00:00'},{ts'2024-03-26  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1914423214684334082;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1913742913322848256,'=',' ',' ',1914423214684334082,' ',' ','1',{ts'2024-03-26  00:00:00'},{ts'2024-03-26  00:00:00'},'client_id',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1914423214684334084;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1913742913322848256,'=',' ',' ',1914423214684334084,'2',' ','1',{ts'2024-03-26  00:00:00'},{ts'2024-03-26  00:00:00'},'business_type',' ',7,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 1914423214684334083;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (1913742913322848256,'=',' ',' ',1914423214684334083,' ',' ','1',{ts'2024-03-26  00:00:00'},{ts'2024-03-29  00:00:00'},'payment_period',' ',6,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getPaymentPeriod');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 1915330010139766784;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1913742913322848256,'1','!=','data.list.[0].pid','0','1',1915330010139766784,' ',{ts'2024-03-29  00:00:00'},'and',{ts'2024-03-27  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 1916627624332146688;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (1913742913322848256,'1','in','data.list.[0].sub_bill_summary.[0].business_type','201,202,203,204,205','1',1916627624332146688,' ',{ts'2024-03-29  00:00:00'},'and',{ts'2024-03-29  00:00:00'},' ',2,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915337706335285252;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.费用承担公司',' ',1915337706335285252,'1',{ts'2024-03-27  00:00:00'},'data.list.[0].out_budget_id',{ts'2024-03-27  00:00:00'},' ',8,'1','settlemain','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915337706335285251;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.账单编号',' ',1915337706335285251,'1',{ts'2024-03-27  00:00:00'},'data.list.[0].bill_id',{ts'2024-03-28  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillNum',2,'4','billnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915315214589696000;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.单据编号',' ',1915315214589696000,'1',{ts'2024-03-27  00:00:00'},'data.list.[0].sub_bill_summary.[0].business_type',{ts'2024-03-28  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillNum',3,'4','billno','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915315214589696001;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.结算金额',' ',1915315214589696001,'1',{ts'2024-03-27  00:00:00'},'data.list.[0].sub_bill_summary.[0].amount_money',{ts'2024-03-29  00:00:00'},' ',4,'1','settlementamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915337706335285248;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.服务商',' ',1915337706335285248,'1',{ts'2024-03-27  00:00:00'},' ',{ts'2024-03-28  00:00:00'},'DIDI',5,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915337706335285249;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.创建时间',' ',1915337706335285249,'1',{ts'2024-03-27  00:00:00'},' ',{ts'2024-03-28  00:00:00'},'NOW()',6,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915337706335285250;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.创建人',' ',1915337706335285250,'1',{ts'2024-03-27  00:00:00'},' ',{ts'2024-03-28  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',7,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1916088810928987136;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.单据状态',' ',1916088810928987136,'1',{ts'2024-03-28  00:00:00'},' ',{ts'2024-03-28  00:00:00'},'A',11,'2','billstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1929679785592946688;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.账单起始日',' ',1929679785592946688,'1',{ts'2024-04-16  00:00:00'},' ',{ts'2024-04-16  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getPeriodStart',11,'4','periodstartdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1929679785592946689;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.账单截止日',' ',1929679785592946689,'1',{ts'2024-04-16  00:00:00'},' ',{ts'2024-04-16  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getPeriodEnd',12,'4','periodenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1931358897336484864;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.账单状态',' ',1931358897336484864,'1',{ts'2024-04-18  00:00:00'},' ',{ts'2024-04-18  00:00:00'},'1',13,'2','billstatusname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1933996683797388288;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.币种',' ',1933996683797388288,'1',{ts'2024-04-22  00:00:00'},' ',{ts'2024-04-22  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',14,'4','currency','0');


-- 更新原有的字段映射 废弃掉
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 1802166827372003328;
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 (1802166827372003328,1015862345630818304,'{
	"errno":"1",
	"data":{
		"total":1,
		"records":[
			{
				"bill_id":1125922582836226,
				"end_date":"",
				"groupType":0,
				"bill_amount":14.9,
				"bill_difference":0,
				"bill_period":"2023年07月01日 - 2023年07月31日",
				"root_batch_id":0,
				"companyName":"",
				"bill_consumption":14.9,
				"bill_status":1,
				"bill_refund":0,
				"companyId":"",
				"start_date":"",
				"status":0
			}
		]
	},
	"errmsg":"1"
}','https://api.es.xiaojukeji.com/river/Bill/get','1',1802166827372003328,'GET','C','D_SyncCheck_List','滴滴-月结账单同步(废弃)',' ','已录入参数',{ts'2023-10-23  00:00:00'},'pull','0',1925266062056993792,'er_checkingbill',{ts'2024-04-10  00:00:00'},'{
	"access_token":"611344",
	"bill_stsatus":1,
	"company_id":"car_lixingffcamia1",
	"offset":5,
	"last_id":"4",
	"sign":"car_lixingffcamia1",
	"business_line":1,
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2"
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncCheckInvoke#execute',1205612035459523584,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_l WHERE FPKID = '3WAXFO2Q22BM';
INSERT INTO T_ER_TRIP_FIELDMAPPING_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1802166827372003328,'3WAXFO2Q22BM','en_US','Didi-Monthly Close Books Synchronization');
DELETE FROM T_ER_TRIP_FIELDMAPPING_l WHERE FPKID = '3NC/3Z4+RFB+';
INSERT INTO T_ER_TRIP_FIELDMAPPING_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1802166827372003328,'3NC/3Z4+RFB+','zh_CN','滴滴-月结账单同步(废弃)');
DELETE FROM T_ER_TRIP_FIELDMAPPING_l WHERE FPKID = '3NC/3Z4+RFB/';
INSERT INTO T_ER_TRIP_FIELDMAPPING_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1802166827372003328,'3NC/3Z4+RFB/','zh_TW','滴滴-月結賬單同步(廢棄)');

DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915319632911577088;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.服务类型',' ',1915319632911577088,'1',{ts'2024-03-27  00:00:00'},'data.list.[0].sub_bill_summary.[0].business_type',{ts'2024-05-27  00:00:00'},'IF( data.list.[0].sub_bill_summary.[0].business_type=''202'' ,''2'', IF(data.list.[0].sub_bill_summary.[0].business_type=''205'',''4'', IF(data.list.[0].sub_bill_summary.[0].business_type=''201'',''1'', IF( data.list.[0].sub_bill_summary.[0].business_type=''204'',''5'', IF( data.list.[0].sub_bill_summary.[0].business_type=''203'',''6'','''') ) )  ) )',1,'3','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 1915874160450946048;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (1913742913322848256,' ','1',' ',' ','单据头.表单ID',' ',1915874160450946048,'1',{ts'2024-03-28  00:00:00'},' ',{ts'2024-05-27  00:00:00'},'IF( data.list.[0].sub_bill_summary.[0].business_type=''202'',''er_planecheckingbill'', IF(data.list.[0].sub_bill_summary.[0].business_type=''205'',''er_planecheckingbill'', IF(data.list.[0].sub_bill_summary.[0].business_type=''201'',''er_hotelcheckingbill'', IF( data.list.[0].sub_bill_summary.[0].business_type=''204'',''er_hotelcheckingbill'', IF( data.list.[0].sub_bill_summary.[0].business_type=''203'',''er_traincheckingbill'','''') ) )  ) )',9,'3','formid','0');