DELETE FROM T_ER_TRIP_FIELDMAPENTRY WHERE FENTRYID IN (1693542771035941888,
                                                       1859492032259815424,
                                                       1859490858852939776,
                                                       1859489563417075712,
                                                       1859492297029541888,
                                                       1859491147236597760,
                                                       1859489987553484800,
                                                       1859490364428384256,
                                                       1859491742920040448,
                                                       1859491526737131520,
                                                       1859490538894745600
);

INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1693529499394059264, 1, 1693542771035941888, 'billno', '单据头.消费编号', 'object.[0].seqNum', '1', ' ', ' ', ' ', ' ', '1', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1762332510073081856, 44, 1859492032259815424, 'billno', '单据头.单据编号', 'orders.[0].amapOrderId', '1', ' ', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1804382278055487488, 57, 1859490858852939776, 'billno', '单据头.单据编号', 'data.orders.[0].order_id', '3', 'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(data.orders.[0].transaction_type= ''出票'',''O'',  IF(data.orders.[0].transaction_type= ''改签单'',''G'',''T'')))', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1803572579831864320, 55, 1859489563417075712, 'billno', '单据头.单据编号', 'data.orders.[0].order_id', '3', 'data.orders.[0].order_id  + ''-'' +RIGHT(data.orders.[0].unique_key,4) + ''-''+ data.orders.[0].booking_member_number  + ''-'' + IF(data.orders.[0].order_type= ''预订'',''O'', ''T'')', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1792830743781593088, 44, 1859492297029541888, 'billno', '单据头.单据编号', 'orders.[0].refundItems.[0].refundTime', '3', 'orders.[0].amapOrderId +''-''+ (REPLACE(SUBSTRING(orders.[0].refundItems.[0].refundTime, 11,5) ,'':'',''''))', ' ', ' ', ' ', '0', '0', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1800025760397166592, 48, 1859491147236597760, 'billno', '单据头.单据编号', 'data.detail_list.[0].order_id', '3', 'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(data.detail_list.[0].transaction_type= ''出票'',''O'',  IF(data.detail_list.[0].transaction_type= ''改签单'',''G'',''T'')))', ' ', ' ', ' ', '0', '0', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1799930397417965568, 47, 1859489987553484800, 'billno', '单据头.单据编号', 'data.detail_list.[0].order_id', '3', 'data.detail_list.[0].order_id  + ''-'' +RIGHT(data.detail_list.[0].unique_key,4) + ''-''+ data.detail_list.[0].booking_member_number  + ''-'' + IF(data.detail_list.[0].order_type= ''预订'',''O'', ''T'')', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1804291042221088768, 64, 1859490364428384256, 'billno', '单据头.单据编号', 'data.orders.[0].order_id', '3', 'data.orders.[0].order_id+ ''-'' +  data.orders.[0].booking_member_number +''-''+(IF(data.orders.[0].transaction_type = 0,''O'', IF(data.orders.[0].transaction_type = 1,''G'',''T'')))', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1782672127104004096, 53, 1859491742920040448, 'billno', '单据头.单据编号', 'data.list.[0].refundSuccessTime', '3', 'data.list.[0].amapOrderId +''-''+ (REPLACE(SUBSTRING(data.list.[0].refundSuccessTime , 11,5) ,'':'',''''))', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1768225189230945280, 53, 1859491526737131520, 'billno', '单据头.单据编号', 'data.list.[0].amapOrderId', '1', ' ', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
INSERT INTO T_ER_TRIP_FIELDMAPENTRY (FID, FSEQ, FENTRYID, FMAPTARGETFIELD, FMAPTARGETFIELDDESC, FMAPSOURCEFIELD, FMAPTYPE, FMAPDESIGN, FMAPSOURCEFIELDEXT, FMAPTYPEEXT, FMAPDESIGNEXT, FMAPPRIMARYKEY, FMAPISDEFAULT, FMAPSTATUS, FMAPDESC, FMAPCREATETIME, FMAPMODIFYTIME) VALUES (1797014402680424448, 65, 1859490538894745600, 'billno', '单据头.单据编号', 'data.detail_list.[0].order_id', '3', 'data.detail_list.[0].order_id+ ''-'' +  data.detail_list.[0].booking_member_number +''-''+(IF(data.detail_list.[0].transaction_type = 0,''O'', IF(data.detail_list.[0].transaction_type = 1,''G'',''T'')))', ' ', ' ', ' ', '0', '1', '1', ' ', {ts'2024-01-10 14:33:00'}, {ts'2024-01-10 14:33:00'});
