UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(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,'''')' WHERE FENTRYID= 1797014402722247682;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(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,'''')' WHERE FENTRYID= 1859490538894745600;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(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,'''')' WHERE FENTRYID= 1804291042271422464;
UPDATE T_ER_TRIP_FIELDMAPENTRY SET FMAPDESIGN='data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(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,'''')' WHERE FENTRYID= 1859490364428384256;
