UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].passenger_member_name +''-''+data.detail_list.[0].arrival_city_name +''-''+(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,'''')'  ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1797014402722247682;
UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].passenger_member_name +''-''+data.detail_list.[0].arrival_city_name +''-''+(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,'''')'  ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1859490538894745600;
UPDATE t_er_trip_fieldmapentry SET fmapsourcefield='data.detail_list.[0].passenger_member_name',fmaptype='1',fmapdesign=' ' WHERE FEntryId=1797014402722247706;



UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.orders.[0].order_id+ ''-'' +  data.orders.[0].passenger_member_name +''-''+data.orders.[0].arrival_city_name +''-''+(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,'''')' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1804291042271422464;
UPDATE t_er_trip_fieldmapentry SET fmapdesign='data.orders.[0].order_id+ ''-'' +  data.orders.[0].passenger_member_name +''-''+data.orders.[0].arrival_city_name +''-''+(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,'''')' ,FMAPDESIGNEXT = ' ',FMAPSOURCEFIELDEXT= ' ',FMAPTYPEEXT= ' ' WHERE FEntryId=1859490364428384256;
UPDATE t_er_trip_fieldmapentry SET fmapsourcefield='data.orders.[0].passenger_member_name',fmaptype='1',fmapdesign=' ' WHERE FEntryId=1804291042271422512;