-- 滴滴国际机票订单和结算单字段映射
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2197988952374712320;
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 (2197988952374712320,1015862345630818304,' ','https://api.es.xiaojukeji.com/river/Bill/getNotGeneratedBillDetail','1',2197988952374712320,'GET','C','D_SyncPlaneOrder_List_Inter','滴滴-机票订单同步-国际',' ','已录入参数。',{ts'2025-04-21  00:00:00'},'pull','0',1925266062056993792,'er_planebill',{ts'2025-05-08  00:00:00'},'{
	"access_token":"611344",
	"end_date":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":202,
	"sign":"car_lixingffcamia1",
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2",
	"start_date":5
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncOrderInvoke#execute',13466739,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4X+BSX48WWZU';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2197988952374712320,'4X+BSX48WWZU','zh_CN','滴滴-机票订单同步-国际');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2197988952534095872;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095872,'D_Token',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  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 = 2197988952534095873;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095873,' ',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  00:00:00'},'client_id',' ',2,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2197988952534095874;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095874,' ',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  00:00:00'},'company_id',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2197988952534095875;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095875,' ',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2197988952534095876;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095876,' ',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2197988952534095877;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095877,'205',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2197988952534095878;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095878,'3',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  00:00:00'},'start_date','值表示当前时间，往前递减的天数',7,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortStartDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2197988952534095879;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095879,' ',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  00:00:00'},'end_date','值表示当前时间，往前递减的天数',8,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getShortEndDate');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2197988952534095880;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2197988952374712320,'=',' ',' ',2197988952534095880,'0',' ','1',{ts'2025-04-21  00:00:00'},{ts'2025-04-21  00:00:00'},'last_id',' ',9,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getLastId');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 2197988952533971970;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (2197988952374712320,'1','!=','data.detail_list.[0].pay_type','个人支付','1',2197988952533971970,' ',{ts'2025-04-21  00:00:00'},'and',{ts'2025-04-21  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2198000985967106048;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.单据状态',' ',2198000985967106048,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'C',69,'2','billstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095882;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.父订单号',' ',2197988952534095882,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].origin_order_id',{ts'2025-04-21  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095883;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.服务商',' ',2197988952534095883,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095884;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单日期',' ',2197988952534095884,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].booking_date',{ts'2025-04-21  00:00:00'},' ',4,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095885;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.预订人',' ',2197988952534095885,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].booking_member_number',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',5,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095886;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.预订人',' ',2197988952534095886,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].booking_member_name',{ts'2025-04-21  00:00:00'},' ',6,'1','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095887;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.预订人部门',' ',2197988952534095887,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getBookUserDept',7,'4','bookeddept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095888;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.出差申请/用车申请单号',' ',2197988952534095888,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].out_requisition_id',{ts'2025-04-21  00:00:00'},' ',8,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095889;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.电子客票号',' ',2197988952534095889,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-05-08  00:00:00'},' ',9,'2','ticketnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095890;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.业务类型',' ',2197988952534095890,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'4',10,'2','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095891;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单分类',' ',2197988952534095891,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'2',11,'2','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095892;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.结算类型',' ',2197988952534095892,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'IF(STRING(data.detail_list.[0].pay_type)  = ''企业支付''  OR STRING(data.detail_list.[0].pay_type)  = ''混合支付''  OR STRING(data.detail_list.[0].pay_type)  = ''企业钱包支付'' ,1,2)',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095893;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单状态',' ',2197988952534095893,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''40000'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'' OR STRING(data.detail_list.[0].transaction_type) = ''3'' ,''50302'',''50202'') )',13,'3','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095894;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单使用状态',' ',2197988952534095894,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-05-07  00:00:00'},'USED',14,'2','ticketstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095895;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.费用发生时间',' ',2197988952534095895,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].settlement_time',{ts'2025-04-21  00:00:00'},' ',15,'1','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095896;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.报销状态',' ',2197988952534095896,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'A',16,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095897;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单类型',' ',2197988952534095897,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''O'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'' OR STRING(data.detail_list.[0].transaction_type) = ''3'',''G'',''T'') )',17,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095898;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单性质',' ',2197988952534095898,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'IF(STRING(data.detail_list.[0].pay_type) = ''企业支付'' OR STRING(data.detail_list.[0].pay_type) = ''企业钱包支付'' OR STRING(data.detail_list.[0].pay_type) = ''混合支付'',1,2)',18,'3','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095899;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.航空公司名称',' ',2197988952534095899,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].airline_simple_name',{ts'2025-04-21  00:00:00'},' ',19,'1','airlinename','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095900;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.航班号',' ',2197988952534095900,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].flight_number',{ts'2025-04-21  00:00:00'},' ',20,'1','flightno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095901;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.舱位等级',' ',2197988952534095901,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].cabin_name',{ts'2025-04-21  00:00:00'},' ',21,'1','cabinclass','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095902;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.舱位',' ',2197988952534095902,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].cabin_code',{ts'2025-04-21  00:00:00'},' ',22,'1','cabin','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095903;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.出发城市',' ',2197988952534095903,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].departure_city_name',{ts'2025-04-21  00:00:00'},' ',23,'1','fromcity','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095904;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.出发城市名称',' ',2197988952534095904,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].departure_city_name',{ts'2025-04-21  00:00:00'},' ',24,'1','fromcityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095905;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.出发机场',' ',2197988952534095905,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].departure_airport_name',{ts'2025-04-21  00:00:00'},' ',25,'1','takeoffport','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095906;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.出发机场名称',' ',2197988952534095906,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].departure_airport_name',{ts'2025-04-21  00:00:00'},' ',26,'1','takeoffportname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095907;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.出发时间',' ',2197988952534095907,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].departure_time',{ts'2025-04-21  00:00:00'},' ',27,'1','takeofftime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095908;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.到达城市',' ',2197988952534095908,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].arrival_city_name',{ts'2025-04-21  00:00:00'},' ',28,'1','tocity','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095909;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.到达城市名称',' ',2197988952534095909,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].arrival_city_name',{ts'2025-04-21  00:00:00'},' ',29,'1','tocityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095910;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.降落机场',' ',2197988952534095910,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].arrival_airport_name',{ts'2025-04-21  00:00:00'},' ',30,'1','landingport','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095911;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.降落机场名称',' ',2197988952534095911,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].arrival_airport_name',{ts'2025-04-21  00:00:00'},' ',31,'1','landingportname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095912;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.降落日期',' ',2197988952534095912,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].arrival_time',{ts'2025-04-21  00:00:00'},' ',32,'1','landingtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095913;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.币别',' ',2197988952534095913,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',33,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095916;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.最低价格',' ',2197988952534095916,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'0',36,'2','lowestpirce','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095917;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.机票价格',' ',2197988952534095917,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'NUMBER(data.detail_list.[0].ticket_fee)  + NUMBER(data.detail_list.[0].upgrade_cost)',37,'3','ticketprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095919;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.服务费',' ',2197988952534095919,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].service_fee',{ts'2025-04-21  00:00:00'},' ',39,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095921;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单金额',' ',2197988952534095921,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].company_real_pay',{ts'2025-04-21  00:00:00'},' ',41,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095922;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.退票费',' ',2197988952534095922,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].refund_handle_cost',{ts'2025-04-21  00:00:00'},' ',42,'1','refundamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095923;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.改签费',' ',2197988952534095923,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].change_handle_cost',{ts'2025-04-21  00:00:00'},' ',43,'1','endorsementamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095924;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.保险费',' ',2197988952534095924,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'0',44,'2','assuranceamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095925;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.服务费结算类型',' ',2197988952534095925,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'1',45,'2','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095927;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.乘机人',' ',2197988952534095927,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].passenger_member_number',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',47,'4','sourcetravelerid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095928;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.乘机人',' ',2197988952534095928,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].passenger_member_name',{ts'2025-04-21  00:00:00'},' ',48,'1','travelername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095929;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.乘机人部门',' ',2197988952534095929,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getPassegerUserDept',49,'4','travelerdept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095930;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ','该字段建议放置在字段映射排序靠后，它依赖一些基本信息判断，例如申请单号，出发地，目的地城市，乘车人。','单据头.出差行程ID',' ',2197988952534095930,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getTripId',50,'4','tripid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095931;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.申请单表单id',' ',2197988952534095931,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',51,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095932;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.费用承担公司',' ',2197988952534095932,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].extend_info',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',52,'4','expcommitcomnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095933;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.费用承担部门',' ',2197988952534095933,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].extend_info',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',53,'4','expcommitdepnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095934;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.申请人公司',' ',2197988952534095934,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].extend_info',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',54,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095935;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.PNR',' ',2197988952534095935,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].pnr_number',{ts'2025-04-21  00:00:00'},' ',55,'1','pnr','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095936;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.原单订单号',' ',2197988952534095936,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].origin_order_id',{ts'2025-04-21  00:00:00'},' ',56,'1','oriordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095938;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.创建人',' ',2197988952534095938,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',58,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095939;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.创建时间',' ',2197988952534095939,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'NOW()',59,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095940;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.修改人',' ',2197988952534095940,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',60,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095941;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.修改时间',' ',2197988952534095941,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'NOW()',61,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095942;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.航空公司',' ',2197988952534095942,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].airline_simple_name',{ts'2025-04-21  00:00:00'},' ',62,'1','airline','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095943;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.退票理由',' ',2197988952534095943,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].reason',{ts'2025-04-21  00:00:00'},'IF(STRING(data.detail_list.[0].transaction_type) = ''2'', data.detail_list.[0].reason ,'' '')',63,'3','refundreason','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095944;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.改签理由',' ',2197988952534095944,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].reason',{ts'2025-04-21  00:00:00'},'IF(STRING(data.detail_list.[0].transaction_type) = ''1'', data.detail_list.[0].reason ,'' '')',64,'3','changereason','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095946;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.项目',' ',2197988952534095946,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getProject',66,'4','std_project','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095947;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.成本中心',' ',2197988952534095947,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].extend_info',{ts'2025-04-21  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter',67,'4','std_costcenter','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095948;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.外部系统订单号',' ',2197988952534095948,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].order_id',{ts'2025-04-21  00:00:00'},' ',68,'1','outordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095937;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单状态名称',' ',2197988952534095937,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-04-21  00:00:00'},'IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''已出票'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'' OR STRING(data.detail_list.[0].transaction_type) = ''3'',''已改签'',''已退票'') )',57,'3','orderstatusname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095915;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.折扣（%）',' ',2197988952534095915,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-05-08  00:00:00'},' ',35,'2','discount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095920;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.燃油费',' ',2197988952534095920,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].fuelCost',{ts'2025-05-08  00:00:00'},' ',40,'1','fuelprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095926;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.个人支付金额',' ',2197988952534095926,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-05-08  00:00:00'},' ',46,'2','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095914;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.标准价格',' ',2197988952534095914,'1',{ts'2025-04-21  00:00:00'},' ',{ts'2025-05-08  00:00:00'},'0',34,'2','standprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210177276568823808;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.超标',' ',2210177276568823808,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].rc_level',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getOverFlag',70,'4','overflag','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210177276568823809;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.最低价',' ',2210177276568823809,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].rc_lowPrice',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getOverFlag',71,'4','islowestpirce','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210177276568823810;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.非最低价说明',' ',2210177276568823810,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].rc_lowPrice',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getNotLowerPriceReason',72,'4','choosenotminreason','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210177276568823811;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.超标理由',' ',2210177276568823811,'1',{ts'2025-05-08  00:00:00'},'data.detail_list.[0].rc_level',{ts'2025-05-08  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getNotLowerPriceReason',73,'4','overdesc','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095945;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.单据编号',' ',2197988952534095945,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].order_id',{ts'2025-06-06  00:00:00'},'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].passenger_member_name +''-''+IF(FIND('','',data.detail_list.[0].arrival_city_name,0)=-1,data.detail_list.[0].arrival_city_name,LEFT(data.detail_list.[0].arrival_city_name,FIND('','',data.detail_list.[0].arrival_city_name,0))) +''-''+(IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''O'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'',''G'',''T'')))+ IF(NUMBER(data.detail_list.[0].flight_segment_number) >  1,''-''+data.detail_list.[0].flight_segment_number,'''')',65,'3','billno','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095881;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.订单号',' ',2197988952534095881,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].order_id',{ts'2025-06-06  00:00:00'},'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].passenger_member_name +''-''+IF(FIND('','',data.detail_list.[0].arrival_city_name,0)=-1,data.detail_list.[0].arrival_city_name,LEFT(data.detail_list.[0].arrival_city_name,FIND('','',data.detail_list.[0].arrival_city_name,0))) +''-''+(IF(STRING(data.detail_list.[0].transaction_type) = ''0'',''O'', IF(STRING(data.detail_list.[0].transaction_type) = ''1'',''G'',''T'')))+ IF(NUMBER(data.detail_list.[0].flight_segment_number) >  1,''-''+data.detail_list.[0].flight_segment_number,'''')',1,'3','ordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2197988952534095918;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2197988952374712320,' ','1',' ',' ','单据头.机场建设费及其他/税费',' ',2197988952534095918,'1',{ts'2025-04-21  00:00:00'},'data.detail_list.[0].construction_cost',{ts'2025-06-06  00:00:00'},'ROUND(NUMBER(data.detail_list.[0].construction_cost)+ NUMBER(data.detail_list.[0].tax),2)',40,'3','airportprice','0');

-- 国际机票结算单
DELETE FROM T_ER_TRIP_FIELDMAPPING WHERE FID = 2210851396079591424;
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 (2210851396079591424,1015862345630818304,' ','https://api.es.xiaojukeji.com/river/Bill/detail','1',2210851396079591424,'GET','C','D_SyncPlaneChecking_List_Inter','滴滴-机票结算单同步-国际',' ','已录入参数。',{ts'2025-05-09  00:00:00'},'pull','0',1925266062056993792,'er_planecheckingbill',{ts'2025-05-09  00:00:00'},'{
	"access_token":"611344",
	"bill_id":"4",
	"company_id":"car_lixingffcamia1",
	"last_id":"4",
	"business_type":202,
	"sign":"car_lixingffcamia1",
	"length":5,
	"client_id":1,
	"timestamp":"364537D769162754A9142BCA53F1C7D2"
}','kd.fi.er.business.trip.v2.server.dtrip.DtripSyncCheckingInvoke#execute',1925266062056993792,'已录入参数');
DELETE FROM T_ER_TRIP_FIELDMAPPING_L WHERE FPKID = '4YK+2A8ZI//T';
INSERT INTO T_ER_TRIP_FIELDMAPPING_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2210851396079591424,'4YK+2A8ZI//T','zh_CN','滴滴-机票结算单同步-国际');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210851397052669953;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669953,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'client_id',' ',2,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getAppKey');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210851397052669952;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669952,'D_Token',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  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 = 2210851397052669954;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669954,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'company_id',' ',3,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getOrationid');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210851397052669955;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669955,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'sign',' ',4,'1','and','kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getReservedfield1');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210851397052669956;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669956,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'timestamp',' ',5,'1','and','kd.fi.er.business.trip.v2.plugin.TimePlugin#getNowTime');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210851397052669957;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669957,'205',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'business_type',' ',6,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210851397052669958;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669958,'100',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'length',' ',7,'1','and',' ');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210851397052669959;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669959,' ',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'bill_id',' ',8,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillId');
DELETE FROM T_ER_TRIP_QUERYENTRY WHERE FENTRYID = 2210851397052669960;
INSERT INTO T_ER_TRIP_QUERYENTRY(FID,FQUERYCONDITION,FQUERYPLUGINVALUEEXT,FQUERYLEFTBRACKET,FENTRYID,FQUERYVALUE,FQUERYRIGHTBRACKET,FQUERYISDEFAULT,FQUERYCREATETIME,FQUERYMODIFYTIME,FQUERYFIELD,FQUERYDESC,FSEQ,FQUERYSTATUS,FQUERYLOGIC,FQUERYPLUGINVALUE) VALUES (2210851396079591424,'=',' ',' ',2210851397052669960,'0',' ','1',{ts'2025-05-09  00:00:00'},{ts'2025-05-09  00:00:00'},'last_id',' ',9,'1','and','kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getLastId');
DELETE FROM T_ER_TRIP_FILTERENTRY WHERE FENTRYID = 2210851397052670978;
INSERT INTO T_ER_TRIP_FILTERENTRY(FID,FFILTERSTATUS,FFILTERCONDITION,FFILTERFIELD,FFILTERVALUE,FFILTERISDEFAULT,FENTRYID,FFILTERDESC,FFILTERMODIFYTIME,FFILTERLOGIC,FFILTERCREATETIME,FFILTERLEFTBRACKET,FSEQ,FFILTERRIGHTBRACKET) VALUES (2210851396079591424,'1','!=','data.orders.[0].pay_type','个人支付','1',2210851397052670978,' ',{ts'2025-05-09  00:00:00'},'and',{ts'2025-05-09  00:00:00'},' ',1,' ');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669962;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.父订单号',' ',2210851397052669962,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].origin_order_id',{ts'2025-05-09  00:00:00'},' ',2,'1','parentordernum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669963;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.服务商',' ',2210851397052669963,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'DIDI',3,'2','server','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669964;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.订单日期',' ',2210851397052669964,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].booking_date',{ts'2025-05-09  00:00:00'},' ',4,'1','orderdate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669965;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.预订人',' ',2210851397052669965,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].booking_member_number',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',5,'4','sourcebookedid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669966;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.预订人',' ',2210851397052669966,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].booking_member_number',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUserName',6,'4','bookedname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669967;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.申请单号',' ',2210851397052669967,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].out_requisition_id',{ts'2025-05-09  00:00:00'},' ',7,'1','oabillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669968;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.申请单表单id',' ',2210851397052669968,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getOabillformid',8,'4','oabillformid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669969;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.电子客票号',' ',2210851397052669969,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].supplier_order_id',{ts'2025-05-09  00:00:00'},' ',9,'1','ticketnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669970;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.业务类型',' ',2210851397052669970,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].flight_travel_type) = ''0'',2,4)',10,'3','operationtype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669971;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.订单分类',' ',2210851397052669971,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].flight_travel_type) = ''0'',1,2)',11,'3','ordersort','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669972;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.结算类型',' ',2210851397052669972,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].pay_type)  = ''企业支付''  OR STRING(data.orders.[0].pay_type)  = ''混合支付''  OR STRING(data.orders.[0].pay_type)  = ''企业钱包支付'',1,2)',12,'3','producttype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669975;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.结算发生时间',' ',2210851397052669975,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].settlement_time',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getHappenddate',15,'4','happenddate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669976;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.期间',' ',2210851397052669976,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.TimePlugin#getPeriod',16,'4','period','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669977;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.报销状态',' ',2210851397052669977,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'A',17,'2','reimbursestatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669978;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.航空公司名称',' ',2210851397052669978,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].airline_simple_name',{ts'2025-05-09  00:00:00'},' ',18,'1','airlinename','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669979;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.航班号',' ',2210851397052669979,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].flight_number',{ts'2025-05-09  00:00:00'},' ',19,'1','flightno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669980;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.舱位等级',' ',2210851397052669980,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].cabin_name',{ts'2025-05-09  00:00:00'},' ',20,'1','cabinclass','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669981;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.舱位',' ',2210851397052669981,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].cabin_code',{ts'2025-05-09  00:00:00'},' ',21,'1','cabin','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669982;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.出发城市名称',' ',2210851397052669982,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].departure_city_name',{ts'2025-05-09  00:00:00'},' ',22,'1','fromcityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669983;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.出发时间',' ',2210851397052669983,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].departure_time',{ts'2025-05-09  00:00:00'},' ',23,'1','takeofftime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669984;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.到达城市名称',' ',2210851397052669984,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].arrival_city_name',{ts'2025-05-09  00:00:00'},' ',24,'1','tocityname','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669985;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.到达时间',' ',2210851397052669985,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].arrival_time',{ts'2025-05-09  00:00:00'},' ',25,'1','landingtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669986;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.币别',' ',2210851397052669986,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.BizInfoPlugin#getCheckingCurrency',26,'4','currency','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669987;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.折扣（%）',' ',2210851397052669987,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},' ',27,'2','discount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669988;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.最低价格',' ',2210851397052669988,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'0',28,'2','lowestpirce','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669989;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.机票价格',' ',2210851397052669989,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'NUMBER(data.orders.[0].ticket_fee)  + NUMBER(data.orders.[0].upgrade_cost)',29,'3','ticketprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669991;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.服务费',' ',2210851397052669991,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].service_fee',{ts'2025-05-09  00:00:00'},' ',31,'1','servicefee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669993;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.结算金额',' ',2210851397052669993,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].company_real_pay',{ts'2025-05-09  00:00:00'},' ',33,'1','totalamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669994;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.退票费',' ',2210851397052669994,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].refund_handle_cost',{ts'2025-05-09  00:00:00'},' ',34,'1','refundamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669995;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.改签费',' ',2210851397052669995,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].change_handle_cost',{ts'2025-05-09  00:00:00'},' ',35,'1','endorsementamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669996;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.保险费',' ',2210851397052669996,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'0',36,'2','assuranceamount','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669997;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.订单类型',' ',2210851397052669997,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].transaction_type) = ''0'',''O'', IF(STRING(data.orders.[0].transaction_type) = ''1'' OR STRING(data.orders.[0].transaction_type) = ''3'',''G'',''T'') )',37,'3','ordertype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669998;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.订单性质',' ',2210851397052669998,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].pay_type) = ''企业支付'' OR STRING(data.orders.[0].pay_type) =''企业钱包支付'' OR STRING(data.orders.[0].pay_type) =''混合支付'',1,2)',38,'3','isbusiness','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669999;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.服务费结算类型',' ',2210851397052669999,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'1',39,'2','servicefeepaytype','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670000;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.个人支付金额',' ',2210851397052670000,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'0',40,'2','personalfee','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670001;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.乘机人',' ',2210851397052670001,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].passenger_member_number',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getUser',41,'4','sourcetravelerid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670002;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.乘机人',' ',2210851397052670002,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].passenger_member_name',{ts'2025-05-09  00:00:00'},' ',42,'1','travelername','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670003;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.费用承担公司',' ',2210851397052670003,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleMain',43,'4','settlemain','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670004;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.费用承担部门',' ',2210851397052670004,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrgPlugin#getSettleDept',44,'4','settledept','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670005;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.申请人公司',' ',2210851397052670005,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',45,'4','company','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670006;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.申请人部门',' ',2210851397052670006,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCompanyId',46,'4','org','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670007;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.是否对平',' ',2210851397052670007,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsbalance',47,'4','isbalance','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670008;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.可抵扣',' ',2210851397052670008,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsdeductible',48,'4','isdeductible','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670009;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.票价税额',' ',2210851397052670009,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderamounttax',49,'4','orderamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670010;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.票价税率(%)',' ',2210851397052670010,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getOrderdeductrate',50,'4','orderdeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670011;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.服务费税额',' ',2210851397052670011,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServiceamounttax',51,'4','serviceamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670012;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.服务费税率(%)',' ',2210851397052670012,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getServicedeductrate',52,'4','servicedeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670013;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.是否对账',' ',2210851397052670013,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getIsreconciliation',53,'4','isreconciliation','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670014;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.订单总表数据',' ',2210851397052670014,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#allOrderId',54,'4','allorderbase','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670015;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.结算批次号',' ',2210851397052670015,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].bill_id',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillIdByJsonValue',55,'4','batchno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670016;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.单据编号',' ',2210851397052670016,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].bill_id',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getBillIdByJsonValue',56,'4','checkingbillnum','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670017;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.表单ID',' ',2210851397052670017,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'er_planecheckingbill',57,'2','formid','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670018;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.创建人',' ',2210851397052670018,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',58,'4','creator','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670019;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.单据状态',' ',2210851397052670019,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'A',59,'2','billstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670020;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.创建时间',' ',2210851397052670020,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'NOW()',60,'3','createtime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670021;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.修改人',' ',2210851397052670021,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.UserPlugin#getCurrentUserId',61,'4','modifier','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670022;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.修改时间',' ',2210851397052670022,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'NOW()',62,'3','modifytime','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670024;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.项目',' ',2210851397052670024,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.OrderPlugin#getProject',64,'4','std_project','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670025;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.成本中心',' ',2210851397052670025,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].extend_info',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.req.ReqBillPlugin#getReqCostcenter',65,'4','std_costcenter','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670026;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.退票费税率(%)',' ',2210851397052670026,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getRefunddeductrate',66,'4','refunddeductrate','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670027;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.退票费税额',' ',2210851397052670027,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getRefundamounttax',67,'4','refundamounttax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670028;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.可抵扣税额',' ',2210851397052670028,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.CheckingPlugin#getTotaltax',68,'4','totaltax','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669973;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.订单状态',' ',2210851397052669973,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'IF(STRING(data.orders.[0].transaction_type) = ''0'',40000, IF(STRING(data.orders.[0].transaction_type) = ''1'' OR STRING(data.orders.[0].transaction_type) = ''3'' ,50302,50202) )',13,'3','orderstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669974;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.使用状态',' ',2210851397052669974,'1',{ts'2025-05-09  00:00:00'},' ',{ts'2025-05-09  00:00:00'},'USED',14,'2','ticketstatus','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669992;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.燃油费',' ',2210851397052669992,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].fuelCost',{ts'2025-05-09  00:00:00'},' ',32,'1','fuelprice','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2211029290210829312;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.最低价',' ',2211029290210829312,'1',{ts'2025-05-09  00:00:00'},'data.detail_list.[0].rc_lowPrice',{ts'2025-05-09  00:00:00'},'kd.fi.er.business.trip.v2.plugin.dtrip.DtripPlugin#getOverFlag',69,'4','islowestpirce','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669961;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.订单号',' ',2210851397052669961,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_id',{ts'2025-06-06  00:00:00'},'data.orders.[0].order_id+ ''-'' +  data.orders.[0].passenger_member_name +''-''+IF(FIND('','',data.orders.[0].arrival_city_name,0)=-1,data.orders.[0].arrival_city_name,LEFT(data.orders.[0].arrival_city_name,FIND('','',data.orders.[0].arrival_city_name,0)))+''-''+(IF(STRING(data.orders.[0].transaction_type) = ''0'',''O'', IF(STRING(data.orders.[0].transaction_type) = ''1'',''G'',''T'')))+ IF(NUMBER(data.orders.[0].flight_segment_number) >  1,''-''+data.orders.[0].flight_segment_number,'''')',1,'3','ordernum','1');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052670023;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.单据编号',' ',2210851397052670023,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].order_id',{ts'2025-06-06  00:00:00'},'data.orders.[0].order_id+ ''-'' +  data.orders.[0].passenger_member_name +''-''+IF(FIND('','',data.orders.[0].arrival_city_name,0)=-1,data.orders.[0].arrival_city_name,LEFT(data.orders.[0].arrival_city_name,FIND('','',data.orders.[0].arrival_city_name,0)))+''-''+(IF(STRING(data.orders.[0].transaction_type) = ''0'',''O'', IF(STRING(data.orders.[0].transaction_type) = ''1'',''G'',''T'')))+ IF(NUMBER(data.orders.[0].flight_segment_number) >  1,''-''+data.orders.[0].flight_segment_number,'''')',63,'3','billno','0');
DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID = 2210851397052669990;
INSERT INTO T_ER_TRIP_FIELDMAPENTRY(FID,FMAPTYPEEXT,FMAPSTATUS,FMAPSOURCEFIELDEXT,FMAPDESC,FMAPTARGETFIELDDESC,FMAPDESIGNEXT,FENTRYID,FMAPISDEFAULT,FMAPCREATETIME,FMAPSOURCEFIELD,FMAPMODIFYTIME,FMAPDESIGN,FSEQ,FMAPTYPE,FMAPTARGETFIELD,FMAPPRIMARYKEY) VALUES (2210851396079591424,' ','1',' ',' ','单据头.机场基建费',' ',2210851397052669990,'1',{ts'2025-05-09  00:00:00'},'data.orders.[0].construction_cost',{ts'2025-06-06  00:00:00'},'ROUND(NUMBER(data.orders.[0].construction_cost)+NUMBER( data.orders.[0].tax ),2)',30,'3','airportprice','0');
