{ "metric": "rooms_lost", "label": "Rooms actually lost", "note": "Paid for and not used, because the hotel would not move the booking.", "table": "room_night", "sort": null, "dir": "desc", "filters": {}, "total": 83, "sums": { "public_rate": 29901.72, "rate_paid": 24115.86 }, "rows": [ { "id": "RS-8854150-3", "period": "2026-08", "night": "2026-08-31", "booking_id": "RS-8854150", "duty_id": "D-514150", "layover_id": "L-514151", "crew_id": "BEL-1010", "crew_name": "O. Declerck", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-29T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-31T13:03:00Z", "duty_start_utc": "2026-08-31T14:05:00Z", "transfer_minutes": 22, "room_net": 242.62, "vat_rate": 6, "vat_amount": 14.56, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 261.18, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 261.18, "fx_rate": 1, "fx_date": "2026-08-31", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 261.18, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854150", "vcc_auth_amount": 286.18, "folio_amount": 261.18, "settled_amount": 261.18, "settled_at": "2026-08-31T23:59:00Z", "contracted_rate": 261.18, "baseline_rate": 342.59, "market_rate": 332.31, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 197.96, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-31T17:22:00Z", "exception_resolved_at": "2026-08-31T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-31T02:14:00Z", "version": 1, "public_rate": 342.59, "discount_pct": 23.76 }, { "id": "RS-8855001-2", "period": "2026-08", "night": "2026-08-31", "booking_id": "RS-8855001", "duty_id": "D-515001", "layover_id": "L-515002", "crew_id": "FRA-1080", "crew_name": "L. Chevalier", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "LYS", "country": "FR", "property_id": "P-130", "hotel": "Comfort Hotel Lyon", "chain": "Choice", "contract_id": "C-130", "allotment_id": "A-130", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-30T03:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-31T14:15:00Z", "duty_start_utc": "2026-08-31T11:50:00Z", "transfer_minutes": 10, "room_net": 247.11, "vat_rate": 10, "vat_amount": 24.71, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 275.12, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 275.12, "fx_rate": 1, "fx_date": "2026-08-31", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 257.17, "markup": 17.95, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855001", "vcc_auth_amount": 300.12, "folio_amount": 275.12, "settled_amount": 275.12, "settled_at": "2026-08-31T23:59:00Z", "contracted_rate": 275.12, "baseline_rate": 365.42, "market_rate": 354.46, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "MRS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 244.34, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-31T17:22:00Z", "exception_resolved_at": "2026-08-31T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-30", "ingested_at": "2026-08-31T02:14:00Z", "version": 1, "public_rate": 365.42, "discount_pct": 24.71 }, { "id": "RS-8853063-3", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8853063", "duty_id": "D-513063", "layover_id": "L-513064", "crew_id": "IRE-1037", "crew_name": "M. O Conaill", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "LGG", "country": "BE", "property_id": "P-112", "hotel": "Husa de la Couronne", "chain": "Independent", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-27T13:15:00Z", "checkin_time": "01:15", "checkout_time": "10:00", "duty_end_utc": "2026-08-30T00:04:00Z", "duty_start_utc": "2026-08-30T09:15:00Z", "transfer_minutes": 36, "room_net": 263.18, "vat_rate": 6, "vat_amount": 15.79, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 282.97, "ancillaries": 12.58, "fee": 0, "currency_local": "EUR", "rate_paid_local": 282.97, "fx_rate": 1, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 254.79, "markup": 28.18, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853063", "vcc_auth_amount": 320.55, "folio_amount": 295.55, "settled_amount": 295.55, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": null, "baseline_rate": 317.43, "market_rate": 307.91, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 208.63, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-30T06:12:00Z", "exception_resolved_at": "2026-08-30T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-28", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 317.43, "discount_pct": 10.86 }, { "id": "RS-8855001-1", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8855001", "duty_id": "D-515001", "layover_id": "L-515002", "crew_id": "FRA-1080", "crew_name": "L. Chevalier", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "LYS", "country": "FR", "property_id": "P-130", "hotel": "Comfort Hotel Lyon", "chain": "Choice", "contract_id": "C-130", "allotment_id": "A-130", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-30T03:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-30T14:15:00Z", "duty_start_utc": "2026-08-30T14:05:00Z", "transfer_minutes": 10, "room_net": 247.11, "vat_rate": 10, "vat_amount": 24.71, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 275.12, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 275.12, "fx_rate": 1, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 257.17, "markup": 17.95, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855001", "vcc_auth_amount": 300.12, "folio_amount": 275.12, "settled_amount": 275.12, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": 275.12, "baseline_rate": 330.05, "market_rate": 320.15, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "MRS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 229.31, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-30T11:40:00Z", "exception_resolved_at": "2026-08-30T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-30", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 330.05, "discount_pct": 16.64 }, { "id": "RS-8855153-2", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8855153", "duty_id": "D-515153", "layover_id": "L-515154", "crew_id": "FRA-1030", "crew_name": "L. Roussel", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "CDG", "country": "FR", "property_id": "P-127", "hotel": "Pullman Paris CDG", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-29T04:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-30T15:11:00Z", "duty_start_utc": "2026-08-30T06:30:00Z", "transfer_minutes": 14, "room_net": 286.08, "vat_rate": 10, "vat_amount": 28.61, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 319.89, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 319.89, "fx_rate": 1, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 319.89, "markup": 0, "commission_received": 32.79, "commission_shared": 16.4, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8855153", "vcc_auth_amount": 344.89, "folio_amount": 319.89, "settled_amount": 319.89, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": null, "baseline_rate": 346.73, "market_rate": 336.33, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "MRS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 239.22, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-30T06:12:00Z", "exception_resolved_at": "2026-08-30T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 346.73, "discount_pct": 7.74 }, { "id": "RS-8853460-1", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8853460", "duty_id": "D-513460", "layover_id": "L-513461", "crew_id": "IRE-1076", "crew_name": "D. Nolan", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "BHX", "country": "GB", "property_id": "P-114", "hotel": "Ibis Birmingham Airport", "chain": "Accor", "contract_id": "C-114", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-29T03:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-29T14:02:00Z", "duty_start_utc": "2026-08-29T14:05:00Z", "transfer_minutes": 23, "room_net": 234.51, "vat_rate": 20, "vat_amount": 46.9, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 281.41, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 237.06, "fx_rate": 1.187066, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 265.42, "markup": 15.99, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853460", "vcc_auth_amount": 306.41, "folio_amount": 281.41, "settled_amount": 281.41, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 281.41, "baseline_rate": 325.15, "market_rate": 315.4, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 198.95, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-29T06:12:00Z", "exception_resolved_at": "2026-08-29T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 325.15, "discount_pct": 13.45 }, { "id": "RS-8854147-1", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8854147", "duty_id": "D-514147", "layover_id": "L-514148", "crew_id": "BEL-1029", "crew_name": "H. Willems", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "DXB", "country": "AE", "property_id": "P-122", "hotel": "Millennium Airport Hotel Dubai", "chain": "Millennium", "contract_id": "C-122", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-29T04:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-29T14:29:00Z", "duty_start_utc": "2026-08-29T06:30:00Z", "transfer_minutes": 56, "room_net": 269.06, "vat_rate": 5, "vat_amount": 13.45, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 287.51, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1115.11, "fx_rate": 0.257832, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 287.51, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854147", "vcc_auth_amount": 312.51, "folio_amount": 287.51, "settled_amount": 287.51, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 287.51, "baseline_rate": 331.77, "market_rate": 321.82, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 218.26, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-29T21:05:00Z", "exception_resolved_at": "2026-08-29T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 331.77, "discount_pct": 13.34 }, { "id": "RS-8854150-1", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8854150", "duty_id": "D-514150", "layover_id": "L-514151", "crew_id": "BEL-1010", "crew_name": "O. Declerck", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-29T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-29T13:03:00Z", "duty_start_utc": "2026-08-29T14:05:00Z", "transfer_minutes": 22, "room_net": 242.62, "vat_rate": 6, "vat_amount": 14.56, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 261.18, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 261.18, "fx_rate": 1, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 261.18, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854150", "vcc_auth_amount": 286.18, "folio_amount": 323.56, "settled_amount": 323.56, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 261.18, "baseline_rate": 309.38, "market_rate": 300.1, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 220.8, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-29T11:40:00Z", "exception_resolved_at": "2026-08-29T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "disputed", "recon_amount": 62.38, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 309.38, "discount_pct": 15.58 }, { "id": "RS-8854448-2", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8854448", "duty_id": "D-514448", "layover_id": "L-514449", "crew_id": "BEL-1027", "crew_name": "A. Peeters", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "DXB", "country": "AE", "property_id": "P-122", "hotel": "Millennium Airport Hotel Dubai", "chain": "Millennium", "contract_id": "C-122", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-28T10:30:00Z", "checkin_time": "22:30", "checkout_time": "04:30", "duty_end_utc": "2026-08-29T20:59:00Z", "duty_start_utc": "2026-08-29T09:15:00Z", "transfer_minutes": 56, "room_net": 267.82, "vat_rate": 5, "vat_amount": 13.39, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 286.21, "ancillaries": 20.05, "fee": 0, "currency_local": "AED", "rate_paid_local": 1110.06, "fx_rate": 0.257832, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 286.21, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854448", "vcc_auth_amount": 331.26, "folio_amount": 306.26, "settled_amount": 306.26, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 286.21, "baseline_rate": 331.77, "market_rate": 321.82, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 220.33, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-29T11:40:00Z", "exception_resolved_at": "2026-08-29T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-28", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 331.77, "discount_pct": 13.73 }, { "id": "RS-8853198-1", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8853198", "duty_id": "D-513198", "layover_id": "L-513199", "crew_id": "IRE-1038", "crew_name": "D. Doyle", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-103", "hotel": "Radisson Blu Dublin Airport", "chain": "Radisson", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-28T04:00:00Z", "checkin_time": "16:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-28T14:34:00Z", "duty_start_utc": "2026-08-28T06:30:00Z", "transfer_minutes": 51, "room_net": 254.19, "vat_rate": 13.5, "vat_amount": 34.32, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 288.51, "ancillaries": 11.56, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 288.51, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 257.33, "markup": 31.18, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853198", "vcc_auth_amount": 325.07, "folio_amount": 300.07, "settled_amount": 300.07, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": null, "baseline_rate": 328.44, "market_rate": 318.59, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 192.33, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-28T11:40:00Z", "exception_resolved_at": "2026-08-28T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-28", "ingested_at": "2026-08-28T02:14:00Z", "version": 1, "public_rate": 328.44, "discount_pct": 12.16 }, { "id": "RS-8854839-3", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8854839", "duty_id": "D-514839", "layover_id": "L-514840", "crew_id": "FRA-1046", "crew_name": "E. Aubert", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "MAD", "country": "ES", "property_id": "P-135", "hotel": "Melia Barajas", "chain": "Melia", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-26T04:00:00Z", "checkin_time": "16:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-28T15:11:00Z", "duty_start_utc": "2026-08-28T11:50:00Z", "transfer_minutes": 14, "room_net": 299.48, "vat_rate": 10, "vat_amount": 29.95, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 329.43, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 329.43, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 294.75, "markup": 34.68, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854839", "vcc_auth_amount": 354.43, "folio_amount": 329.43, "settled_amount": 329.43, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": null, "baseline_rate": 372.07, "market_rate": 360.91, "rate_honoured": 1, "customer": "DHL", "cost_centre": "CDG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 186.06, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-28T17:22:00Z", "exception_resolved_at": "2026-08-28T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-26", "ingested_at": "2026-08-28T02:14:00Z", "version": 1, "public_rate": 372.07, "discount_pct": 11.46 }, { "id": "RS-8854879-4", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8854879", "duty_id": "D-514879", "layover_id": "L-514880", "crew_id": "FRA-1013", "crew_name": "J. Delacroix", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "TLS", "country": "FR", "property_id": "P-133", "hotel": "Pullman Toulouse Airport", "chain": "Accor", "contract_id": "C-133", "allotment_id": "A-133", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-24T13:15:00Z", "checkin_time": "01:15", "checkout_time": "08:15", "duty_end_utc": "2026-08-28T00:18:00Z", "duty_start_utc": "2026-08-28T11:50:00Z", "transfer_minutes": 22, "room_net": 225.9, "vat_rate": 10, "vat_amount": 22.59, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 251.37, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 251.37, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 233.92, "markup": 17.45, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854879", "vcc_auth_amount": 276.37, "folio_amount": 251.37, "settled_amount": 251.37, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": 251.37, "baseline_rate": 317.7, "market_rate": 308.17, "rate_honoured": 1, "customer": "UPS", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 209.14, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-28T06:12:00Z", "exception_resolved_at": "2026-08-28T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-25", "ingested_at": "2026-08-28T02:14:00Z", "version": 1, "public_rate": 317.7, "discount_pct": 20.88 }, { "id": "RS-8853238-2", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8853238", "duty_id": "D-513238", "layover_id": "L-513239", "crew_id": "IRE-1007", "crew_name": "T. Mulligan", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "STN", "country": "GB", "property_id": "P-115", "hotel": "Radisson Blu Stansted", "chain": "Radisson", "contract_id": "C-115", "allotment_id": "A-115", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-26T03:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-27T14:03:00Z", "duty_start_utc": "2026-08-27T09:15:00Z", "transfer_minutes": 22, "room_net": 266.42, "vat_rate": 20, "vat_amount": 53.28, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 319.7, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 269.77, "fx_rate": 1.185081, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 319.7, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853238", "vcc_auth_amount": 344.7, "folio_amount": 319.7, "settled_amount": 319.7, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 319.7, "baseline_rate": 431.28, "market_rate": 418.34, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 204.22, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-27T21:05:00Z", "exception_resolved_at": "2026-08-27T18:40:00Z", "resolved_by": "human", "sla_breached": 1, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.4, "complaint_theme": "transfer", "source_file_id": "AIMS-2026-08-26", "ingested_at": "2026-08-27T02:14:00Z", "version": 1, "public_rate": 431.28, "discount_pct": 25.87 }, { "id": "RS-8853244-1", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8853244", "duty_id": "D-513244", "layover_id": "L-513245", "crew_id": "IRE-1054", "crew_name": "D. Brennan", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "CGN", "country": "DE", "property_id": "P-108", "hotel": "Leonardo Hotel Koln", "chain": "Leonardo", "contract_id": "C-108", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-27T04:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-27T15:09:00Z", "duty_start_utc": "2026-08-27T11:50:00Z", "transfer_minutes": 16, "room_net": 248.25, "vat_rate": 7, "vat_amount": 17.38, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 270.63, "ancillaries": 8.22, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 270.63, "fx_rate": 1, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 253.96, "markup": 16.67, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853244", "vcc_auth_amount": 303.85, "folio_amount": 278.85, "settled_amount": 278.85, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 270.63, "baseline_rate": 375.45, "market_rate": 364.19, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "crew_app", "change_cost": 174.24, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-27T11:40:00Z", "exception_resolved_at": "2026-08-27T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.2, "complaint_theme": "noise", "source_file_id": "AIMS-2026-08-27", "ingested_at": "2026-08-27T02:14:00Z", "version": 1, "public_rate": 375.45, "discount_pct": 27.92 }, { "id": "RS-8853526-1", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8853526", "duty_id": "D-513526", "layover_id": "L-513527", "crew_id": "IRE-1074", "crew_name": "G. Doyle", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "EMA", "country": "GB", "property_id": "P-105", "hotel": "Holiday Inn Castle Donington", "chain": "IHG", "contract_id": "C-105", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-26T17:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-27T04:54:00Z", "duty_start_utc": "2026-08-27T14:05:00Z", "transfer_minutes": 11, "room_net": 249.11, "vat_rate": 20, "vat_amount": 49.82, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 298.93, "ancillaries": 14.21, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 252.24, "fx_rate": 1.185081, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 298.93, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853526", "vcc_auth_amount": 338.14, "folio_amount": 313.14, "settled_amount": 313.14, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 298.93, "baseline_rate": 419.96, "market_rate": 407.36, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 257.47, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-27T21:05:00Z", "exception_resolved_at": "2026-08-27T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-27", "ingested_at": "2026-08-27T02:14:00Z", "version": 1, "public_rate": 419.96, "discount_pct": 28.82 }, { "id": "RS-8853463-1", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8853463", "duty_id": "D-513463", "layover_id": "L-513464", "crew_id": "IRE-1039", "crew_name": "H. Kavanagh", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-26T04:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-26T15:03:00Z", "duty_start_utc": "2026-08-26T06:30:00Z", "transfer_minutes": 22, "room_net": 241.06, "vat_rate": 6, "vat_amount": 14.46, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 259.52, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 259.52, "fx_rate": 1, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 259.52, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853463", "vcc_auth_amount": 284.52, "folio_amount": 259.52, "settled_amount": 259.52, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": 259.52, "baseline_rate": 392.07, "market_rate": 380.31, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 277.9, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-26T06:12:00Z", "exception_resolved_at": "2026-08-26T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.7, "complaint_theme": "transfer", "source_file_id": "AIMS-2026-08-26", "ingested_at": "2026-08-26T02:14:00Z", "version": 1, "public_rate": 392.07, "discount_pct": 33.81 }, { "id": "RS-8854270-3", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8854270", "duty_id": "D-514270", "layover_id": "L-514271", "crew_id": "BEL-1009", "crew_name": "Y. Lambert", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "HKG", "country": "HK", "property_id": "P-120", "hotel": "Regal Airport Hotel", "chain": "Regal", "contract_id": "C-120", "allotment_id": "A-120", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-22T17:40:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-25T04:09:00Z", "duty_start_utc": "2026-08-25T11:50:00Z", "transfer_minutes": 56, "room_net": 294.73, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 294.73, "ancillaries": 0, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2465.64, "fx_rate": 0.119535, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 274.38, "markup": 20.35, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854270", "vcc_auth_amount": 319.73, "folio_amount": 294.73, "settled_amount": 294.73, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 294.73, "baseline_rate": 428.06, "market_rate": 415.22, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 211.14, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-25T06:12:00Z", "exception_resolved_at": "2026-08-25T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-25T02:14:00Z", "version": 1, "public_rate": 428.06, "discount_pct": 31.15 }, { "id": "RS-8854567-1", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8854567", "duty_id": "D-514567", "layover_id": "L-514568", "crew_id": "BEL-1007", "crew_name": "V. Wouters", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "CDG", "country": "FR", "property_id": "P-127", "hotel": "Pullman Paris CDG", "chain": "Accor", "contract_id": "C-127", "allotment_id": "A-127", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-25T03:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-25T14:11:00Z", "duty_start_utc": "2026-08-25T14:05:00Z", "transfer_minutes": 14, "room_net": 262.85, "vat_rate": 10, "vat_amount": 26.29, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 294.34, "ancillaries": 21.04, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 294.34, "fx_rate": 1, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 294.34, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854567", "vcc_auth_amount": 340.38, "folio_amount": 315.38, "settled_amount": 315.38, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 294.34, "baseline_rate": 404.2, "market_rate": 392.07, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 266.38, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-25T06:12:00Z", "exception_resolved_at": "2026-08-25T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-25", "ingested_at": "2026-08-25T02:14:00Z", "version": 1, "public_rate": 404.2, "discount_pct": 27.18 }, { "id": "RS-8854696-1", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8854696", "duty_id": "D-514696", "layover_id": "L-514697", "crew_id": "FRA-1054", "crew_name": "T. Roussel", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "CDG", "country": "FR", "property_id": "P-127", "hotel": "Pullman Paris CDG", "chain": "Accor", "contract_id": "C-127", "allotment_id": "A-127", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-25T02:00:00Z", "checkin_time": "14:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-25T13:11:00Z", "duty_start_utc": "2026-08-25T14:05:00Z", "transfer_minutes": 14, "room_net": 263.53, "vat_rate": 10, "vat_amount": 26.35, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 295.08, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 295.08, "fx_rate": 1, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 295.08, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854696", "vcc_auth_amount": 320.08, "folio_amount": 295.08, "settled_amount": 295.08, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 295.08, "baseline_rate": 404.2, "market_rate": 392.07, "rate_honoured": 1, "customer": "DHL", "cost_centre": "MRS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 197.27, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-25T11:40:00Z", "exception_resolved_at": "2026-08-25T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-25", "ingested_at": "2026-08-25T02:14:00Z", "version": 1, "public_rate": 404.2, "discount_pct": 27 }, { "id": "RS-8854850-4", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8854850", "duty_id": "D-514850", "layover_id": "L-514851", "crew_id": "FRA-1066", "crew_name": "V. Roussel", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "LYS", "country": "FR", "property_id": "P-129", "hotel": "NH Lyon Airport", "chain": "NH", "contract_id": "C-129", "allotment_id": "A-129", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-22T03:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-25T14:10:00Z", "duty_start_utc": "2026-08-25T09:15:00Z", "transfer_minutes": 15, "room_net": 238.68, "vat_rate": 10, "vat_amount": 23.87, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 265.85, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 265.85, "fx_rate": 1, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 265.85, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854850", "vcc_auth_amount": 290.85, "folio_amount": 265.85, "settled_amount": 265.85, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 265.85, "baseline_rate": 382.65, "market_rate": 371.17, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "CDG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 222.56, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-25T11:40:00Z", "exception_resolved_at": "2026-08-25T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.5, "complaint_theme": "transfer", "source_file_id": "AIMS-2026-08-22", "ingested_at": "2026-08-25T02:14:00Z", "version": 1, "public_rate": 382.65, "discount_pct": 30.52 }, { "id": "RS-8853928-3", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8853928", "duty_id": "D-513928", "layover_id": "L-513929", "crew_id": "BEL-1067", "crew_name": "O. Wouters", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "HKG", "country": "HK", "property_id": "P-120", "hotel": "Regal Airport Hotel", "chain": "Regal", "contract_id": "C-120", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-22T02:00:00Z", "checkin_time": "14:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-24T12:29:00Z", "duty_start_utc": "2026-08-24T06:30:00Z", "transfer_minutes": 56, "room_net": 385.1, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 385.1, "ancillaries": 23.62, "fee": 0, "currency_local": "HKD", "rate_paid_local": 3217.83, "fx_rate": 0.119677, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 368.77, "markup": 16.33, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853928", "vcc_auth_amount": 344.5, "folio_amount": 408.72, "settled_amount": 408.72, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": 295.88, "baseline_rate": 405.01, "market_rate": 392.86, "rate_honoured": 0, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 271.37, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-24T17:22:00Z", "exception_resolved_at": "2026-08-24T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-22", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 405.01, "discount_pct": 4.92 }, { "id": "RS-8853993-4", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8853993", "duty_id": "D-513993", "layover_id": "L-513994", "crew_id": "BEL-1009", "crew_name": "Y. Lambert", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-112", "hotel": "Husa de la Couronne", "chain": "Independent", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-21T02:00:00Z", "checkin_time": "14:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-24T12:49:00Z", "duty_start_utc": "2026-08-24T06:30:00Z", "transfer_minutes": 36, "room_net": 291.86, "vat_rate": 6, "vat_amount": 17.51, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 313.37, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 313.37, "fx_rate": 1, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 313.37, "markup": 0, "commission_received": 28.48, "commission_shared": 14.24, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853993", "vcc_auth_amount": 338.37, "folio_amount": null, "settled_amount": null, "settled_at": null, "contracted_rate": null, "baseline_rate": 346.3, "market_rate": 335.91, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "crew_app", "change_cost": 279.46, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-24T17:22:00Z", "exception_resolved_at": "2026-08-24T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "awaiting_folio", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 346.3, "discount_pct": 9.51 }, { "id": "RS-8854290-2", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8854290", "duty_id": "D-514290", "layover_id": "L-514291", "crew_id": "BEL-S207", "crew_name": "M. Vermeulen", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-22T17:40:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-24T04:43:00Z", "duty_start_utc": "2026-08-24T09:15:00Z", "transfer_minutes": 22, "room_net": 243.88, "vat_rate": 6, "vat_amount": 14.63, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 262.51, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 262.51, "fx_rate": 1, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 245.21, "markup": 17.3, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854290", "vcc_auth_amount": 287.51, "folio_amount": 262.51, "settled_amount": 262.51, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": 262.51, "baseline_rate": 358.41, "market_rate": 347.66, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LGG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 261.71, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-24T21:05:00Z", "exception_resolved_at": "2026-08-24T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 358.41, "discount_pct": 26.76 }, { "id": "RS-8854364-1", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8854364", "duty_id": "D-514364", "layover_id": "L-514365", "crew_id": "BEL-1014", "crew_name": "B. De Smet", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-24T03:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-24T14:03:00Z", "duty_start_utc": "2026-08-24T11:50:00Z", "transfer_minutes": 22, "room_net": 245.16, "vat_rate": 6, "vat_amount": 14.71, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 263.87, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 263.87, "fx_rate": 1, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 263.87, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854364", "vcc_auth_amount": 288.87, "folio_amount": 263.87, "settled_amount": 263.87, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": 263.87, "baseline_rate": 358.41, "market_rate": 347.66, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 191.43, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-24T11:40:00Z", "exception_resolved_at": "2026-08-24T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-24", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 358.41, "discount_pct": 26.38 }, { "id": "RS-8854588-1", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8854588", "duty_id": "D-514588", "layover_id": "L-514589", "crew_id": "BEL-1038", "crew_name": "J. De Smet", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-23T13:15:00Z", "checkin_time": "01:15", "checkout_time": "10:00", "duty_end_utc": "2026-08-24T00:18:00Z", "duty_start_utc": "2026-08-24T06:30:00Z", "transfer_minutes": 22, "room_net": 243.68, "vat_rate": 6, "vat_amount": 14.62, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 262.3, "ancillaries": 19.28, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 262.3, "fx_rate": 1, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 262.3, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854588", "vcc_auth_amount": 306.58, "folio_amount": 281.58, "settled_amount": 281.58, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": 262.3, "baseline_rate": 358.41, "market_rate": 347.66, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 257.7, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-24T11:40:00Z", "exception_resolved_at": "2026-08-24T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.5, "complaint_theme": "food", "source_file_id": "AIMS-2026-08-24", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 358.41, "discount_pct": 26.82 }, { "id": "RS-8854677-2", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8854677", "duty_id": "D-514677", "layover_id": "L-514678", "crew_id": "FRA-1019", "crew_name": "J. Marchand", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "CDG", "country": "FR", "property_id": "P-126", "hotel": "Novotel Paris CDG", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-22T17:40:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-24T04:51:00Z", "duty_start_utc": "2026-08-24T14:05:00Z", "transfer_minutes": 14, "room_net": 327.91, "vat_rate": 10, "vat_amount": 32.79, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 365.9, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 365.9, "fx_rate": 1, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 333.22, "markup": 32.68, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854677", "vcc_auth_amount": 390.9, "folio_amount": 365.9, "settled_amount": 365.9, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": null, "baseline_rate": 403.16, "market_rate": 391.07, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 262.08, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-24T11:40:00Z", "exception_resolved_at": "2026-08-24T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 403.16, "discount_pct": 9.24 }, { "id": "RS-8852931-4", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8852931", "duty_id": "D-512931", "layover_id": "L-512932", "crew_id": "IRE-1052", "crew_name": "Y. Nolan", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "CGN", "country": "DE", "property_id": "P-107", "hotel": "Ibis Koln Messe", "chain": "Accor", "contract_id": "C-107", "allotment_id": "A-107", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-20T02:00:00Z", "checkin_time": "14:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-23T13:15:00Z", "duty_start_utc": "2026-08-23T14:05:00Z", "transfer_minutes": 10, "room_net": 232.91, "vat_rate": 7, "vat_amount": 16.3, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 254.21, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 254.21, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 238.97, "markup": 15.24, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852931", "vcc_auth_amount": 279.21, "folio_amount": 254.21, "settled_amount": 254.21, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": 254.21, "baseline_rate": 308.17, "market_rate": 298.92, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 200.74, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-23T21:05:00Z", "exception_resolved_at": "2026-08-23T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-20", "ingested_at": "2026-08-23T02:14:00Z", "version": 1, "public_rate": 308.17, "discount_pct": 17.51 }, { "id": "RS-8854232-1", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8854232", "duty_id": "D-514232", "layover_id": "L-514233", "crew_id": "BEL-1009", "crew_name": "Y. Lambert", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "HKG", "country": "HK", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "chain": "Marriott", "contract_id": "C-121", "allotment_id": "A-121", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-23T10:30:00Z", "checkin_time": "22:30", "checkout_time": "08:15", "duty_end_utc": "2026-08-23T21:11:00Z", "duty_start_utc": "2026-08-23T14:05:00Z", "transfer_minutes": 44, "room_net": 296.79, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 296.79, "ancillaries": 0, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2479.68, "fx_rate": 0.119689, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 273.55, "markup": 23.24, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854232", "vcc_auth_amount": 321.79, "folio_amount": 296.79, "settled_amount": 296.79, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": 296.79, "baseline_rate": 357.94, "market_rate": 347.2, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "crew_app", "change_cost": 249.13, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-23T06:12:00Z", "exception_resolved_at": "2026-08-23T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-23T02:14:00Z", "version": 1, "public_rate": 357.94, "discount_pct": 17.08 }, { "id": "RS-8854677-1", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8854677", "duty_id": "D-514677", "layover_id": "L-514678", "crew_id": "FRA-1019", "crew_name": "J. Marchand", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "CDG", "country": "FR", "property_id": "P-126", "hotel": "Novotel Paris CDG", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-22T17:40:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-23T04:51:00Z", "duty_start_utc": "2026-08-23T06:30:00Z", "transfer_minutes": 14, "room_net": 288.1, "vat_rate": 10, "vat_amount": 28.81, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 322.11, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 322.11, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 293.34, "markup": 28.77, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854677", "vcc_auth_amount": 347.11, "folio_amount": 322.11, "settled_amount": 322.11, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": null, "baseline_rate": 354.92, "market_rate": 344.27, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 248.1, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-23T06:12:00Z", "exception_resolved_at": "2026-08-23T18:40:00Z", "resolved_by": "human", "sla_breached": 1, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-23T02:14:00Z", "version": 1, "public_rate": 354.92, "discount_pct": 9.24 }, { "id": "RS-8853110-3", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8853110", "duty_id": "D-513110", "layover_id": "L-513111", "crew_id": "IRE-1057", "crew_name": "P. Quinn", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-20T02:00:00Z", "checkin_time": "14:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-22T13:02:00Z", "duty_start_utc": "2026-08-22T09:15:00Z", "transfer_minutes": 23, "room_net": 259.35, "vat_rate": 13.5, "vat_amount": 35.01, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 294.36, "ancillaries": 35.28, "fee": 0, "currency_local": "EUR", "rate_paid_local": 294.36, "fx_rate": 1, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 275.44, "markup": 18.92, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853110", "vcc_auth_amount": 324.61, "folio_amount": 329.64, "settled_amount": 329.64, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": 264.33, "baseline_rate": 309.75, "market_rate": 300.46, "rate_honoured": 0, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 209.74, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-22T06:12:00Z", "exception_resolved_at": "2026-08-22T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-20", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 309.75, "discount_pct": 4.97 }, { "id": "RS-8853792-2", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8853792", "duty_id": "D-513792", "layover_id": "L-513793", "crew_id": "IRE-1043", "crew_name": "Y. Mulligan", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-21T03:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-22T14:03:00Z", "duty_start_utc": "2026-08-22T09:15:00Z", "transfer_minutes": 22, "room_net": 243.22, "vat_rate": 6, "vat_amount": 14.59, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 261.81, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 261.81, "fx_rate": 1, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 261.81, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853792", "vcc_auth_amount": 286.81, "folio_amount": 261.81, "settled_amount": 261.81, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": 261.81, "baseline_rate": 314.81, "market_rate": 305.37, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 187.77, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-22T21:05:00Z", "exception_resolved_at": "2026-08-22T22:30:00Z", "resolved_by": "human", "sla_breached": 1, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 314.81, "discount_pct": 16.84 }, { "id": "RS-8854350-2", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8854350", "duty_id": "D-514350", "layover_id": "L-514351", "crew_id": "BEL-1050", "crew_name": "H. De Smet", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "HKG", "country": "HK", "property_id": "P-120", "hotel": "Regal Airport Hotel", "chain": "Regal", "contract_id": "C-120", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-21T10:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-22T20:59:00Z", "duty_start_utc": "2026-08-22T09:15:00Z", "transfer_minutes": 56, "room_net": 297.81, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 297.81, "ancillaries": 0, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2488.05, "fx_rate": 0.119696, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 297.81, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854350", "vcc_auth_amount": 322.81, "folio_amount": 297.81, "settled_amount": 297.81, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": 297.81, "baseline_rate": 362.3, "market_rate": 351.43, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 244.99, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-22T21:05:00Z", "exception_resolved_at": "2026-08-22T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 362.3, "discount_pct": 17.8 }, { "id": "RS-8852931-2", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8852931", "duty_id": "D-512931", "layover_id": "L-512932", "crew_id": "IRE-1052", "crew_name": "Y. Nolan", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "CGN", "country": "DE", "property_id": "P-107", "hotel": "Ibis Koln Messe", "chain": "Accor", "contract_id": "C-107", "allotment_id": "A-107", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-20T02:00:00Z", "checkin_time": "14:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-21T13:15:00Z", "duty_start_utc": "2026-08-21T09:15:00Z", "transfer_minutes": 10, "room_net": 232.91, "vat_rate": 7, "vat_amount": 16.3, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 254.21, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 254.21, "fx_rate": 1, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 238.97, "markup": 15.24, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852931", "vcc_auth_amount": 279.21, "folio_amount": 254.21, "settled_amount": 254.21, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 254.21, "baseline_rate": 336.24, "market_rate": 326.15, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 166.85, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-21T11:40:00Z", "exception_resolved_at": "2026-08-21T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-20", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 336.24, "discount_pct": 24.4 }, { "id": "RS-8853001-1", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8853001", "duty_id": "D-513001", "layover_id": "L-513002", "crew_id": "IRE-1073", "crew_name": "E. O Conaill", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "STN", "country": "GB", "property_id": "P-116", "hotel": "Hampton by Hilton Stansted", "chain": "Hilton", "contract_id": "C-116", "allotment_id": "A-116", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-21T03:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-21T14:07:00Z", "duty_start_utc": "2026-08-21T06:30:00Z", "transfer_minutes": 18, "room_net": 252.19, "vat_rate": 20, "vat_amount": 50.44, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 302.63, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 254.98, "fx_rate": 1.186893, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 302.63, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853001", "vcc_auth_amount": 327.63, "folio_amount": 302.63, "settled_amount": 302.63, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 302.63, "baseline_rate": 402.3, "market_rate": 390.23, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 278.86, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-21T21:05:00Z", "exception_resolved_at": "2026-08-21T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 402.3, "discount_pct": 24.78 }, { "id": "RS-8853792-1", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8853792", "duty_id": "D-513792", "layover_id": "L-513793", "crew_id": "IRE-1043", "crew_name": "Y. Mulligan", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-21T03:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-21T14:03:00Z", "duty_start_utc": "2026-08-21T11:50:00Z", "transfer_minutes": 22, "room_net": 243.22, "vat_rate": 6, "vat_amount": 14.59, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 261.81, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 261.81, "fx_rate": 1, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 261.81, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853792", "vcc_auth_amount": 286.81, "folio_amount": 261.81, "settled_amount": 261.81, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 261.81, "baseline_rate": 343.43, "market_rate": 333.13, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 200.2, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-21T21:05:00Z", "exception_resolved_at": "2026-08-21T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 343.43, "discount_pct": 23.77 }, { "id": "RS-8853148-3", "period": "2026-08", "night": "2026-08-18", "booking_id": "RS-8853148", "duty_id": "D-513148", "layover_id": "L-513149", "crew_id": "IRE-1025", "crew_name": "S. O Conaill", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-16T03:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-18T14:02:00Z", "duty_start_utc": "2026-08-18T14:05:00Z", "transfer_minutes": 23, "room_net": 231.35, "vat_rate": 13.5, "vat_amount": 31.23, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 262.58, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 262.58, "fx_rate": 1, "fx_date": "2026-08-18", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 243.47, "markup": 19.11, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853148", "vcc_auth_amount": 287.58, "folio_amount": 262.58, "settled_amount": 262.58, "settled_at": "2026-08-18T23:59:00Z", "contracted_rate": 262.58, "baseline_rate": 373.8, "market_rate": 362.59, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 266.49, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-18T11:40:00Z", "exception_resolved_at": "2026-08-18T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-16", "ingested_at": "2026-08-18T02:14:00Z", "version": 1, "public_rate": 373.8, "discount_pct": 29.75 }, { "id": "RS-8854149-2", "period": "2026-08", "night": "2026-08-18", "booking_id": "RS-8854149", "duty_id": "D-514149", "layover_id": "L-514150", "crew_id": "BEL-1008", "crew_name": "R. Dubois", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "DXB", "country": "AE", "property_id": "P-123", "hotel": "Le Meridien Dubai", "chain": "Marriott", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-17T02:00:00Z", "checkin_time": "14:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-18T12:37:00Z", "duty_start_utc": "2026-08-18T11:50:00Z", "transfer_minutes": 48, "room_net": 342.54, "vat_rate": 5, "vat_amount": 17.13, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 364.67, "ancillaries": 0, "fee": 0, "currency_local": "AED", "rate_paid_local": 1421.95, "fx_rate": 0.256458, "fx_date": "2026-08-18", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 331.78, "markup": 32.89, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854149", "vcc_auth_amount": 389.67, "folio_amount": 364.67, "settled_amount": 364.67, "settled_at": "2026-08-18T23:59:00Z", "contracted_rate": null, "baseline_rate": 409.11, "market_rate": 396.84, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "LGG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 236.61, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-18T11:40:00Z", "exception_resolved_at": "2026-08-18T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-17", "ingested_at": "2026-08-18T02:14:00Z", "version": 1, "public_rate": 409.11, "discount_pct": 10.86 }, { "id": "RS-8855037-2", "period": "2026-08", "night": "2026-08-18", "booking_id": "RS-8855037", "duty_id": "D-515037", "layover_id": "L-515038", "crew_id": "FRA-1053", "crew_name": "Y. Fontaine", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "MAD", "country": "ES", "property_id": "P-135", "hotel": "Melia Barajas", "chain": "Melia", "contract_id": "C-135", "allotment_id": "A-135", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "released", "lead_time_days": 0.5, "booking_created_at": "2026-08-17T04:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-18T15:11:00Z", "duty_start_utc": "2026-08-18T09:15:00Z", "transfer_minutes": 14, "room_net": 267.14, "vat_rate": 10, "vat_amount": 26.71, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 293.85, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 293.85, "fx_rate": 1, "fx_date": "2026-08-18", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 293.85, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855037", "vcc_auth_amount": 318.85, "folio_amount": 293.85, "settled_amount": 293.85, "settled_at": "2026-08-18T23:59:00Z", "contracted_rate": 293.85, "baseline_rate": 421.13, "market_rate": 408.5, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 185.55, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-18T11:40:00Z", "exception_resolved_at": "2026-08-18T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-17", "ingested_at": "2026-08-18T02:14:00Z", "version": 1, "public_rate": 421.13, "discount_pct": 30.22 }, { "id": "RS-8853148-2", "period": "2026-08", "night": "2026-08-17", "booking_id": "RS-8853148", "duty_id": "D-513148", "layover_id": "L-513149", "crew_id": "IRE-1025", "crew_name": "S. O Conaill", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-16T03:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-17T14:02:00Z", "duty_start_utc": "2026-08-17T14:05:00Z", "transfer_minutes": 23, "room_net": 231.35, "vat_rate": 13.5, "vat_amount": 31.23, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 262.58, "ancillaries": 24.59, "fee": 0, "currency_local": "EUR", "rate_paid_local": 262.58, "fx_rate": 1, "fx_date": "2026-08-17", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 243.47, "markup": 19.11, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853148", "vcc_auth_amount": 312.17, "folio_amount": 287.17, "settled_amount": 287.17, "settled_at": "2026-08-17T23:59:00Z", "contracted_rate": 262.58, "baseline_rate": 345.49, "market_rate": 335.13, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 205.72, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-17T06:12:00Z", "exception_resolved_at": "2026-08-17T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-16", "ingested_at": "2026-08-17T02:14:00Z", "version": 1, "public_rate": 345.49, "discount_pct": 24 }, { "id": "RS-8853006-2", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8853006", "duty_id": "D-513006", "layover_id": "L-513007", "crew_id": "IRE-1081", "crew_name": "A. Quinn", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "EMA", "country": "GB", "property_id": "P-106", "hotel": "Premier Inn Kegworth", "chain": "Whitbread", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-15T04:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-16T14:47:00Z", "duty_start_utc": "2026-08-16T14:05:00Z", "transfer_minutes": 38, "room_net": 263.7, "vat_rate": 20, "vat_amount": 52.74, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 316.44, "ancillaries": 10.11, "fee": 0, "currency_local": "GBP", "rate_paid_local": 267.35, "fx_rate": 1.183628, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 284.15, "markup": 32.29, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853006", "vcc_auth_amount": 351.55, "folio_amount": 326.55, "settled_amount": 326.55, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": null, "baseline_rate": 347.94, "market_rate": 337.5, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 197.4, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-16T21:05:00Z", "exception_resolved_at": "2026-08-16T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 4.6, "complaint_theme": null, "source_file_id": "AIMS-2026-08-15", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 347.94, "discount_pct": 9.05 }, { "id": "RS-8853125-3", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8853125", "duty_id": "D-513125", "layover_id": "L-513126", "crew_id": "IRE-1061", "crew_name": "K. O Conaill", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "CGN", "country": "DE", "property_id": "P-107", "hotel": "Ibis Koln Messe", "chain": "Accor", "contract_id": "C-107", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-14T04:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-16T15:15:00Z", "duty_start_utc": "2026-08-16T09:15:00Z", "transfer_minutes": 10, "room_net": 234.87, "vat_rate": 7, "vat_amount": 16.44, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 256.31, "ancillaries": 21.93, "fee": 0, "currency_local": "EUR", "rate_paid_local": 256.31, "fx_rate": 1, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 242.26, "markup": 14.05, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853125", "vcc_auth_amount": 303.24, "folio_amount": 278.24, "settled_amount": 278.24, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": 256.31, "baseline_rate": 318.9, "market_rate": 309.33, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 265.8, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-16T21:05:00Z", "exception_resolved_at": "2026-08-16T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 318.9, "discount_pct": 19.63 }, { "id": "RS-8853148-1", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8853148", "duty_id": "D-513148", "layover_id": "L-513149", "crew_id": "IRE-1025", "crew_name": "S. O Conaill", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-16T03:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-16T14:02:00Z", "duty_start_utc": "2026-08-16T06:30:00Z", "transfer_minutes": 23, "room_net": 231.35, "vat_rate": 13.5, "vat_amount": 31.23, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 262.58, "ancillaries": 34.64, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 262.58, "fx_rate": 1, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 243.47, "markup": 19.11, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853148", "vcc_auth_amount": 322.22, "folio_amount": 297.22, "settled_amount": 297.22, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": 262.58, "baseline_rate": 311.9, "market_rate": 302.54, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 172.88, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-16T11:40:00Z", "exception_resolved_at": "2026-08-16T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-16", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 311.9, "discount_pct": 15.81 }, { "id": "RS-8855148-1", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8855148", "duty_id": "D-515148", "layover_id": "L-515149", "crew_id": "FRA-1036", "crew_name": "A. Moreau", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "CDG", "country": "FR", "property_id": "P-127", "hotel": "Pullman Paris CDG", "chain": "Accor", "contract_id": "C-127", "allotment_id": "A-127", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-15T17:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-16T04:51:00Z", "duty_start_utc": "2026-08-16T09:15:00Z", "transfer_minutes": 14, "room_net": 265.16, "vat_rate": 10, "vat_amount": 26.52, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 296.88, "ancillaries": 26.3, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 296.88, "fx_rate": 1, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 280.77, "markup": 16.11, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855148", "vcc_auth_amount": 348.18, "folio_amount": 323.18, "settled_amount": 323.18, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": 296.88, "baseline_rate": 354.77, "market_rate": 344.13, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 187.37, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-16T17:22:00Z", "exception_resolved_at": "2026-08-16T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-16", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 354.77, "discount_pct": 16.32 }, { "id": "RS-8855216-3", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8855216", "duty_id": "D-515216", "layover_id": "L-515217", "crew_id": "FRA-1048", "crew_name": "D. Moreau", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "MRS", "country": "FR", "property_id": "P-131", "hotel": "Best Western Marseille Airport", "chain": "BWH", "contract_id": "C-131", "allotment_id": "A-131", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-14T03:00:00Z", "checkin_time": "15:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-16T14:07:00Z", "duty_start_utc": "2026-08-16T09:15:00Z", "transfer_minutes": 18, "room_net": 242.85, "vat_rate": 10, "vat_amount": 24.28, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 270.43, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 270.43, "fx_rate": 1, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 270.43, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855216", "vcc_auth_amount": 295.43, "folio_amount": 270.43, "settled_amount": 270.43, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": 270.43, "baseline_rate": 314.89, "market_rate": 305.44, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 169.43, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-16T11:40:00Z", "exception_resolved_at": "2026-08-16T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 314.89, "discount_pct": 14.12 }, { "id": "RS-8853825-2", "period": "2026-08", "night": "2026-08-15", "booking_id": "RS-8853825", "duty_id": "D-513825", "layover_id": "L-513826", "crew_id": "IRE-1049", "crew_name": "N. O Conaill", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-14T03:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-15T14:03:00Z", "duty_start_utc": "2026-08-15T06:30:00Z", "transfer_minutes": 22, "room_net": 240.67, "vat_rate": 6, "vat_amount": 14.44, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 259.11, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 259.11, "fx_rate": 1, "fx_date": "2026-08-15", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 241.59, "markup": 17.52, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853825", "vcc_auth_amount": 284.11, "folio_amount": 259.11, "settled_amount": 259.11, "settled_at": "2026-08-15T23:59:00Z", "contracted_rate": 259.11, "baseline_rate": 316.41, "market_rate": 306.92, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 223.63, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-15T11:40:00Z", "exception_resolved_at": "2026-08-15T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-15T02:14:00Z", "version": 1, "public_rate": 316.41, "discount_pct": 18.11 }, { "id": "RS-8853895-1", "period": "2026-08", "night": "2026-08-15", "booking_id": "RS-8853895", "duty_id": "D-513895", "layover_id": "L-513896", "crew_id": "BEL-S215", "crew_name": "N. Dubois", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-111", "hotel": "Ibis Liege Centre", "chain": "Accor", "contract_id": "C-111", "allotment_id": "A-111", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-15T04:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-15T15:02:00Z", "duty_start_utc": "2026-08-15T06:30:00Z", "transfer_minutes": 23, "room_net": 255.24, "vat_rate": 6, "vat_amount": 15.31, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 274.55, "ancillaries": 14.31, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 274.55, "fx_rate": 1, "fx_date": "2026-08-15", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 274.55, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853895", "vcc_auth_amount": 313.86, "folio_amount": 288.86, "settled_amount": 288.86, "settled_at": "2026-08-15T23:59:00Z", "contracted_rate": 274.55, "baseline_rate": 336.69, "market_rate": 326.59, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 227.29, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-15T06:12:00Z", "exception_resolved_at": "2026-08-15T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-15", "ingested_at": "2026-08-15T02:14:00Z", "version": 1, "public_rate": 336.69, "discount_pct": 18.46 }, { "id": "RS-8853125-1", "period": "2026-08", "night": "2026-08-14", "booking_id": "RS-8853125", "duty_id": "D-513125", "layover_id": "L-513126", "crew_id": "IRE-1061", "crew_name": "K. O Conaill", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "CGN", "country": "DE", "property_id": "P-107", "hotel": "Ibis Koln Messe", "chain": "Accor", "contract_id": "C-107", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-14T04:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-14T15:15:00Z", "duty_start_utc": "2026-08-14T14:05:00Z", "transfer_minutes": 10, "room_net": 234.87, "vat_rate": 7, "vat_amount": 16.44, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 256.31, "ancillaries": 22.37, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 256.31, "fx_rate": 1, "fx_date": "2026-08-14", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 242.26, "markup": 14.05, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853125", "vcc_auth_amount": 303.68, "folio_amount": 278.68, "settled_amount": 278.68, "settled_at": "2026-08-14T23:59:00Z", "contracted_rate": 256.31, "baseline_rate": 344.66, "market_rate": 334.32, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 281.04, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-14T17:22:00Z", "exception_resolved_at": "2026-08-14T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-14T02:14:00Z", "version": 1, "public_rate": 344.66, "discount_pct": 25.63 }, { "id": "RS-8854568-1", "period": "2026-08", "night": "2026-08-14", "booking_id": "RS-8854568", "duty_id": "D-514568", "layover_id": "L-514569", "crew_id": "BEL-1066", "crew_name": "A. Claes", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "CDG", "country": "FR", "property_id": "P-126", "hotel": "Novotel Paris CDG", "chain": "Accor", "contract_id": "C-126", "allotment_id": "A-126", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-13T13:15:00Z", "checkin_time": "01:15", "checkout_time": "10:00", "duty_end_utc": "2026-08-14T00:26:00Z", "duty_start_utc": "2026-08-14T09:15:00Z", "transfer_minutes": 14, "room_net": 262.9, "vat_rate": 10, "vat_amount": 26.29, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 294.39, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 294.39, "fx_rate": 1, "fx_date": "2026-08-14", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 274.21, "markup": 20.18, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854568", "vcc_auth_amount": 319.39, "folio_amount": 294.39, "settled_amount": 294.39, "settled_at": "2026-08-14T23:59:00Z", "contracted_rate": 294.39, "baseline_rate": 390.83, "market_rate": 379.11, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 229.73, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-14T06:12:00Z", "exception_resolved_at": "2026-08-14T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-14T02:14:00Z", "version": 1, "public_rate": 390.83, "discount_pct": 24.68 }, { "id": "RS-8852936-2", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8852936", "duty_id": "D-512936", "layover_id": "L-512937", "crew_id": "IRE-1006", "crew_name": "E. Brennan", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-12T10:30:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-13T21:33:00Z", "duty_start_utc": "2026-08-13T09:15:00Z", "transfer_minutes": 22, "room_net": 243.22, "vat_rate": 6, "vat_amount": 14.59, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 261.81, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 261.81, "fx_rate": 1, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 247.1, "markup": 14.71, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852936", "vcc_auth_amount": 286.81, "folio_amount": 261.81, "settled_amount": 261.81, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 261.81, "baseline_rate": 361.47, "market_rate": 350.63, "rate_honoured": 1, "customer": "UPS", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 199.24, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-13T06:12:00Z", "exception_resolved_at": "2026-08-13T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-12", "ingested_at": "2026-08-13T02:14:00Z", "version": 1, "public_rate": 361.47, "discount_pct": 27.57 }, { "id": "RS-8853250-3", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8853250", "duty_id": "D-513250", "layover_id": "L-513251", "crew_id": "IRE-S209", "crew_name": "H. Doyle", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-13T13:02:00Z", "duty_start_utc": "2026-08-13T11:50:00Z", "transfer_minutes": 23, "room_net": 230.18, "vat_rate": 13.5, "vat_amount": 31.07, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 261.25, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 261.25, "fx_rate": 1, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 261.25, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853250", "vcc_auth_amount": 286.25, "folio_amount": 261.25, "settled_amount": 261.25, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 261.25, "baseline_rate": 359.22, "market_rate": 348.44, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 235.76, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-13T17:22:00Z", "exception_resolved_at": "2026-08-13T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-13T02:14:00Z", "version": 1, "public_rate": 359.22, "discount_pct": 27.27 }, { "id": "RS-8854897-3", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8854897", "duty_id": "D-514897", "layover_id": "L-514898", "crew_id": "FRA-1054", "crew_name": "T. Roussel", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "TLS", "country": "FR", "property_id": "P-133", "hotel": "Pullman Toulouse Airport", "chain": "Accor", "contract_id": "C-133", "allotment_id": "A-133", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-13T13:03:00Z", "duty_start_utc": "2026-08-13T06:30:00Z", "transfer_minutes": 22, "room_net": 225.74, "vat_rate": 10, "vat_amount": 22.57, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 251.19, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 251.19, "fx_rate": 1, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 251.19, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854897", "vcc_auth_amount": 276.19, "folio_amount": 251.19, "settled_amount": 251.19, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 251.19, "baseline_rate": 349.74, "market_rate": 339.25, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "MRS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 222.39, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-13T17:22:00Z", "exception_resolved_at": "2026-08-13T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-13T02:14:00Z", "version": 1, "public_rate": 349.74, "discount_pct": 28.18 }, { "id": "RS-8853013-1", "period": "2026-08", "night": "2026-08-12", "booking_id": "RS-8853013", "duty_id": "D-513013", "layover_id": "L-513014", "crew_id": "IRE-1046", "crew_name": "L. Cassidy", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "BHX", "country": "GB", "property_id": "P-113", "hotel": "Novotel Birmingham Airport", "chain": "Accor", "contract_id": "C-113", "allotment_id": "A-113", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T17:40:00Z", "checkin_time": "05:40", "checkout_time": "08:15", "duty_end_utc": "2026-08-12T04:41:00Z", "duty_start_utc": "2026-08-12T14:05:00Z", "transfer_minutes": 24, "room_net": 233.3, "vat_rate": 20, "vat_amount": 46.66, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 279.96, "ancillaries": 14.63, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 236.77, "fx_rate": 1.18241, "fx_date": "2026-08-12", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 279.96, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853013", "vcc_auth_amount": 319.59, "folio_amount": 294.59, "settled_amount": 294.59, "settled_at": "2026-08-12T23:59:00Z", "contracted_rate": 279.96, "baseline_rate": 401.16, "market_rate": 389.13, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 200.38, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-12T21:05:00Z", "exception_resolved_at": "2026-08-12T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-12", "ingested_at": "2026-08-12T02:14:00Z", "version": 1, "public_rate": 401.16, "discount_pct": 30.21 }, { "id": "RS-8853179-1", "period": "2026-08", "night": "2026-08-12", "booking_id": "RS-8853179", "duty_id": "D-513179", "layover_id": "L-513180", "crew_id": "IRE-1089", "crew_name": "T. Fitzgerald", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "CGN", "country": "DE", "property_id": "P-107", "hotel": "Ibis Koln Messe", "chain": "Accor", "contract_id": "C-107", "allotment_id": "A-107", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T13:15:00Z", "checkin_time": "01:15", "checkout_time": "04:30", "duty_end_utc": "2026-08-12T00:30:00Z", "duty_start_utc": "2026-08-12T11:50:00Z", "transfer_minutes": 10, "room_net": 232.46, "vat_rate": 7, "vat_amount": 16.27, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 253.73, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 253.73, "fx_rate": 1, "fx_date": "2026-08-12", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 233.87, "markup": 19.86, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853179", "vcc_auth_amount": 278.73, "folio_amount": 253.73, "settled_amount": 253.73, "settled_at": "2026-08-12T23:59:00Z", "contracted_rate": 253.73, "baseline_rate": 372.17, "market_rate": 361, "rate_honoured": 1, "customer": "UPS", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 211.7, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-12T17:22:00Z", "exception_resolved_at": "2026-08-12T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.5, "complaint_theme": "food", "source_file_id": "AIMS-2026-08-12", "ingested_at": "2026-08-12T02:14:00Z", "version": 1, "public_rate": 372.17, "discount_pct": 31.82 }, { "id": "RS-8853250-2", "period": "2026-08", "night": "2026-08-12", "booking_id": "RS-8853250", "duty_id": "D-513250", "layover_id": "L-513251", "crew_id": "IRE-S209", "crew_name": "H. Doyle", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-12T13:02:00Z", "duty_start_utc": "2026-08-12T09:15:00Z", "transfer_minutes": 23, "room_net": 301.74, "vat_rate": 13.5, "vat_amount": 40.74, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 342.48, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 342.48, "fx_rate": 1, "fx_date": "2026-08-12", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 342.48, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853250", "vcc_auth_amount": 286.25, "folio_amount": 342.48, "settled_amount": 342.48, "settled_at": "2026-08-12T23:59:00Z", "contracted_rate": 261.25, "baseline_rate": 376.44, "market_rate": 365.15, "rate_honoured": 0, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 177.17, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-12T17:22:00Z", "exception_resolved_at": "2026-08-12T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.3, "complaint_theme": "checkin", "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-12T02:14:00Z", "version": 1, "public_rate": 376.44, "discount_pct": 9.02 }, { "id": "RS-8852815-1", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8852815", "duty_id": "D-512815", "layover_id": "L-512816", "crew_id": "IRE-1071", "crew_name": "V. Devlin", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "EMA", "country": "GB", "property_id": "P-104", "hotel": "Hilton East Midlands", "chain": "Hilton", "contract_id": "C-104", "allotment_id": "A-104", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T03:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-11T14:10:00Z", "duty_start_utc": "2026-08-11T06:30:00Z", "transfer_minutes": 15, "room_net": 248.63, "vat_rate": 20, "vat_amount": 49.72, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 298.35, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 251.9, "fx_rate": 1.184406, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 276.36, "markup": 21.99, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852815", "vcc_auth_amount": 323.35, "folio_amount": 298.35, "settled_amount": 298.35, "settled_at": "2026-08-11T23:59:00Z", "contracted_rate": 298.35, "baseline_rate": 429.45, "market_rate": 416.57, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 164.51, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-11T06:12:00Z", "exception_resolved_at": "2026-08-11T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-11T02:14:00Z", "version": 1, "public_rate": 429.45, "discount_pct": 30.53 }, { "id": "RS-8853114-4", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8853114", "duty_id": "D-513114", "layover_id": "L-513115", "crew_id": "IRE-1062", "crew_name": "T. Doyle", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "EMA", "country": "GB", "property_id": "P-105", "hotel": "Holiday Inn Castle Donington", "chain": "IHG", "contract_id": "C-105", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-07T13:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-11T00:29:00Z", "duty_start_utc": "2026-08-11T11:50:00Z", "transfer_minutes": 11, "room_net": 248.44, "vat_rate": 20, "vat_amount": 49.69, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 298.13, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 251.71, "fx_rate": 1.184406, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 276.77, "markup": 21.36, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853114", "vcc_auth_amount": 323.13, "folio_amount": 298.13, "settled_amount": 298.13, "settled_at": "2026-08-11T23:59:00Z", "contracted_rate": 298.13, "baseline_rate": 407.44, "market_rate": 395.22, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 266.52, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-11T17:22:00Z", "exception_resolved_at": "2026-08-11T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "recovered", "recon_amount": 409.25, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-08", "ingested_at": "2026-08-11T02:14:00Z", "version": 1, "public_rate": 407.44, "discount_pct": 26.83 }, { "id": "RS-8853250-1", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8853250", "duty_id": "D-513250", "layover_id": "L-513251", "crew_id": "IRE-S209", "crew_name": "H. Doyle", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-11T13:02:00Z", "duty_start_utc": "2026-08-11T11:50:00Z", "transfer_minutes": 23, "room_net": 302.19, "vat_rate": 13.5, "vat_amount": 40.8, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 342.99, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 342.99, "fx_rate": 1, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 342.99, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853250", "vcc_auth_amount": 286.25, "folio_amount": null, "settled_amount": null, "settled_at": null, "contracted_rate": 261.25, "baseline_rate": 376.89, "market_rate": 365.58, "rate_honoured": 0, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 261.16, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-11T06:12:00Z", "exception_resolved_at": "2026-08-11T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "awaiting_folio", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-11T02:14:00Z", "version": 1, "public_rate": 376.89, "discount_pct": 8.99 }, { "id": "RS-8854952-1", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8854952", "duty_id": "D-514952", "layover_id": "L-514953", "crew_id": "FRA-1088", "crew_name": "O. Lefevre", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "TLS", "country": "FR", "property_id": "P-133", "hotel": "Pullman Toulouse Airport", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T10:30:00Z", "checkin_time": "22:30", "checkout_time": "12:00", "duty_end_utc": "2026-08-11T21:33:00Z", "duty_start_utc": "2026-08-11T14:05:00Z", "transfer_minutes": 22, "room_net": 287.76, "vat_rate": 10, "vat_amount": 28.78, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 319.42, "ancillaries": 11.46, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 319.42, "fx_rate": 1, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 319.42, "markup": 0, "commission_received": 31.93, "commission_shared": 15.96, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854952", "vcc_auth_amount": 355.88, "folio_amount": 330.88, "settled_amount": 330.88, "settled_at": "2026-08-11T23:59:00Z", "contracted_rate": null, "baseline_rate": 350.08, "market_rate": 339.58, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 240.53, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-11T11:40:00Z", "exception_resolved_at": "2026-08-11T07:05:00Z", "resolved_by": "human", "sla_breached": 1, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-11T02:14:00Z", "version": 1, "public_rate": 350.08, "discount_pct": 8.76 }, { "id": "RS-8853017-1", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853017", "duty_id": "D-513017", "layover_id": "L-513018", "crew_id": "IRE-1030", "crew_name": "G. Brennan", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "EMA", "country": "GB", "property_id": "P-104", "hotel": "Hilton East Midlands", "chain": "Hilton", "contract_id": "C-104", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-10T10:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-10T21:40:00Z", "duty_start_utc": "2026-08-10T06:30:00Z", "transfer_minutes": 15, "room_net": 248.28, "vat_rate": 20, "vat_amount": 49.66, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 297.94, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 251.33, "fx_rate": 1.185465, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 281.65, "markup": 16.29, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853017", "vcc_auth_amount": 322.94, "folio_amount": 297.94, "settled_amount": 297.94, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": 297.94, "baseline_rate": 405.68, "market_rate": 393.51, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 277.31, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-10T17:22:00Z", "exception_resolved_at": "2026-08-10T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-10", "ingested_at": "2026-08-10T02:14:00Z", "version": 1, "public_rate": 405.68, "discount_pct": 26.56 }, { "id": "RS-8853553-3", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853553", "duty_id": "D-513553", "layover_id": "L-513554", "crew_id": "IRE-1014", "crew_name": "Y. Doyle", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "BHX", "country": "GB", "property_id": "P-114", "hotel": "Ibis Birmingham Airport", "chain": "Accor", "contract_id": "C-114", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-08T03:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-10T14:02:00Z", "duty_start_utc": "2026-08-10T06:30:00Z", "transfer_minutes": 23, "room_net": 234.38, "vat_rate": 20, "vat_amount": 46.88, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 281.26, "ancillaries": 35.5, "fee": 0, "currency_local": "GBP", "rate_paid_local": 237.26, "fx_rate": 1.185465, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 281.26, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853553", "vcc_auth_amount": 341.76, "folio_amount": 316.76, "settled_amount": 316.76, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": 281.26, "baseline_rate": 369.77, "market_rate": 358.68, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 198.66, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-10T06:12:00Z", "exception_resolved_at": "2026-08-10T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-08", "ingested_at": "2026-08-10T02:14:00Z", "version": 1, "public_rate": 369.77, "discount_pct": 23.94 }, { "id": "RS-8853646-2", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853646", "duty_id": "D-513646", "layover_id": "L-513647", "crew_id": "IRE-1029", "crew_name": "K. Fitzgerald", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "CGN", "country": "DE", "property_id": "P-107", "hotel": "Ibis Koln Messe", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-08T17:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-10T04:55:00Z", "duty_start_utc": "2026-08-10T11:50:00Z", "transfer_minutes": 10, "room_net": 292.93, "vat_rate": 7, "vat_amount": 20.51, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 318.44, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 318.44, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 318.44, "markup": 0, "commission_received": 25.56, "commission_shared": 12.78, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853646", "vcc_auth_amount": 343.44, "folio_amount": 318.44, "settled_amount": 318.44, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": null, "baseline_rate": 350.62, "market_rate": 340.1, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 171.64, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-10T21:05:00Z", "exception_resolved_at": "2026-08-10T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-09", "ingested_at": "2026-08-10T02:14:00Z", "version": 1, "public_rate": 350.62, "discount_pct": 9.18 }, { "id": "RS-8853646-1", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8853646", "duty_id": "D-513646", "layover_id": "L-513647", "crew_id": "IRE-1029", "crew_name": "K. Fitzgerald", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "CGN", "country": "DE", "property_id": "P-107", "hotel": "Ibis Koln Messe", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-08T17:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-09T04:55:00Z", "duty_start_utc": "2026-08-09T14:05:00Z", "transfer_minutes": 10, "room_net": 253.97, "vat_rate": 7, "vat_amount": 17.78, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 276.75, "ancillaries": 13.63, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 276.75, "fx_rate": 1, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 276.75, "markup": 0, "commission_received": 22.22, "commission_shared": 11.11, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853646", "vcc_auth_amount": 315.38, "folio_amount": 290.38, "settled_amount": 290.38, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": null, "baseline_rate": 304.71, "market_rate": 295.57, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 178.6, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-09T21:05:00Z", "exception_resolved_at": "2026-08-09T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-09", "ingested_at": "2026-08-09T02:14:00Z", "version": 1, "public_rate": 304.71, "discount_pct": 9.18 }, { "id": "RS-8853885-2", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8853885", "duty_id": "D-513885", "layover_id": "L-513886", "crew_id": "BEL-1035", "crew_name": "V. Verhoeven", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "HKG", "country": "HK", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "chain": "Marriott", "contract_id": "C-121", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-08T03:00:00Z", "checkin_time": "15:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-09T13:41:00Z", "duty_start_utc": "2026-08-09T06:30:00Z", "transfer_minutes": 44, "room_net": 294.33, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 294.33, "ancillaries": 0, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2451.57, "fx_rate": 0.120058, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 277.4, "markup": 16.93, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853885", "vcc_auth_amount": 319.33, "folio_amount": 294.33, "settled_amount": 294.33, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": 294.33, "baseline_rate": 368.48, "market_rate": 357.43, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 247, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-09T21:05:00Z", "exception_resolved_at": "2026-08-09T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-08", "ingested_at": "2026-08-09T02:14:00Z", "version": 1, "public_rate": 368.48, "discount_pct": 20.12 }, { "id": "RS-8854714-1", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8854714", "duty_id": "D-514714", "layover_id": "L-514715", "crew_id": "FRA-1084", "crew_name": "B. Moreau", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "MRS", "country": "FR", "property_id": "P-131", "hotel": "Best Western Marseille Airport", "chain": "BWH", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-09T04:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-09T15:07:00Z", "duty_start_utc": "2026-08-09T14:05:00Z", "transfer_minutes": 18, "room_net": 257.96, "vat_rate": 10, "vat_amount": 25.8, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 287.06, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 287.06, "fx_rate": 1, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 287.06, "markup": 0, "commission_received": 27.48, "commission_shared": 13.74, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854714", "vcc_auth_amount": 312.06, "folio_amount": 287.06, "settled_amount": 287.06, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": null, "baseline_rate": 313.24, "market_rate": 303.84, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 213.87, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-09T17:22:00Z", "exception_resolved_at": "2026-08-09T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-09", "ingested_at": "2026-08-09T02:14:00Z", "version": 1, "public_rate": 313.24, "discount_pct": 8.36 }, { "id": "RS-8853885-1", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8853885", "duty_id": "D-513885", "layover_id": "L-513886", "crew_id": "BEL-1035", "crew_name": "V. Verhoeven", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "HKG", "country": "HK", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "chain": "Marriott", "contract_id": "C-121", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-08T03:00:00Z", "checkin_time": "15:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-08T13:41:00Z", "duty_start_utc": "2026-08-08T11:50:00Z", "transfer_minutes": 44, "room_net": 294.33, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 294.33, "ancillaries": 14.37, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2449.69, "fx_rate": 0.12015, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 277.4, "markup": 16.93, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853885", "vcc_auth_amount": 333.7, "folio_amount": 308.7, "settled_amount": 308.7, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": 294.33, "baseline_rate": 357.63, "market_rate": 346.9, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 196.77, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-08T21:05:00Z", "exception_resolved_at": "2026-08-08T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-08", "ingested_at": "2026-08-08T02:14:00Z", "version": 1, "public_rate": 357.63, "discount_pct": 17.7 }, { "id": "RS-8854388-2", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8854388", "duty_id": "D-514388", "layover_id": "L-514389", "crew_id": "BEL-1032", "crew_name": "B. Dubois", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-111", "hotel": "Ibis Liege Centre", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-06T13:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-08T00:17:00Z", "duty_start_utc": "2026-08-08T14:05:00Z", "transfer_minutes": 23, "room_net": 290.11, "vat_rate": 6, "vat_amount": 17.41, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 311.52, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 311.52, "fx_rate": 1, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 311.52, "markup": 0, "commission_received": 32.3, "commission_shared": 16.15, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854388", "vcc_auth_amount": 336.52, "folio_amount": 311.52, "settled_amount": 311.52, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": null, "baseline_rate": 328.75, "market_rate": 318.89, "rate_honoured": 1, "customer": "UPS", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 189.3, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-08T11:40:00Z", "exception_resolved_at": "2026-08-08T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-07", "ingested_at": "2026-08-08T02:14:00Z", "version": 1, "public_rate": 328.75, "discount_pct": 5.24 }, { "id": "RS-8854901-3", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8854901", "duty_id": "D-514901", "layover_id": "L-514902", "crew_id": "FRA-1035", "crew_name": "P. Berger", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "LYS", "country": "FR", "property_id": "P-130", "hotel": "Comfort Hotel Lyon", "chain": "Choice", "contract_id": "C-130", "allotment_id": "A-130", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-06T04:00:00Z", "checkin_time": "16:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-08T15:15:00Z", "duty_start_utc": "2026-08-08T06:30:00Z", "transfer_minutes": 10, "room_net": 246.85, "vat_rate": 10, "vat_amount": 24.69, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 274.84, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 274.84, "fx_rate": 1, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 256.27, "markup": 18.57, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854901", "vcc_auth_amount": 299.84, "folio_amount": 274.84, "settled_amount": 274.84, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": 274.84, "baseline_rate": 317.8, "market_rate": 308.27, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "CDG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 204.97, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-08T21:05:00Z", "exception_resolved_at": "2026-08-08T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-06", "ingested_at": "2026-08-08T02:14:00Z", "version": 1, "public_rate": 317.8, "discount_pct": 13.52 }, { "id": "RS-8854931-2", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8854931", "duty_id": "D-514931", "layover_id": "L-514932", "crew_id": "FRA-1069", "crew_name": "Y. Perrin", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "MAD", "country": "ES", "property_id": "P-136", "hotel": "Novotel Madrid Barajas", "chain": "Accor", "contract_id": "C-136", "allotment_id": "A-136", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-06T17:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-08T04:42:00Z", "duty_start_utc": "2026-08-08T11:50:00Z", "transfer_minutes": 23, "room_net": 286.4, "vat_rate": 10, "vat_amount": 28.64, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 315.04, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 315.04, "fx_rate": 1, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 295.61, "markup": 19.43, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854931", "vcc_auth_amount": 298.79, "folio_amount": 315.04, "settled_amount": 315.04, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": 273.79, "baseline_rate": 321.61, "market_rate": 311.96, "rate_honoured": 0, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 162.16, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-08T21:05:00Z", "exception_resolved_at": "2026-08-08T22:30:00Z", "resolved_by": "human", "sla_breached": 1, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-07", "ingested_at": "2026-08-08T02:14:00Z", "version": 1, "public_rate": 321.61, "discount_pct": 2.04 }, { "id": "RS-8854246-1", "period": "2026-08", "night": "2026-08-07", "booking_id": "RS-8854246", "duty_id": "D-514246", "layover_id": "L-514247", "crew_id": "BEL-1087", "crew_name": "H. Peeters", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "JNB", "country": "ZA", "property_id": "P-125", "hotel": "InterContinental OR Tambo", "chain": "IHG", "contract_id": "C-125", "allotment_id": "A-125", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-07T03:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-07T13:41:00Z", "duty_start_utc": "2026-08-07T14:05:00Z", "transfer_minutes": 44, "room_net": 209.02, "vat_rate": 15, "vat_amount": 31.35, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 240.37, "ancillaries": 13.78, "fee": 15.97, "currency_local": "ZAR", "rate_paid_local": 4772.94, "fx_rate": 0.050361, "fx_date": "2026-08-07", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 223.76, "markup": 16.61, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854246", "vcc_auth_amount": 279.15, "folio_amount": 254.15, "settled_amount": 254.15, "settled_at": "2026-08-07T23:59:00Z", "contracted_rate": 240.37, "baseline_rate": 309.89, "market_rate": 300.59, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 179.36, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-07T11:40:00Z", "exception_resolved_at": "2026-08-07T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 3.3, "complaint_theme": null, "source_file_id": "AIMS-2026-08-07", "ingested_at": "2026-08-07T02:14:00Z", "version": 1, "public_rate": 309.89, "discount_pct": 22.43 }, { "id": "RS-8854901-2", "period": "2026-08", "night": "2026-08-07", "booking_id": "RS-8854901", "duty_id": "D-514901", "layover_id": "L-514902", "crew_id": "FRA-1035", "crew_name": "P. Berger", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "LYS", "country": "FR", "property_id": "P-130", "hotel": "Comfort Hotel Lyon", "chain": "Choice", "contract_id": "C-130", "allotment_id": "A-130", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-06T04:00:00Z", "checkin_time": "16:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-07T15:15:00Z", "duty_start_utc": "2026-08-07T09:15:00Z", "transfer_minutes": 10, "room_net": 246.85, "vat_rate": 10, "vat_amount": 24.69, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 274.84, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 274.84, "fx_rate": 1, "fx_date": "2026-08-07", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 256.27, "markup": 18.57, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854901", "vcc_auth_amount": 299.84, "folio_amount": 274.84, "settled_amount": 274.84, "settled_at": "2026-08-07T23:59:00Z", "contracted_rate": 274.84, "baseline_rate": 347.1, "market_rate": 336.69, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "CDG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 259.54, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-07T21:05:00Z", "exception_resolved_at": "2026-08-07T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-06", "ingested_at": "2026-08-07T02:14:00Z", "version": 1, "public_rate": 347.1, "discount_pct": 20.82 }, { "id": "RS-8854931-1", "period": "2026-08", "night": "2026-08-07", "booking_id": "RS-8854931", "duty_id": "D-514931", "layover_id": "L-514932", "crew_id": "FRA-1069", "crew_name": "Y. Perrin", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "MAD", "country": "ES", "property_id": "P-136", "hotel": "Novotel Madrid Barajas", "chain": "Accor", "contract_id": "C-136", "allotment_id": "A-136", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-06T17:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-07T04:42:00Z", "duty_start_utc": "2026-08-07T11:50:00Z", "transfer_minutes": 23, "room_net": 248.9, "vat_rate": 10, "vat_amount": 24.89, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 273.79, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 273.79, "fx_rate": 1, "fx_date": "2026-08-07", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 254.36, "markup": 19.43, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854931", "vcc_auth_amount": 298.79, "folio_amount": 273.79, "settled_amount": 273.79, "settled_at": "2026-08-07T23:59:00Z", "contracted_rate": 273.79, "baseline_rate": 372.97, "market_rate": 361.78, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 210.67, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-07T17:22:00Z", "exception_resolved_at": "2026-08-07T22:30:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-07", "ingested_at": "2026-08-07T02:14:00Z", "version": 1, "public_rate": 372.97, "discount_pct": 26.59 }, { "id": "RS-8853690-1", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8853690", "duty_id": "D-513690", "layover_id": "L-513691", "crew_id": "IRE-1031", "crew_name": "N. Mulligan", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "STN", "country": "GB", "property_id": "P-116", "hotel": "Hampton by Hilton Stansted", "chain": "Hilton", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-06T03:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-06T14:07:00Z", "duty_start_utc": "2026-08-06T09:15:00Z", "transfer_minutes": 18, "room_net": 327.74, "vat_rate": 20, "vat_amount": 65.55, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 393.29, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 330.31, "fx_rate": 1.190677, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 350.46, "markup": 42.83, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853690", "vcc_auth_amount": 418.29, "folio_amount": 393.29, "settled_amount": 393.29, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": null, "baseline_rate": 436.42, "market_rate": 423.33, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 239.94, "modify_attempted": 1, "modify_failed_reason": "rate_changed", "room_lost": 1, "exception_opened_at": "2026-08-06T06:12:00Z", "exception_resolved_at": "2026-08-06T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 4.1, "complaint_theme": null, "source_file_id": "AIMS-2026-08-06", "ingested_at": "2026-08-06T02:14:00Z", "version": 1, "public_rate": 436.42, "discount_pct": 9.88 }, { "id": "RS-8854082-1", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8854082", "duty_id": "D-514082", "layover_id": "L-514083", "crew_id": "BEL-1000", "crew_name": "T. Vermeulen", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-111", "hotel": "Ibis Liege Centre", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-05T17:40:00Z", "checkin_time": "05:40", "checkout_time": "08:15", "duty_end_utc": "2026-08-06T04:42:00Z", "duty_start_utc": "2026-08-06T14:05:00Z", "transfer_minutes": 23, "room_net": 327.36, "vat_rate": 6, "vat_amount": 19.64, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 351, "ancillaries": 13.05, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 351, "fx_rate": 1, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 323.45, "markup": 27.55, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854082", "vcc_auth_amount": 389.05, "folio_amount": 364.05, "settled_amount": 364.05, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": null, "baseline_rate": 404.13, "market_rate": 392.01, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 199.92, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-06T21:05:00Z", "exception_resolved_at": "2026-08-06T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-06", "ingested_at": "2026-08-06T02:14:00Z", "version": 1, "public_rate": 404.13, "discount_pct": 13.15 }, { "id": "RS-8854812-1", "period": "2026-08", "night": "2026-08-05", "booking_id": "RS-8854812", "duty_id": "D-514812", "layover_id": "L-514813", "crew_id": "FRA-1043", "crew_name": "V. Marchand", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "TLS", "country": "FR", "property_id": "P-134", "hotel": "Ibis Toulouse Blagnac", "chain": "Accor", "contract_id": "C-134", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-05T04:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-05T15:15:00Z", "duty_start_utc": "2026-08-05T11:50:00Z", "transfer_minutes": 10, "room_net": 240.55, "vat_rate": 10, "vat_amount": 24.06, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 267.49, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 267.49, "fx_rate": 1, "fx_date": "2026-08-05", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 246.85, "markup": 20.64, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854812", "vcc_auth_amount": 292.49, "folio_amount": null, "settled_amount": null, "settled_at": null, "contracted_rate": 267.49, "baseline_rate": 396.02, "market_rate": 384.14, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "CDG-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 206.87, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-05T06:12:00Z", "exception_resolved_at": "2026-08-05T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "awaiting_folio", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-05", "ingested_at": "2026-08-05T02:14:00Z", "version": 1, "public_rate": 396.02, "discount_pct": 32.46 }, { "id": "RS-8855035-1", "period": "2026-08", "night": "2026-08-05", "booking_id": "RS-8855035", "duty_id": "D-515035", "layover_id": "L-515036", "crew_id": "FRA-1002", "crew_name": "M. Bernard", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "CDG", "country": "FR", "property_id": "P-127", "hotel": "Pullman Paris CDG", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-05T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-05T13:11:00Z", "duty_start_utc": "2026-08-05T11:50:00Z", "transfer_minutes": 14, "room_net": 323.51, "vat_rate": 10, "vat_amount": 32.35, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 361.06, "ancillaries": 31.33, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 361.06, "fx_rate": 1, "fx_date": "2026-08-05", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 325.47, "markup": 35.59, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855035", "vcc_auth_amount": 417.39, "folio_amount": 392.39, "settled_amount": 392.39, "settled_at": "2026-08-05T23:59:00Z", "contracted_rate": null, "baseline_rate": 416.92, "market_rate": 404.41, "rate_honoured": 1, "customer": "UPS", "cost_centre": "MRS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 188.82, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-05T11:40:00Z", "exception_resolved_at": "2026-08-05T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-05", "ingested_at": "2026-08-05T02:14:00Z", "version": 1, "public_rate": 416.92, "discount_pct": 13.4 }, { "id": "RS-8853223-1", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8853223", "duty_id": "D-513223", "layover_id": "L-513224", "crew_id": "IRE-1035", "crew_name": "E. Devlin", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-03T17:40:00Z", "checkin_time": "05:40", "checkout_time": "08:15", "duty_end_utc": "2026-08-04T04:42:00Z", "duty_start_utc": "2026-08-04T14:05:00Z", "transfer_minutes": 23, "room_net": 234.42, "vat_rate": 13.5, "vat_amount": 31.65, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 266.07, "ancillaries": 17.75, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 266.07, "fx_rate": 1, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 266.07, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853223", "vcc_auth_amount": 308.82, "folio_amount": 283.82, "settled_amount": 283.82, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": 266.07, "baseline_rate": 378.14, "market_rate": 366.8, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 280.79, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-04T11:40:00Z", "exception_resolved_at": "2026-08-04T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.4, "complaint_theme": "transfer", "source_file_id": "AIMS-2026-08-04", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 378.14, "discount_pct": 29.64 }, { "id": "RS-8854036-1", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8854036", "duty_id": "D-514036", "layover_id": "L-514037", "crew_id": "BEL-1011", "crew_name": "T. Verhoeven", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "JNB", "country": "ZA", "property_id": "P-124", "hotel": "Protea OR Tambo", "chain": "Marriott", "contract_id": "C-124", "allotment_id": "A-124", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-04T02:00:00Z", "checkin_time": "14:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-04T12:39:00Z", "duty_start_utc": "2026-08-04T09:15:00Z", "transfer_minutes": 46, "room_net": 197.68, "vat_rate": 15, "vat_amount": 29.65, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 227.33, "ancillaries": 23.74, "fee": 15.97, "currency_local": "ZAR", "rate_paid_local": 4511.77, "fx_rate": 0.050386, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 227.33, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854036", "vcc_auth_amount": 276.07, "folio_amount": 251.07, "settled_amount": 251.07, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": 227.33, "baseline_rate": 328.38, "market_rate": 318.53, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 269.5, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-04T06:12:00Z", "exception_resolved_at": "2026-08-04T07:05:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-04", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 328.38, "discount_pct": 30.77 }, { "id": "RS-8855170-3", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8855170", "duty_id": "D-515170", "layover_id": "L-515171", "crew_id": "FRA-1067", "crew_name": "G. Marchand", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "LYS", "country": "FR", "property_id": "P-129", "hotel": "NH Lyon Airport", "chain": "NH", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-02T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-04T13:10:00Z", "duty_start_utc": "2026-08-04T06:30:00Z", "transfer_minutes": 15, "room_net": 317.88, "vat_rate": 10, "vat_amount": 31.79, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 352.97, "ancillaries": 12.04, "fee": 0, "currency_local": "EUR", "rate_paid_local": 352.97, "fx_rate": 1, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 352.97, "markup": 0, "commission_received": 36.15, "commission_shared": 18.07, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8855170", "vcc_auth_amount": 390.01, "folio_amount": 365.01, "settled_amount": 365.01, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": null, "baseline_rate": 382.01, "market_rate": 370.55, "rate_honoured": 1, "customer": "DHL", "cost_centre": "MRS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 185.01, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-04T06:12:00Z", "exception_resolved_at": "2026-08-04T12:55:00Z", "resolved_by": "human", "sla_breached": 1, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-02", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 382.01, "discount_pct": 7.6 }, { "id": "RS-8854836-3", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8854836", "duty_id": "D-514836", "layover_id": "L-514837", "crew_id": "FRA-1069", "crew_name": "Y. Perrin", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "TLS", "country": "FR", "property_id": "P-134", "hotel": "Ibis Toulouse Blagnac", "chain": "Accor", "contract_id": "C-134", "allotment_id": "A-134", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-07-31T13:15:00Z", "checkin_time": "01:15", "checkout_time": "04:30", "duty_end_utc": "2026-08-03T00:30:00Z", "duty_start_utc": "2026-08-03T11:50:00Z", "transfer_minutes": 10, "room_net": 242.88, "vat_rate": 10, "vat_amount": 24.29, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 270.05, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 270.05, "fx_rate": 1, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 270.05, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854836", "vcc_auth_amount": 295.05, "folio_amount": 270.05, "settled_amount": 270.05, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": 270.05, "baseline_rate": 362.12, "market_rate": 351.26, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 175.58, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-03T17:22:00Z", "exception_resolved_at": "2026-08-03T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-01", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 362.12, "discount_pct": 25.43 }, { "id": "RS-8855170-2", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8855170", "duty_id": "D-515170", "layover_id": "L-515171", "crew_id": "FRA-1067", "crew_name": "G. Marchand", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "LYS", "country": "FR", "property_id": "P-129", "hotel": "NH Lyon Airport", "chain": "NH", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-02T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-03T13:10:00Z", "duty_start_utc": "2026-08-03T09:15:00Z", "transfer_minutes": 15, "room_net": 291.07, "vat_rate": 10, "vat_amount": 29.11, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 323.48, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 323.48, "fx_rate": 1, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 323.48, "markup": 0, "commission_received": 33.13, "commission_shared": 16.56, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8855170", "vcc_auth_amount": 348.48, "folio_amount": 323.48, "settled_amount": 323.48, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": null, "baseline_rate": 350.09, "market_rate": 339.59, "rate_honoured": 1, "customer": "DHL", "cost_centre": "MRS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 246.44, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-03T11:40:00Z", "exception_resolved_at": "2026-08-03T18:40:00Z", "resolved_by": "human", "sla_breached": 1, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-02", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 350.09, "discount_pct": 7.6 }, { "id": "RS-8854451-1", "period": "2026-08", "night": "2026-08-02", "booking_id": "RS-8854451", "duty_id": "D-514451", "layover_id": "L-514452", "crew_id": "BEL-1038", "crew_name": "J. De Smet", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "HKG", "country": "HK", "property_id": "P-120", "hotel": "Regal Airport Hotel", "chain": "Regal", "contract_id": "C-120", "allotment_id": "A-120", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-01T13:15:00Z", "checkin_time": "01:15", "checkout_time": "04:30", "duty_end_utc": "2026-08-02T00:00:00Z", "duty_start_utc": "2026-08-02T06:30:00Z", "transfer_minutes": 56, "room_net": 296.22, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 296.22, "ancillaries": 0, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2471.47, "fx_rate": 0.119856, "fx_date": "2026-08-02", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 279.56, "markup": 16.66, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854451", "vcc_auth_amount": 321.22, "folio_amount": 296.22, "settled_amount": 296.22, "settled_at": "2026-08-02T23:59:00Z", "contracted_rate": 296.22, "baseline_rate": 369.25, "market_rate": 358.17, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 231.32, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-02T21:05:00Z", "exception_resolved_at": "2026-08-02T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-02", "ingested_at": "2026-08-02T02:14:00Z", "version": 1, "public_rate": 369.25, "discount_pct": 19.78 }, { "id": "RS-8853974-1", "period": "2026-08", "night": "2026-08-01", "booking_id": "RS-8853974", "duty_id": "D-513974", "layover_id": "L-513975", "crew_id": "BEL-1052", "crew_name": "E. Maes", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "DXB", "country": "AE", "property_id": "P-123", "hotel": "Le Meridien Dubai", "chain": "Marriott", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-01T10:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-01T21:07:00Z", "duty_start_utc": "2026-08-01T09:15:00Z", "transfer_minutes": 48, "room_net": 306.49, "vat_rate": 5, "vat_amount": 15.32, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 326.81, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1281.07, "fx_rate": 0.255107, "fx_date": "2026-08-01", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 297.85, "markup": 28.96, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853974", "vcc_auth_amount": 351.81, "folio_amount": 326.81, "settled_amount": 326.81, "settled_at": "2026-08-01T23:59:00Z", "contracted_rate": null, "baseline_rate": 358.17, "market_rate": 347.42, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 230.01, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-01T06:12:00Z", "exception_resolved_at": "2026-08-01T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 4.8, "complaint_theme": null, "source_file_id": "AIMS-2026-08-01", "ingested_at": "2026-08-01T02:14:00Z", "version": 1, "public_rate": 358.17, "discount_pct": 8.76 }, { "id": "RS-8854130-1", "period": "2026-08", "night": "2026-08-01", "booking_id": "RS-8854130", "duty_id": "D-514130", "layover_id": "L-514131", "crew_id": "BEL-1030", "crew_name": "P. Claes", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-07-31T13:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-01T00:18:00Z", "duty_start_utc": "2026-08-01T06:30:00Z", "transfer_minutes": 22, "room_net": 243.51, "vat_rate": 6, "vat_amount": 14.61, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 262.12, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 262.12, "fx_rate": 1, "fx_date": "2026-08-01", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 262.12, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854130", "vcc_auth_amount": 287.12, "folio_amount": 262.12, "settled_amount": 262.12, "settled_at": "2026-08-01T23:59:00Z", "contracted_rate": 262.12, "baseline_rate": 305.31, "market_rate": 296.15, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 220.08, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-01T11:40:00Z", "exception_resolved_at": "2026-08-01T12:55:00Z", "resolved_by": "human", "sla_breached": 1, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-01", "ingested_at": "2026-08-01T02:14:00Z", "version": 1, "public_rate": 305.31, "discount_pct": 14.15 } ] }