{ "metric": "no_show", "label": "No-show nights", "note": "A room paid for and not slept in.", "table": "room_night", "sort": null, "dir": "desc", "filters": {}, "total": 92, "sums": { "public_rate": 33935.93, "rate_paid": 26862.34 }, "rows": [ { "id": "RS-8853839-2", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8853839", "duty_id": "D-513839", "layover_id": "L-513840", "crew_id": "BEL-1088", "crew_name": "V. Maes", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "HKG", "country": "HK", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "chain": "Marriott", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-28T13:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-30T00:00:00Z", "duty_start_utc": "2026-08-30T14:05:00Z", "transfer_minutes": 44, "room_net": 340.7, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 340.7, "ancillaries": 19.5, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2862.83, "fx_rate": 0.119008, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 310.33, "markup": 30.37, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853839", "vcc_auth_amount": 385.2, "folio_amount": 340.7, "settled_amount": 340.7, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": null, "baseline_rate": 365.34, "market_rate": 354.38, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": "modify_in_place", "change_source": "travel_desk", "change_cost": 16.04, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 365.34, "discount_pct": 6.74 }, { "id": "RS-8855151-3", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8855151", "duty_id": "D-515151", "layover_id": "L-515152", "crew_id": "FRA-1026", "crew_name": "S. Bernard", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-28T21:00:00Z", "checkin_time": "22:30", "checkout_time": "08:15", "duty_end_utc": "2026-08-30T21:45:00Z", "duty_start_utc": "2026-08-30T11:50:00Z", "transfer_minutes": 10, "room_net": 263.1, "vat_rate": 10, "vat_amount": 26.31, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 292.29, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 292.29, "fx_rate": 1, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 263.65, "markup": 28.64, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855151", "vcc_auth_amount": 317.29, "folio_amount": 292.29, "settled_amount": 292.29, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": null, "baseline_rate": 330.62, "market_rate": 320.7, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "CDG-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 16.49, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 330.62, "discount_pct": 11.59 }, { "id": "RS-8853190-2", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8853190", "duty_id": "D-513190", "layover_id": "L-513191", "crew_id": "IRE-1008", "crew_name": "O. Healy", "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": "A-114", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "training", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-23T16:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-29T15:02:00Z", "duty_start_utc": "2026-08-29T06:30:00Z", "transfer_minutes": 23, "room_net": 231.84, "vat_rate": 20, "vat_amount": 46.37, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 278.21, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 234.37, "fx_rate": 1.187066, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 261.62, "markup": 16.59, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853190", "vcc_auth_amount": 303.21, "folio_amount": 278.21, "settled_amount": 278.21, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 278.21, "baseline_rate": 325.15, "market_rate": 315.4, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 325.15, "discount_pct": 14.44 }, { "id": "RS-8853319-1", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8853319", "duty_id": "D-513319", "layover_id": "L-513320", "crew_id": "IRE-1020", "crew_name": "R. Healy", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "CGN", "country": "DE", "property_id": "P-109", "hotel": "Novotel Koln City", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-28T21:00:00Z", "checkin_time": "22:30", "checkout_time": "08:15", "duty_end_utc": "2026-08-28T21:11:00Z", "duty_start_utc": "2026-08-28T09:15:00Z", "transfer_minutes": 44, "room_net": 272.07, "vat_rate": 7, "vat_amount": 19.04, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 296.11, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 296.11, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 296.11, "markup": 0, "commission_received": 29.97, "commission_shared": 14.98, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853319", "vcc_auth_amount": 321.11, "folio_amount": 296.11, "settled_amount": 296.11, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": null, "baseline_rate": 331.78, "market_rate": 321.83, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 12.05, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 331.78, "discount_pct": 10.75 }, { "id": "RS-8853648-1", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8853648", "duty_id": "D-513648", "layover_id": "L-513649", "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": "DUB", "country": "IE", "property_id": "P-101", "hotel": "Clayton Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-101", "allotment_id": "A-101", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-25T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-28T04:50:00Z", "duty_start_utc": "2026-08-28T09:15:00Z", "transfer_minutes": 15, "room_net": 211.39, "vat_rate": 13.5, "vat_amount": 28.54, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 239.93, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 239.93, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 225.56, "markup": 14.37, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853648", "vcc_auth_amount": 264.93, "folio_amount": 239.93, "settled_amount": 239.93, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": 239.93, "baseline_rate": 326.47, "market_rate": 316.68, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 326.47, "discount_pct": 26.51 }, { "id": "RS-8853756-1", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8853756", "duty_id": "D-513756", "layover_id": "L-513757", "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": "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": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-28T04:10:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-28T04:42:00Z", "duty_start_utc": "2026-08-28T11:50:00Z", "transfer_minutes": 23, "room_net": 254.59, "vat_rate": 6, "vat_amount": 15.28, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 273.87, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 273.87, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 252.94, "markup": 20.93, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853756", "vcc_auth_amount": 298.87, "folio_amount": 273.87, "settled_amount": 273.87, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": 273.87, "baseline_rate": 375.27, "market_rate": 364.01, "rate_honoured": 1, "customer": "UPS", "cost_centre": "DUB-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 12.23, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 375.27, "discount_pct": 27.02 }, { "id": "RS-8854674-1", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8854674", "duty_id": "D-514674", "layover_id": "L-514675", "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": "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": "standby", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-26T16:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-28T15:07:00Z", "duty_start_utc": "2026-08-28T06:30:00Z", "transfer_minutes": 18, "room_net": 244.13, "vat_rate": 10, "vat_amount": 24.41, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 271.84, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 271.84, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 254.61, "markup": 17.23, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854674", "vcc_auth_amount": 296.84, "folio_amount": 271.84, "settled_amount": 271.84, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": 271.84, "baseline_rate": 338.92, "market_rate": 328.75, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 338.92, "discount_pct": 19.79 }, { "id": "RS-8854688-2", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8854688", "duty_id": "D-514688", "layover_id": "L-514689", "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": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-26T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-28T04:50:00Z", "duty_start_utc": "2026-08-28T11:50:00Z", "transfer_minutes": 15, "room_net": 260.35, "vat_rate": 10, "vat_amount": 26.04, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 289.69, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 289.69, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 289.69, "markup": 0, "commission_received": 30.02, "commission_shared": 15.01, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854688", "vcc_auth_amount": 314.69, "folio_amount": 289.69, "settled_amount": 289.69, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": null, "baseline_rate": 345.02, "market_rate": 334.67, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-28T02:14:00Z", "version": 1, "public_rate": 345.02, "discount_pct": 16.04 }, { "id": "RS-8852827-2", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8852827", "duty_id": "D-512827", "layover_id": "L-512828", "crew_id": "IRE-1068", "crew_name": "G. Healy", "crew_rank": "CPT", "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": "no_show", "lead_time_days": 9, "booking_created_at": "2026-08-17T14:00:00Z", "checkin_time": "14:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-27T13:03:00Z", "duty_start_utc": "2026-08-27T09:15:00Z", "transfer_minutes": 22, "room_net": 265.43, "vat_rate": 20, "vat_amount": 53.09, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 318.52, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 268.77, "fx_rate": 1.185081, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 295.1, "markup": 23.42, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852827", "vcc_auth_amount": 343.52, "folio_amount": 318.52, "settled_amount": 318.52, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 318.52, "baseline_rate": 431.28, "market_rate": 418.34, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-27T02:14:00Z", "version": 1, "public_rate": 431.28, "discount_pct": 26.15 }, { "id": "RS-8853220-4", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8853220", "duty_id": "D-513220", "layover_id": "L-513221", "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": "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": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-21T15:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-27T14:03:00Z", "duty_start_utc": "2026-08-27T14:05:00Z", "transfer_minutes": 22, "room_net": 241.24, "vat_rate": 6, "vat_amount": 14.47, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 259.71, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 259.71, "fx_rate": 1, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 241.87, "markup": 17.84, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853220", "vcc_auth_amount": 284.71, "folio_amount": 259.71, "settled_amount": 259.71, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 259.71, "baseline_rate": 366.92, "market_rate": 355.91, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-27T02:14:00Z", "version": 1, "public_rate": 366.92, "discount_pct": 29.22 }, { "id": "RS-8854676-2", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8854676", "duty_id": "D-514676", "layover_id": "L-514677", "crew_id": "FRA-1064", "crew_name": "N. Lefevre", "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-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": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-25T16:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-27T15:03:00Z", "duty_start_utc": "2026-08-27T11:50:00Z", "transfer_minutes": 22, "room_net": 225.97, "vat_rate": 10, "vat_amount": 22.6, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 251.45, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 251.45, "fx_rate": 1, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 234.46, "markup": 16.99, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854676", "vcc_auth_amount": 276.45, "folio_amount": 251.45, "settled_amount": 251.45, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 251.45, "baseline_rate": 340.94, "market_rate": 330.71, "rate_honoured": 1, "customer": "UPS", "cost_centre": "LYS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-27T02:14:00Z", "version": 1, "public_rate": 340.94, "discount_pct": 26.25 }, { "id": "RS-8854688-1", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8854688", "duty_id": "D-514688", "layover_id": "L-514689", "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": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-26T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-27T04:50:00Z", "duty_start_utc": "2026-08-27T06:30:00Z", "transfer_minutes": 15, "room_net": 278.07, "vat_rate": 10, "vat_amount": 27.81, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 309.18, "ancillaries": 12.11, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 309.18, "fx_rate": 1, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 309.18, "markup": 0, "commission_received": 32.04, "commission_shared": 16.02, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854688", "vcc_auth_amount": 346.29, "folio_amount": 309.18, "settled_amount": 309.18, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": null, "baseline_rate": 368.23, "market_rate": 357.18, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 368.23, "discount_pct": 16.04 }, { "id": "RS-8855027-2", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8855027", "duty_id": "D-515027", "layover_id": "L-515028", "crew_id": "FRA-1016", "crew_name": "O. Lefevre", "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-129", "hotel": "NH Lyon Airport", "chain": "NH", "contract_id": "C-129", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-08-17T01:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-27T00:25:00Z", "duty_start_utc": "2026-08-27T11:50:00Z", "transfer_minutes": 15, "room_net": 240.36, "vat_rate": 10, "vat_amount": 24.04, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 267.7, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 267.7, "fx_rate": 1, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 267.7, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855027", "vcc_auth_amount": 292.7, "folio_amount": 267.7, "settled_amount": 267.7, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 267.7, "baseline_rate": 368.23, "market_rate": 357.18, "rate_honoured": 1, "customer": "DHL", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-27T02:14:00Z", "version": 1, "public_rate": 368.23, "discount_pct": 27.3 }, { "id": "RS-8854762-3", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8854762", "duty_id": "D-514762", "layover_id": "L-514763", "crew_id": "FRA-1083", "crew_name": "E. Berger", "crew_rank": "CC", "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": "A-134", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-24T02:00:00Z", "checkin_time": "14:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-26T13:15:00Z", "duty_start_utc": "2026-08-26T14:05:00Z", "transfer_minutes": 10, "room_net": 327.29, "vat_rate": 10, "vat_amount": 32.73, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 362.9, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 362.9, "fx_rate": 1, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 346.25, "markup": 16.65, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854762", "vcc_auth_amount": 292.41, "folio_amount": 362.9, "settled_amount": 362.9, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": 267.41, "baseline_rate": 385.3, "market_rate": 373.74, "rate_honoured": 0, "customer": "DHL", "cost_centre": "CDG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-26T02:14:00Z", "version": 1, "public_rate": 385.3, "discount_pct": 5.81 }, { "id": "RS-8855139-1", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8855139", "duty_id": "D-515139", "layover_id": "L-515140", "crew_id": "FRA-1000", "crew_name": "V. Moreau", "crew_rank": "ENG", "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": "C-135", "allotment_id": "A-135", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-21T15:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-26T14:11:00Z", "duty_start_utc": "2026-08-26T11:50:00Z", "transfer_minutes": 14, "room_net": 267.1, "vat_rate": 10, "vat_amount": 26.71, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 293.81, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 293.81, "fx_rate": 1, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 277.2, "markup": 16.61, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855139", "vcc_auth_amount": 318.81, "folio_amount": 293.81, "settled_amount": 293.81, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": 293.81, "baseline_rate": 414.04, "market_rate": 401.62, "rate_honoured": 1, "customer": "DHL", "cost_centre": "CDG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-26T02:14:00Z", "version": 1, "public_rate": 414.04, "discount_pct": 29.04 }, { "id": "RS-8853347-1", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8853347", "duty_id": "D-513347", "layover_id": "L-513348", "crew_id": "IRE-1068", "crew_name": "G. Healy", "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": "A-105", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-23T14:00:00Z", "checkin_time": "14:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-25T13:14:00Z", "duty_start_utc": "2026-08-25T11:50:00Z", "transfer_minutes": 11, "room_net": 248.53, "vat_rate": 20, "vat_amount": 49.7, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 298.23, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 250.97, "fx_rate": 1.188294, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 298.23, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853347", "vcc_auth_amount": 323.23, "folio_amount": 298.23, "settled_amount": 298.23, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 298.23, "baseline_rate": 418.2, "market_rate": 405.65, "rate_honoured": 1, "customer": "UPS", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 418.2, "discount_pct": 28.69 }, { "id": "RS-8853653-1", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8853653", "duty_id": "D-513653", "layover_id": "L-513654", "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": "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": "overnight", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-24T16:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-25T15:15:00Z", "duty_start_utc": "2026-08-25T14:05:00Z", "transfer_minutes": 10, "room_net": 233.5, "vat_rate": 7, "vat_amount": 16.35, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 254.85, "ancillaries": 25.86, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 254.85, "fx_rate": 1, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 254.85, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853653", "vcc_auth_amount": 305.71, "folio_amount": 254.85, "settled_amount": 254.85, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 254.85, "baseline_rate": 362.69, "market_rate": 351.81, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 362.69, "discount_pct": 29.73 }, { "id": "RS-8854330-2", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8854330", "duty_id": "D-514330", "layover_id": "L-514331", "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": "C-111", "allotment_id": "A-111", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-19T22:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-25T21:32:00Z", "duty_start_utc": "2026-08-25T11:50:00Z", "transfer_minutes": 23, "room_net": 355.19, "vat_rate": 6, "vat_amount": 21.31, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 380.5, "ancillaries": 23.19, "fee": 0, "currency_local": "EUR", "rate_paid_local": 380.5, "fx_rate": 1, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 380.5, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854330", "vcc_auth_amount": 322.95, "folio_amount": 403.69, "settled_amount": 403.69, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 274.76, "baseline_rate": 396.26, "market_rate": 384.37, "rate_honoured": 0, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-25T02:14:00Z", "version": 1, "public_rate": 396.26, "discount_pct": 3.98 }, { "id": "RS-8854353-3", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8854353", "duty_id": "D-514353", "layover_id": "L-514354", "crew_id": "BEL-1047", "crew_name": "Y. Verhoeven", "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": "gds", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-18T05:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-25T04:42:00Z", "duty_start_utc": "2026-08-25T11:50:00Z", "transfer_minutes": 23, "room_net": 307.96, "vat_rate": 6, "vat_amount": 18.48, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 330.44, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 330.44, "fx_rate": 1, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 330.44, "markup": 0, "commission_received": 32.16, "commission_shared": 16.08, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854353", "vcc_auth_amount": 355.44, "folio_amount": 330.44, "settled_amount": 330.44, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": null, "baseline_rate": 396.26, "market_rate": 384.37, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 396.26, "discount_pct": 16.61 }, { "id": "RS-8855081-3", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8855081", "duty_id": "D-515081", "layover_id": "L-515082", "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": "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": "irops", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-22T22:30:00Z", "checkin_time": "22:30", "checkout_time": "08:15", "duty_end_utc": "2026-08-25T21:41:00Z", "duty_start_utc": "2026-08-25T14:05:00Z", "transfer_minutes": 14, "room_net": 263.75, "vat_rate": 10, "vat_amount": 26.38, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 295.33, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 295.33, "fx_rate": 1, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 295.33, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855081", "vcc_auth_amount": 320.33, "folio_amount": 295.33, "settled_amount": 295.33, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 295.33, "baseline_rate": 416.6, "market_rate": 404.1, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "LYS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 416.6, "discount_pct": 29.11 }, { "id": "RS-8852985-1", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8852985", "duty_id": "D-512985", "layover_id": "L-512986", "crew_id": "IRE-1044", "crew_name": "E. Healy", "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-105", "hotel": "Holiday Inn Castle Donington", "chain": "IHG", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-24T14:30:00Z", "checkin_time": "16:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-24T15:14:00Z", "duty_start_utc": "2026-08-24T09:15:00Z", "transfer_minutes": 11, "room_net": 301.62, "vat_rate": 20, "vat_amount": 60.32, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 361.94, "ancillaries": 10.89, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 304.64, "fx_rate": 1.188078, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 361.94, "markup": 0, "commission_received": 26.18, "commission_shared": 13.09, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8852985", "vcc_auth_amount": 397.83, "folio_amount": 361.94, "settled_amount": 361.94, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": null, "baseline_rate": 399.55, "market_rate": 387.56, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "DUB-CREW", "change_type": "modify_in_place", "change_source": "crew_app", "change_cost": 14.44, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 399.55, "discount_pct": 9.41 }, { "id": "RS-8854175-1", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8854175", "duty_id": "D-514175", "layover_id": "L-514176", "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": "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": "overnight", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-08-15T14:00:00Z", "checkin_time": "14:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-24T13:02:00Z", "duty_start_utc": "2026-08-24T11:50:00Z", "transfer_minutes": 23, "room_net": 254.58, "vat_rate": 6, "vat_amount": 15.28, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 273.86, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 273.86, "fx_rate": 1, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 273.86, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854175", "vcc_auth_amount": 298.86, "folio_amount": 273.86, "settled_amount": 273.86, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": 273.86, "baseline_rate": 378.56, "market_rate": 367.2, "rate_honoured": 1, "customer": "UPS", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 378.56, "discount_pct": 27.66 }, { "id": "RS-8853562-2", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8853562", "duty_id": "D-513562", "layover_id": "L-513563", "crew_id": "IRE-1069", "crew_name": "N. Quinn", "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-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": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-21T16:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-23T15:09:00Z", "duty_start_utc": "2026-08-23T06:30:00Z", "transfer_minutes": 16, "room_net": 249.7, "vat_rate": 7, "vat_amount": 17.48, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 272.18, "ancillaries": 8.64, "fee": 0, "currency_local": "EUR", "rate_paid_local": 272.18, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 272.18, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853562", "vcc_auth_amount": 305.82, "folio_amount": 272.18, "settled_amount": 272.18, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": 272.18, "baseline_rate": 327.06, "market_rate": 317.25, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-23T02:14:00Z", "version": 1, "public_rate": 327.06, "discount_pct": 16.78 }, { "id": "RS-8854506-4", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8854506", "duty_id": "D-514506", "layover_id": "L-514507", "crew_id": "BEL-1075", "crew_name": "A. Peeters", "crew_rank": "CPT", "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": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-20T04:10:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-23T04:51:00Z", "duty_start_utc": "2026-08-23T09:15:00Z", "transfer_minutes": 14, "room_net": 261.42, "vat_rate": 10, "vat_amount": 26.14, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 292.76, "ancillaries": 33.61, "fee": 0, "currency_local": "EUR", "rate_paid_local": 292.76, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 270.39, "markup": 22.37, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854506", "vcc_auth_amount": 351.37, "folio_amount": 292.76, "settled_amount": 292.76, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": 292.76, "baseline_rate": 349.67, "market_rate": 339.18, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 13.01, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 349.67, "discount_pct": 16.28 }, { "id": "RS-8854613-1", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8854613", "duty_id": "D-514613", "layover_id": "L-514614", "crew_id": "BEL-1019", "crew_name": "H. Wouters", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "BRU", "country": "BE", "property_id": "P-118", "hotel": "NH Brussels Airport", "chain": "NH", "contract_id": "C-118", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-18T22:30:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-23T21:42:00Z", "duty_start_utc": "2026-08-23T14:05:00Z", "transfer_minutes": 13, "room_net": 307.12, "vat_rate": 6, "vat_amount": 18.43, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4.24, "rate_paid": 329.79, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 329.79, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 329.79, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854613", "vcc_auth_amount": 354.79, "folio_amount": 329.79, "settled_amount": 329.79, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": 329.79, "baseline_rate": 399.67, "market_rate": 387.68, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 399.67, "discount_pct": 17.48 }, { "id": "RS-8854888-1", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8854888", "duty_id": "D-514888", "layover_id": "L-514889", "crew_id": "FRA-1009", "crew_name": "K. Perrin", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "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": "positioning", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-21T16:00:00Z", "checkin_time": "16:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-23T15:11:00Z", "duty_start_utc": "2026-08-23T14:05:00Z", "transfer_minutes": 14, "room_net": 263.77, "vat_rate": 10, "vat_amount": 26.38, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 295.35, "ancillaries": 10.25, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 295.35, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 274.54, "markup": 20.81, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854888", "vcc_auth_amount": 330.6, "folio_amount": 295.35, "settled_amount": 295.35, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": 295.35, "baseline_rate": 354.92, "market_rate": 344.27, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 354.92, "discount_pct": 16.78 }, { "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-8853594-3", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8853594", "duty_id": "D-513594", "layover_id": "L-513595", "crew_id": "IRE-1022", "crew_name": "L. Cassidy", "crew_rank": "FO", "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": "A-105", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-16T05:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-21T04:54:00Z", "duty_start_utc": "2026-08-21T11:50:00Z", "transfer_minutes": 11, "room_net": 245.63, "vat_rate": 20, "vat_amount": 49.12, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 294.75, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 248.34, "fx_rate": 1.186893, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 276.63, "markup": 18.12, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853594", "vcc_auth_amount": 319.75, "folio_amount": 294.75, "settled_amount": 294.75, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 294.75, "baseline_rate": 383.16, "market_rate": 371.67, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-19", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 383.16, "discount_pct": 23.07 }, { "id": "RS-8854083-3", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8854083", "duty_id": "D-514083", "layover_id": "L-514084", "crew_id": "BEL-1044", "crew_name": "R. Dubois", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "BRU", "country": "BE", "property_id": "P-118", "hotel": "NH Brussels Airport", "chain": "NH", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-14T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-21T04:52:00Z", "duty_start_utc": "2026-08-21T11:50:00Z", "transfer_minutes": 13, "room_net": 315.6, "vat_rate": 6, "vat_amount": 18.94, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4.24, "rate_paid": 338.78, "ancillaries": 25.16, "fee": 0, "currency_local": "EUR", "rate_paid_local": 338.78, "fx_rate": 1, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 306.69, "markup": 32.09, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854083", "vcc_auth_amount": 388.94, "folio_amount": 338.78, "settled_amount": 338.78, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": null, "baseline_rate": 428.98, "market_rate": 416.11, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-19", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 428.98, "discount_pct": 21.03 }, { "id": "RS-8854389-3", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8854389", "duty_id": "D-514389", "layover_id": "L-514390", "crew_id": "BEL-1006", "crew_name": "D. Claes", "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-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": "standby", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-14T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-21T04:43:00Z", "duty_start_utc": "2026-08-21T14:05:00Z", "transfer_minutes": 22, "room_net": 240.75, "vat_rate": 6, "vat_amount": 14.45, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 259.2, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 259.2, "fx_rate": 1, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 240.79, "markup": 18.41, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854389", "vcc_auth_amount": 284.2, "folio_amount": 259.2, "settled_amount": 259.2, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 259.2, "baseline_rate": 343.43, "market_rate": 333.13, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 4.4, "complaint_theme": null, "source_file_id": "AIMS-2026-08-19", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 343.43, "discount_pct": 24.53 }, { "id": "RS-8854786-2", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8854786", "duty_id": "D-514786", "layover_id": "L-514787", "crew_id": "FRA-1064", "crew_name": "N. Lefevre", "crew_rank": "FO", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-17T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-21T14:11:00Z", "duty_start_utc": "2026-08-21T09:15:00Z", "transfer_minutes": 14, "room_net": 263.49, "vat_rate": 10, "vat_amount": 26.35, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 295.04, "ancillaries": 28.37, "fee": 0, "currency_local": "EUR", "rate_paid_local": 295.04, "fx_rate": 1, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 278.47, "markup": 16.57, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854786", "vcc_auth_amount": 348.41, "folio_amount": 295.04, "settled_amount": 295.04, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 295.04, "baseline_rate": 383.22, "market_rate": 371.72, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 383.22, "discount_pct": 23.01 }, { "id": "RS-8854802-1", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8854802", "duty_id": "D-514802", "layover_id": "L-514803", "crew_id": "FRA-S215", "crew_name": "V. Chevalier", "crew_rank": "STAFF", "traveller_type": "staff", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-16T05:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-21T04:51:00Z", "duty_start_utc": "2026-08-21T11:50:00Z", "transfer_minutes": 14, "room_net": 264.47, "vat_rate": 10, "vat_amount": 26.45, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 290.92, "ancillaries": 16.6, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 290.92, "fx_rate": 1, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 275.58, "markup": 15.34, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854802", "vcc_auth_amount": 332.52, "folio_amount": 290.92, "settled_amount": 290.92, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 290.92, "baseline_rate": 381.02, "market_rate": 369.59, "rate_honoured": 1, "customer": "UPS", "cost_centre": "LYS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 4.5, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 381.02, "discount_pct": 23.65 }, { "id": "RS-8855189-2", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8855189", "duty_id": "D-515189", "layover_id": "L-515190", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "positioning", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-18T05:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-21T04:47:00Z", "duty_start_utc": "2026-08-21T09:15:00Z", "transfer_minutes": 18, "room_net": 258.99, "vat_rate": 10, "vat_amount": 25.9, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 288.19, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 288.19, "fx_rate": 1, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 288.19, "markup": 0, "commission_received": 26.87, "commission_shared": 13.43, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8855189", "vcc_auth_amount": 313.19, "folio_amount": null, "settled_amount": null, "settled_at": null, "contracted_rate": null, "baseline_rate": 344.84, "market_rate": 334.49, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "awaiting_folio", "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": 344.84, "discount_pct": 16.43 }, { "id": "RS-8853091-3", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8853091", "duty_id": "D-513091", "layover_id": "L-513092", "crew_id": "IRE-1060", "crew_name": "O. Byrne", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-16T16:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-20T15:03:00Z", "duty_start_utc": "2026-08-20T14:05:00Z", "transfer_minutes": 22, "room_net": 243.3, "vat_rate": 6, "vat_amount": 14.6, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 261.9, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 261.9, "fx_rate": 1, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 241.46, "markup": 20.44, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853091", "vcc_auth_amount": 286.9, "folio_amount": 261.9, "settled_amount": 261.9, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": 261.9, "baseline_rate": 379.35, "market_rate": 367.97, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-20T02:14:00Z", "version": 1, "public_rate": 379.35, "discount_pct": 30.96 }, { "id": "RS-8853907-1", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8853907", "duty_id": "D-513907", "layover_id": "L-513908", "crew_id": "BEL-1086", "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": "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": "gds", "duty_reason": "irops", "night_status": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-19T17:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-20T04:17:00Z", "duty_start_utc": "2026-08-20T14:05:00Z", "transfer_minutes": 48, "room_net": 349.94, "vat_rate": 5, "vat_amount": 17.5, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 372.44, "ancillaries": 35.88, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1452.77, "fx_rate": 0.256366, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 372.44, "markup": 0, "commission_received": 27.56, "commission_shared": 13.78, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853907", "vcc_auth_amount": 433.32, "folio_amount": 372.44, "settled_amount": 372.44, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": null, "baseline_rate": 418.48, "market_rate": 405.93, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-20T02:14:00Z", "version": 1, "public_rate": 418.48, "discount_pct": 11 }, { "id": "RS-8854318-3", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8854318", "duty_id": "D-514318", "layover_id": "L-514319", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-08-09T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-20T13:41:00Z", "duty_start_utc": "2026-08-20T06:30:00Z", "transfer_minutes": 44, "room_net": 207.01, "vat_rate": 15, "vat_amount": 31.05, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 238.06, "ancillaries": 0, "fee": 0, "currency_local": "ZAR", "rate_paid_local": 4744.22, "fx_rate": 0.050179, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 220.96, "markup": 17.1, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854318", "vcc_auth_amount": 263.06, "folio_amount": 238.06, "settled_amount": 238.06, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": 238.06, "baseline_rate": 339.9, "market_rate": 329.7, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-20T02:14:00Z", "version": 1, "public_rate": 339.9, "discount_pct": 29.96 }, { "id": "RS-8854627-2", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8854627", "duty_id": "D-514627", "layover_id": "L-514628", "crew_id": "BEL-1049", "crew_name": "K. Janssens", "crew_rank": "CPT", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "training", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-16T16:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-20T14:41:00Z", "duty_start_utc": "2026-08-20T09:15:00Z", "transfer_minutes": 44, "room_net": 241.34, "vat_rate": 15, "vat_amount": 36.2, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 277.54, "ancillaries": 34.29, "fee": 0, "currency_local": "ZAR", "rate_paid_local": 5531, "fx_rate": 0.050179, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 249.51, "markup": 28.03, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854627", "vcc_auth_amount": 336.83, "folio_amount": 277.54, "settled_amount": 277.54, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": null, "baseline_rate": 339.9, "market_rate": 329.7, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-19", "ingested_at": "2026-08-20T02:14:00Z", "version": 1, "public_rate": 339.9, "discount_pct": 18.35 }, { "id": "RS-8854786-1", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8854786", "duty_id": "D-514786", "layover_id": "L-514787", "crew_id": "FRA-1064", "crew_name": "N. Lefevre", "crew_rank": "FO", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-17T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-20T14:11:00Z", "duty_start_utc": "2026-08-20T06:30:00Z", "transfer_minutes": 14, "room_net": 263.49, "vat_rate": 10, "vat_amount": 26.35, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 295.04, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 295.04, "fx_rate": 1, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 278.47, "markup": 16.57, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854786", "vcc_auth_amount": 320.04, "folio_amount": 295.04, "settled_amount": 295.04, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": 295.04, "baseline_rate": 416.8, "market_rate": 404.3, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-20T02:14:00Z", "version": 1, "public_rate": 416.8, "discount_pct": 29.21 }, { "id": "RS-8853143-2", "period": "2026-08", "night": "2026-08-19", "booking_id": "RS-8853143", "duty_id": "D-513143", "layover_id": "L-513144", "crew_id": "IRE-1053", "crew_name": "T. Fitzgerald", "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": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-17T22:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-19T21:39:00Z", "duty_start_utc": "2026-08-19T14:05:00Z", "transfer_minutes": 16, "room_net": 247.29, "vat_rate": 7, "vat_amount": 17.31, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 269.6, "ancillaries": 34.97, "fee": 0, "currency_local": "EUR", "rate_paid_local": 269.6, "fx_rate": 1, "fx_date": "2026-08-19", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 269.6, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853143", "vcc_auth_amount": 329.57, "folio_amount": 269.6, "settled_amount": 269.6, "settled_at": "2026-08-19T23:59:00Z", "contracted_rate": 269.6, "baseline_rate": 384.83, "market_rate": 373.29, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 3.2, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-19T02:14:00Z", "version": 1, "public_rate": 384.83, "discount_pct": 29.94 }, { "id": "RS-8854065-1", "period": "2026-08", "night": "2026-08-19", "booking_id": "RS-8854065", "duty_id": "D-514065", "layover_id": "L-514066", "crew_id": "BEL-1015", "crew_name": "P. Peeters", "crew_rank": "FO", "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": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-18T13:15:00Z", "checkin_time": "01:15", "checkout_time": "10:00", "duty_end_utc": "2026-08-19T00:00:00Z", "duty_start_utc": "2026-08-19T14:05:00Z", "transfer_minutes": 56, "room_net": 297.98, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 297.98, "ancillaries": 0, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2482.42, "fx_rate": 0.120036, "fx_date": "2026-08-19", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 279.27, "markup": 18.71, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854065", "vcc_auth_amount": 322.98, "folio_amount": 297.98, "settled_amount": 297.98, "settled_at": "2026-08-19T23:59:00Z", "contracted_rate": 297.98, "baseline_rate": 445.85, "market_rate": 432.47, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 14.32, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-19", "ingested_at": "2026-08-19T02:14:00Z", "version": 1, "public_rate": 445.85, "discount_pct": 33.17 }, { "id": "RS-8854454-1", "period": "2026-08", "night": "2026-08-19", "booking_id": "RS-8854454", "duty_id": "D-514454", "layover_id": "L-514455", "crew_id": "BEL-1071", "crew_name": "P. Verhoeven", "crew_rank": "FO", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-16T05:40:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-19T04:21:00Z", "duty_start_utc": "2026-08-19T11:50:00Z", "transfer_minutes": 44, "room_net": 357.83, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 357.83, "ancillaries": 13.46, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2981.02, "fx_rate": 0.120036, "fx_date": "2026-08-19", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 320.71, "markup": 37.12, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854454", "vcc_auth_amount": 396.29, "folio_amount": 357.83, "settled_amount": 357.83, "settled_at": "2026-08-19T23:59:00Z", "contracted_rate": null, "baseline_rate": 445.34, "market_rate": 431.98, "rate_honoured": 1, "customer": "UPS", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-19", "ingested_at": "2026-08-19T02:14:00Z", "version": 1, "public_rate": 445.34, "discount_pct": 19.65 }, { "id": "RS-8854773-2", "period": "2026-08", "night": "2026-08-19", "booking_id": "RS-8854773", "duty_id": "D-514773", "layover_id": "L-514774", "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": "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": "overnight", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-08-09T01:15:00Z", "checkin_time": "01:15", "checkout_time": "08:15", "duty_end_utc": "2026-08-19T00:22:00Z", "duty_start_utc": "2026-08-19T09:15:00Z", "transfer_minutes": 18, "room_net": 243.08, "vat_rate": 10, "vat_amount": 24.31, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 270.69, "ancillaries": 19.86, "fee": 0, "currency_local": "EUR", "rate_paid_local": 270.69, "fx_rate": 1, "fx_date": "2026-08-19", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 270.69, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854773", "vcc_auth_amount": 315.55, "folio_amount": 270.69, "settled_amount": 270.69, "settled_at": "2026-08-19T23:59:00Z", "contracted_rate": 270.69, "baseline_rate": 377.58, "market_rate": 366.25, "rate_honoured": 1, "customer": "UPS", "cost_centre": "CDG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-19T02:14:00Z", "version": 1, "public_rate": 377.58, "discount_pct": 28.31 }, { "id": "RS-8853817-2", "period": "2026-08", "night": "2026-08-18", "booking_id": "RS-8853817", "duty_id": "D-513817", "layover_id": "L-513818", "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": "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": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-17T04:10:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-18T04:42:00Z", "duty_start_utc": "2026-08-18T06:30:00Z", "transfer_minutes": 23, "room_net": 258.38, "vat_rate": 6, "vat_amount": 15.5, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 277.88, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 277.88, "fx_rate": 1, "fx_date": "2026-08-18", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 257.16, "markup": 20.72, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853817", "vcc_auth_amount": 302.88, "folio_amount": 277.88, "settled_amount": 277.88, "settled_at": "2026-08-18T23:59:00Z", "contracted_rate": 277.88, "baseline_rate": 411.52, "market_rate": 399.17, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 18.57, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 411.52, "discount_pct": 32.47 }, { "id": "RS-8854773-1", "period": "2026-08", "night": "2026-08-18", "booking_id": "RS-8854773", "duty_id": "D-514773", "layover_id": "L-514774", "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": "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": "overnight", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-08-09T01:15:00Z", "checkin_time": "01:15", "checkout_time": "08:15", "duty_end_utc": "2026-08-18T00:22:00Z", "duty_start_utc": "2026-08-18T06:30:00Z", "transfer_minutes": 18, "room_net": 243.08, "vat_rate": 10, "vat_amount": 24.31, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 270.69, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 270.69, "fx_rate": 1, "fx_date": "2026-08-18", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 270.69, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854773", "vcc_auth_amount": 295.69, "folio_amount": 270.69, "settled_amount": 270.69, "settled_at": "2026-08-18T23:59:00Z", "contracted_rate": 270.69, "baseline_rate": 364.97, "market_rate": 354.02, "rate_honoured": 1, "customer": "UPS", "cost_centre": "CDG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-18T02:14:00Z", "version": 1, "public_rate": 364.97, "discount_pct": 25.83 }, { "id": "RS-8853269-2", "period": "2026-08", "night": "2026-08-17", "booking_id": "RS-8853269", "duty_id": "D-513269", "layover_id": "L-513270", "crew_id": "IRE-1000", "crew_name": "D. Byrne", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "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": "overnight", "night_status": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-16T04:00:00Z", "checkin_time": "16:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-17T15:02:00Z", "duty_start_utc": "2026-08-17T14:05:00Z", "transfer_minutes": 23, "room_net": 342.67, "vat_rate": 6, "vat_amount": 20.56, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 367.23, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 367.23, "fx_rate": 1, "fx_date": "2026-08-17", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 367.23, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853269", "vcc_auth_amount": 298.93, "folio_amount": 367.23, "settled_amount": 367.23, "settled_at": "2026-08-17T23:59:00Z", "contracted_rate": 273.93, "baseline_rate": 387.75, "market_rate": 376.12, "rate_honoured": 0, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 387.75, "discount_pct": 5.29 }, { "id": "RS-8853365-2", "period": "2026-08", "night": "2026-08-17", "booking_id": "RS-8853365", "duty_id": "D-513365", "layover_id": "L-513366", "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": "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": "irops", "night_status": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-16T02:00:00Z", "checkin_time": "14:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-17T13:02:00Z", "duty_start_utc": "2026-08-17T14:05:00Z", "transfer_minutes": 23, "room_net": 255.48, "vat_rate": 6, "vat_amount": 15.33, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 274.81, "ancillaries": 26.12, "fee": 0, "currency_local": "EUR", "rate_paid_local": 274.81, "fx_rate": 1, "fx_date": "2026-08-17", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 253.29, "markup": 21.52, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853365", "vcc_auth_amount": 325.93, "folio_amount": 274.81, "settled_amount": 274.81, "settled_at": "2026-08-17T23:59:00Z", "contracted_rate": 274.81, "baseline_rate": 387.75, "market_rate": 376.12, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 387.75, "discount_pct": 29.13 }, { "id": "RS-8853555-2", "period": "2026-08", "night": "2026-08-17", "booking_id": "RS-8853555", "duty_id": "D-513555", "layover_id": "L-513556", "crew_id": "IRE-1044", "crew_name": "E. Healy", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "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": "gds", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-13T05:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-17T04:47:00Z", "duty_start_utc": "2026-08-17T14:05:00Z", "transfer_minutes": 18, "room_net": 293.82, "vat_rate": 20, "vat_amount": 58.76, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 352.58, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 297.58, "fx_rate": 1.184843, "fx_date": "2026-08-17", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 352.58, "markup": 0, "commission_received": 33.95, "commission_shared": 16.97, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853555", "vcc_auth_amount": 377.58, "folio_amount": 352.58, "settled_amount": 352.58, "settled_at": "2026-08-17T23:59:00Z", "contracted_rate": null, "baseline_rate": 422.12, "market_rate": 409.46, "rate_honoured": 1, "customer": "UPS", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 422.12, "discount_pct": 16.47 }, { "id": "RS-8853388-3", "period": "2026-08", "night": "2026-08-15", "booking_id": "RS-8853388", "duty_id": "D-513388", "layover_id": "L-513389", "crew_id": "IRE-1063", "crew_name": "S. Kavanagh", "crew_rank": "ENG", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-11T16:00:00Z", "checkin_time": "16:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-15T15:02:00Z", "duty_start_utc": "2026-08-15T11:50:00Z", "transfer_minutes": 23, "room_net": 224.09, "vat_rate": 13.5, "vat_amount": 30.25, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 254.34, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 254.34, "fx_rate": 1, "fx_date": "2026-08-15", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 230.71, "markup": 23.63, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853388", "vcc_auth_amount": 279.34, "folio_amount": 254.34, "settled_amount": 254.34, "settled_at": "2026-08-15T23:59:00Z", "contracted_rate": null, "baseline_rate": 309.7, "market_rate": 300.41, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 4.8, "complaint_theme": null, "source_file_id": "AIMS-2026-08-13", "ingested_at": "2026-08-15T02:14:00Z", "version": 1, "public_rate": 309.7, "discount_pct": 17.88 }, { "id": "RS-8853786-1", "period": "2026-08", "night": "2026-08-14", "booking_id": "RS-8853786", "duty_id": "D-513786", "layover_id": "L-513787", "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": "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": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-08-05T01:15:00Z", "checkin_time": "01:15", "checkout_time": "10:00", "duty_end_utc": "2026-08-14T00:30:00Z", "duty_start_utc": "2026-08-14T14:05:00Z", "transfer_minutes": 10, "room_net": 257.88, "vat_rate": 7, "vat_amount": 18.05, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 280.93, "ancillaries": 18.88, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 280.93, "fx_rate": 1, "fx_date": "2026-08-14", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 258.38, "markup": 22.55, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853786", "vcc_auth_amount": 324.81, "folio_amount": null, "settled_amount": null, "settled_at": null, "contracted_rate": null, "baseline_rate": 344.66, "market_rate": 334.32, "rate_honoured": 1, "customer": "UPS", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "awaiting_folio", "recon_amount": 0, "crew_rating": 2.9, "complaint_theme": "checkin", "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-14T02:14:00Z", "version": 1, "public_rate": 344.66, "discount_pct": 18.49 }, { "id": "RS-8853434-2", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8853434", "duty_id": "D-513434", "layover_id": "L-513435", "crew_id": "IRE-1004", "crew_name": "N. Nolan", "crew_rank": "CPT", "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": "C-107", "allotment_id": "A-107", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-07T16:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-13T15:15:00Z", "duty_start_utc": "2026-08-13T11:50:00Z", "transfer_minutes": 10, "room_net": 232.5, "vat_rate": 7, "vat_amount": 16.27, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 253.77, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 253.77, "fx_rate": 1, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 253.77, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853434", "vcc_auth_amount": 278.77, "folio_amount": 253.77, "settled_amount": 253.77, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 253.77, "baseline_rate": 372.65, "market_rate": 361.47, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 3.3, "complaint_theme": null, "source_file_id": "AIMS-2026-08-12", "ingested_at": "2026-08-13T02:14:00Z", "version": 1, "public_rate": 372.65, "discount_pct": 31.9 }, { "id": "RS-8853758-3", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8853758", "duty_id": "D-513758", "layover_id": "L-513759", "crew_id": "IRE-1079", "crew_name": "K. Mulligan", "crew_rank": "CPT", "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": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-06T22:30:00Z", "checkin_time": "22:30", "checkout_time": "08:15", "duty_end_utc": "2026-08-13T21:33:00Z", "duty_start_utc": "2026-08-13T09:15:00Z", "transfer_minutes": 22, "room_net": 241.94, "vat_rate": 6, "vat_amount": 14.52, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 260.46, "ancillaries": 32.11, "fee": 0, "currency_local": "EUR", "rate_paid_local": 260.46, "fx_rate": 1, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 260.46, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853758", "vcc_auth_amount": 317.57, "folio_amount": 260.46, "settled_amount": 260.46, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 260.46, "baseline_rate": 361.47, "market_rate": 350.63, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 361.47, "discount_pct": 27.94 }, { "id": "RS-8853799-2", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8853799", "duty_id": "D-513799", "layover_id": "L-513800", "crew_id": "IRE-1053", "crew_name": "T. Fitzgerald", "crew_rank": "CPT", "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": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-11T17:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-13T04:43:00Z", "duty_start_utc": "2026-08-13T09:15:00Z", "transfer_minutes": 22, "room_net": 264.58, "vat_rate": 20, "vat_amount": 52.92, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 317.5, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 269, "fx_rate": 1.180312, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 300.81, "markup": 16.69, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853799", "vcc_auth_amount": 342.5, "folio_amount": 317.5, "settled_amount": 317.5, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 317.5, "baseline_rate": 453.27, "market_rate": 439.67, "rate_honoured": 1, "customer": "UPS", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 453.27, "discount_pct": 29.95 }, { "id": "RS-8855137-2", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8855137", "duty_id": "D-515137", "layover_id": "L-515138", "crew_id": "FRA-1062", "crew_name": "T. Bernard", "crew_rank": "CC", "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": "positioning", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-11T15:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-13T14:11:00Z", "duty_start_utc": "2026-08-13T14:05:00Z", "transfer_minutes": 14, "room_net": 265.64, "vat_rate": 10, "vat_amount": 26.56, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 297.4, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 297.4, "fx_rate": 1, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 277.73, "markup": 19.67, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855137", "vcc_auth_amount": 322.4, "folio_amount": 297.4, "settled_amount": 297.4, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 297.4, "baseline_rate": 396.94, "market_rate": 385.03, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 396.94, "discount_pct": 25.08 }, { "id": "RS-8853704-4", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8853704", "duty_id": "D-513704", "layover_id": "L-513705", "crew_id": "IRE-1063", "crew_name": "S. Kavanagh", "crew_rank": "ENG", "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": "overnight", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-07T05:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-11T04:47:00Z", "duty_start_utc": "2026-08-11T09:15:00Z", "transfer_minutes": 18, "room_net": 255.12, "vat_rate": 20, "vat_amount": 51.02, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 306.14, "ancillaries": 16.53, "fee": 0, "currency_local": "GBP", "rate_paid_local": 258.48, "fx_rate": 1.184406, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 286.15, "markup": 19.99, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853704", "vcc_auth_amount": 347.67, "folio_amount": 306.14, "settled_amount": 306.14, "settled_at": "2026-08-11T23:59:00Z", "contracted_rate": 306.14, "baseline_rate": 428.13, "market_rate": 415.29, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-11T02:14:00Z", "version": 1, "public_rate": 428.13, "discount_pct": 28.49 }, { "id": "RS-8855152-1", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8855152", "duty_id": "D-515152", "layover_id": "L-515153", "crew_id": "FRA-1005", "crew_name": "H. Fontaine", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "MAD", "country": "ES", "property_id": "P-136", "hotel": "Novotel Madrid Barajas", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-06T22:30:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-11T21:32:00Z", "duty_start_utc": "2026-08-11T09:15:00Z", "transfer_minutes": 23, "room_net": 284.53, "vat_rate": 10, "vat_amount": 28.45, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 312.98, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 312.98, "fx_rate": 1, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 280.21, "markup": 32.77, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855152", "vcc_auth_amount": 337.98, "folio_amount": 312.98, "settled_amount": 312.98, "settled_at": "2026-08-11T23:59:00Z", "contracted_rate": null, "baseline_rate": 392.95, "market_rate": 381.16, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "CDG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 392.95, "discount_pct": 20.35 }, { "id": "RS-8853032-1", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853032", "duty_id": "D-513032", "layover_id": "L-513033", "crew_id": "IRE-1009", "crew_name": "T. Quinn", "crew_rank": "FO", "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, "booking_created_at": "2026-08-09T23:45:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-10T00:30:00Z", "duty_start_utc": "2026-08-10T06:30:00Z", "transfer_minutes": 10, "room_net": 315.41, "vat_rate": 7, "vat_amount": 22.08, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 342.49, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 342.49, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 342.49, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853032", "vcc_auth_amount": 279.96, "folio_amount": 342.49, "settled_amount": 342.49, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": 254.96, "baseline_rate": 350.62, "market_rate": 340.1, "rate_honoured": 0, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 11.18, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 350.62, "discount_pct": 2.32 }, { "id": "RS-8853290-1", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853290", "duty_id": "D-513290", "layover_id": "L-513291", "crew_id": "IRE-1086", "crew_name": "J. Doyle", "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-109", "hotel": "Novotel Koln City", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-08T22:30:00Z", "checkin_time": "22:30", "checkout_time": "08:15", "duty_end_utc": "2026-08-10T21:11:00Z", "duty_start_utc": "2026-08-10T06:30:00Z", "transfer_minutes": 44, "room_net": 249.15, "vat_rate": 7, "vat_amount": 17.44, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 271.59, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 271.59, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 249.47, "markup": 22.12, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853290", "vcc_auth_amount": 296.59, "folio_amount": 271.59, "settled_amount": 271.59, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": null, "baseline_rate": 335.24, "market_rate": 325.18, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 335.24, "discount_pct": 18.99 }, { "id": "RS-8853387-1", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853387", "duty_id": "D-513387", "layover_id": "L-513388", "crew_id": "IRE-1013", "crew_name": "B. O Conaill", "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-103", "hotel": "Radisson Blu Dublin Airport", "chain": "Radisson", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-08T22:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-10T21:04:00Z", "duty_start_utc": "2026-08-10T09:15:00Z", "transfer_minutes": 51, "room_net": 241.1, "vat_rate": 13.5, "vat_amount": 32.55, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 273.65, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 273.65, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 250.63, "markup": 23.02, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853387", "vcc_auth_amount": 298.65, "folio_amount": 273.65, "settled_amount": 273.65, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": null, "baseline_rate": 332.51, "market_rate": 322.53, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 332.51, "discount_pct": 17.7 }, { "id": "RS-8853591-1", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853591", "duty_id": "D-513591", "layover_id": "L-513592", "crew_id": "IRE-1002", "crew_name": "E. Doyle", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "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": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-08T16:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-10T15:09:00Z", "duty_start_utc": "2026-08-10T11:50:00Z", "transfer_minutes": 16, "room_net": 248.2, "vat_rate": 7, "vat_amount": 17.37, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 270.57, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 270.57, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 249.72, "markup": 20.85, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853591", "vcc_auth_amount": 295.57, "folio_amount": 270.57, "settled_amount": 270.57, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": 270.57, "baseline_rate": 356.66, "market_rate": 345.96, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 356.66, "discount_pct": 24.14 }, { "id": "RS-8853721-1", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853721", "duty_id": "D-513721", "layover_id": "L-513722", "crew_id": "IRE-1018", "crew_name": "B. Brennan", "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-103", "hotel": "Radisson Blu Dublin Airport", "chain": "Radisson", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-07T22:30:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-10T21:04:00Z", "duty_start_utc": "2026-08-10T06:30:00Z", "transfer_minutes": 51, "room_net": 233.4, "vat_rate": 13.5, "vat_amount": 31.51, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 264.91, "ancillaries": 35.79, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 264.91, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 243.43, "markup": 21.48, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853721", "vcc_auth_amount": 325.7, "folio_amount": 264.91, "settled_amount": 264.91, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": null, "baseline_rate": 332.51, "market_rate": 322.53, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 332.51, "discount_pct": 20.33 }, { "id": "RS-8854423-2", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8854423", "duty_id": "D-514423", "layover_id": "L-514424", "crew_id": "BEL-1004", "crew_name": "T. Maes", "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": "no_show", "lead_time_days": 9, "booking_created_at": "2026-07-31T14:00:00Z", "checkin_time": "14:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-10T12:41:00Z", "duty_start_utc": "2026-08-10T11:50:00Z", "transfer_minutes": 44, "room_net": 208.04, "vat_rate": 15, "vat_amount": 31.21, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 239.25, "ancillaries": 0, "fee": 0, "currency_local": "ZAR", "rate_paid_local": 4745.52, "fx_rate": 0.050416, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 224.93, "markup": 14.32, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854423", "vcc_auth_amount": 264.25, "folio_amount": 239.25, "settled_amount": 239.25, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": 239.25, "baseline_rate": 325.22, "market_rate": 315.46, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 325.22, "discount_pct": 26.43 }, { "id": "RS-8854492-2", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8854492", "duty_id": "D-514492", "layover_id": "L-514493", "crew_id": "BEL-1056", "crew_name": "K. Dubois", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "standby", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-07-31T22:30:00Z", "checkin_time": "22:30", "checkout_time": "04:30", "duty_end_utc": "2026-08-10T21:09:00Z", "duty_start_utc": "2026-08-10T09:15:00Z", "transfer_minutes": 46, "room_net": 200.53, "vat_rate": 15, "vat_amount": 30.08, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 230.61, "ancillaries": 0, "fee": 0, "currency_local": "ZAR", "rate_paid_local": 4574.14, "fx_rate": 0.050416, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 230.61, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854492", "vcc_auth_amount": 255.61, "folio_amount": 230.61, "settled_amount": 230.61, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": 230.61, "baseline_rate": 307.2, "market_rate": 297.98, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 307.2, "discount_pct": 24.93 }, { "id": "RS-8854714-2", "period": "2026-08", "night": "2026-08-10", "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": "overnight", "night_status": "no_show", "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-10T15:07:00Z", "duty_start_utc": "2026-08-10T09:15:00Z", "transfer_minutes": 18, "room_net": 295.71, "vat_rate": 10, "vat_amount": 29.57, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 328.58, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 328.58, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 328.58, "markup": 0, "commission_received": 31.46, "commission_shared": 15.73, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854714", "vcc_auth_amount": 353.58, "folio_amount": 328.58, "settled_amount": 328.58, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": null, "baseline_rate": 358.54, "market_rate": 347.78, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 203.23, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 0, "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": 358.54, "discount_pct": 8.36 }, { "id": "RS-8854790-4", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8854790", "duty_id": "D-514790", "layover_id": "L-514791", "crew_id": "FRA-1023", "crew_name": "T. Berger", "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-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": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-06T01:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-10T00:30:00Z", "duty_start_utc": "2026-08-10T09:15:00Z", "transfer_minutes": 10, "room_net": 242.76, "vat_rate": 10, "vat_amount": 24.28, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 269.92, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 269.92, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 269.92, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854790", "vcc_auth_amount": 294.92, "folio_amount": 269.92, "settled_amount": 269.92, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": 269.92, "baseline_rate": 354.8, "market_rate": 344.16, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LYS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-10T02:14:00Z", "version": 1, "public_rate": 354.8, "discount_pct": 23.92 }, { "id": "RS-8852973-1", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8852973", "duty_id": "D-512973", "layover_id": "L-512974", "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": "DUB", "country": "IE", "property_id": "P-101", "hotel": "Clayton Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-101", "allotment_id": "A-101", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-07T14:00:00Z", "checkin_time": "14:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-09T13:10:00Z", "duty_start_utc": "2026-08-09T06:30:00Z", "transfer_minutes": 15, "room_net": 209.75, "vat_rate": 13.5, "vat_amount": 28.32, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 238.07, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 238.07, "fx_rate": 1, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 222.17, "markup": 15.9, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852973", "vcc_auth_amount": 263.07, "folio_amount": 238.07, "settled_amount": 238.07, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": 238.07, "baseline_rate": 288.17, "market_rate": 279.52, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2, "complaint_theme": "transfer", "source_file_id": "AIMS-2026-08-09", "ingested_at": "2026-08-09T02:14:00Z", "version": 1, "public_rate": 288.17, "discount_pct": 17.39 }, { "id": "RS-8853482-1", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8853482", "duty_id": "D-513482", "layover_id": "L-513483", "crew_id": "IRE-1005", "crew_name": "B. Fitzgerald", "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-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": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-04T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-09T14:07:00Z", "duty_start_utc": "2026-08-09T11:50:00Z", "transfer_minutes": 18, "room_net": 299.05, "vat_rate": 20, "vat_amount": 59.81, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 358.86, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 302.34, "fx_rate": 1.186933, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 358.86, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853482", "vcc_auth_amount": 330.81, "folio_amount": 358.86, "settled_amount": 358.86, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": 305.81, "baseline_rate": 368.78, "market_rate": 357.72, "rate_honoured": 0, "customer": "UPS", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 368.78, "discount_pct": 2.69 }, { "id": "RS-8854022-1", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8854022", "duty_id": "D-514022", "layover_id": "L-514023", "crew_id": "BEL-1028", "crew_name": "T. Maes", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "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": "positioning", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-06T15:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-09T13:29:00Z", "duty_start_utc": "2026-08-09T11:50:00Z", "transfer_minutes": 56, "room_net": 296.75, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 296.75, "ancillaries": 20.73, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2471.72, "fx_rate": 0.120058, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 296.75, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854022", "vcc_auth_amount": 342.48, "folio_amount": 296.75, "settled_amount": 296.75, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": 296.75, "baseline_rate": 362.29, "market_rate": 351.42, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 362.29, "discount_pct": 18.09 }, { "id": "RS-8854923-1", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8854923", "duty_id": "D-514923", "layover_id": "L-514924", "crew_id": "FRA-1055", "crew_name": "A. Marchand", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "BRU", "country": "BE", "property_id": "P-118", "hotel": "NH Brussels Airport", "chain": "NH", "contract_id": "C-118", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-08T01:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-09T00:27:00Z", "duty_start_utc": "2026-08-09T11:50:00Z", "transfer_minutes": 13, "room_net": 339.12, "vat_rate": 6, "vat_amount": 20.35, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4.24, "rate_paid": 363.71, "ancillaries": 26.53, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 363.71, "fx_rate": 1, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 363.71, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854923", "vcc_auth_amount": 381.58, "folio_amount": 390.24, "settled_amount": 390.24, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": 330.05, "baseline_rate": 380.15, "market_rate": 368.75, "rate_honoured": 0, "customer": "DHL", "cost_centre": "CDG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 380.15, "discount_pct": 4.32 }, { "id": "RS-8855038-1", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8855038", "duty_id": "D-515038", "layover_id": "L-515039", "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": "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": "positioning", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-04T14:00:00Z", "checkin_time": "14:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-09T13:03:00Z", "duty_start_utc": "2026-08-09T11:50:00Z", "transfer_minutes": 22, "room_net": 223.98, "vat_rate": 10, "vat_amount": 22.4, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 249.26, "ancillaries": 26.92, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 249.26, "fx_rate": 1, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 249.26, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855038", "vcc_auth_amount": 301.18, "folio_amount": 249.26, "settled_amount": 249.26, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": 249.26, "baseline_rate": 301.13, "market_rate": 292.1, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 301.13, "discount_pct": 17.23 }, { "id": "RS-8853406-1", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8853406", "duty_id": "D-513406", "layover_id": "L-513407", "crew_id": "IRE-1063", "crew_name": "S. Kavanagh", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "STN", "country": "GB", "property_id": "P-115", "hotel": "Radisson Blu Stansted", "chain": "Radisson", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "no_show", "lead_time_days": 0.5, "booking_created_at": "2026-08-08T02:00:00Z", "checkin_time": "14:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-08T13:03:00Z", "duty_start_utc": "2026-08-08T09:15:00Z", "transfer_minutes": 22, "room_net": 278.77, "vat_rate": 20, "vat_amount": 55.75, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 334.52, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 281.79, "fx_rate": 1.187108, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 306.24, "markup": 28.28, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853406", "vcc_auth_amount": 359.52, "folio_amount": 334.52, "settled_amount": 334.52, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": null, "baseline_rate": 371.84, "market_rate": 360.68, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 371.84, "discount_pct": 10.04 }, { "id": "RS-8853777-2", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8853777", "duty_id": "D-513777", "layover_id": "L-513778", "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": "DUB", "country": "IE", "property_id": "P-101", "hotel": "Clayton Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-101", "allotment_id": "A-101", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-07T04:10:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-08T04:50:00Z", "duty_start_utc": "2026-08-08T11:50:00Z", "transfer_minutes": 15, "room_net": 211.08, "vat_rate": 13.5, "vat_amount": 28.5, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 239.58, "ancillaries": 21.92, "fee": 0, "currency_local": "EUR", "rate_paid_local": 239.58, "fx_rate": 1, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 239.58, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853777", "vcc_auth_amount": 286.5, "folio_amount": 239.58, "settled_amount": 239.58, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": 239.58, "baseline_rate": 284.68, "market_rate": 276.14, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 11.54, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 284.68, "discount_pct": 15.84 }, { "id": "RS-8853992-1", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8853992", "duty_id": "D-513992", "layover_id": "L-513993", "crew_id": "BEL-1004", "crew_name": "T. Maes", "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-123", "hotel": "Le Meridien Dubai", "chain": "Marriott", "contract_id": "C-123", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-07T23:45:00Z", "checkin_time": "01:15", "checkout_time": "04:30", "duty_end_utc": "2026-08-08T00:00:00Z", "duty_start_utc": "2026-08-08T09:15:00Z", "transfer_minutes": 48, "room_net": 273.1, "vat_rate": 5, "vat_amount": 13.65, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 291.75, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1137.74, "fx_rate": 0.256429, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 291.75, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853992", "vcc_auth_amount": 316.75, "folio_amount": 291.75, "settled_amount": 291.75, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": 291.75, "baseline_rate": 358.69, "market_rate": 347.93, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 12.89, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 3.1, "complaint_theme": null, "source_file_id": "AIMS-2026-08-08", "ingested_at": "2026-08-08T02:14:00Z", "version": 1, "public_rate": 358.69, "discount_pct": 18.66 }, { "id": "RS-8854304-1", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8854304", "duty_id": "D-514304", "layover_id": "L-514305", "crew_id": "BEL-1040", "crew_name": "O. Maes", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "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": "irops", "night_status": "no_show", "lead_time_days": 0, "booking_created_at": "2026-08-08T21:00:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-08T21:41:00Z", "duty_start_utc": "2026-08-08T11:50:00Z", "transfer_minutes": 14, "room_net": 286.03, "vat_rate": 10, "vat_amount": 28.6, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 319.83, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 319.83, "fx_rate": 1, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 319.83, "markup": 0, "commission_received": 23.96, "commission_shared": 11.98, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854304", "vcc_auth_amount": 344.83, "folio_amount": 319.83, "settled_amount": 319.83, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": null, "baseline_rate": 348.22, "market_rate": 337.77, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "BRU-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 12.32, "modify_attempted": 1, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": "automation", "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": 348.22, "discount_pct": 8.15 }, { "id": "RS-8854625-1", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8854625", "duty_id": "D-514625", "layover_id": "L-514626", "crew_id": "BEL-1070", "crew_name": "S. Declerck", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-07-30T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-08T13:29:00Z", "duty_start_utc": "2026-08-08T11:50:00Z", "transfer_minutes": 56, "room_net": 245.22, "vat_rate": 5, "vat_amount": 12.26, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 262.48, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1023.6, "fx_rate": 0.256429, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 239.31, "markup": 23.17, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854625", "vcc_auth_amount": 287.48, "folio_amount": 262.48, "settled_amount": 262.48, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": null, "baseline_rate": 329.59, "market_rate": 319.7, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 329.59, "discount_pct": 20.36 }, { "id": "RS-8854815-1", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8854815", "duty_id": "D-514815", "layover_id": "L-514816", "crew_id": "FRA-1011", "crew_name": "A. Berger", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "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": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-08-06T16:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-08T15:03:00Z", "duty_start_utc": "2026-08-08T06:30:00Z", "transfer_minutes": 22, "room_net": 210.69, "vat_rate": 10, "vat_amount": 21.07, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 234.64, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 234.64, "fx_rate": 1, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 213.51, "markup": 21.13, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854815", "vcc_auth_amount": 259.64, "folio_amount": 234.64, "settled_amount": 234.64, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": null, "baseline_rate": 289.13, "market_rate": 280.46, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "CDG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 289.13, "discount_pct": 18.85 }, { "id": "RS-8854995-1", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8854995", "duty_id": "D-514995", "layover_id": "L-514996", "crew_id": "FRA-1038", "crew_name": "B. 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-126", "hotel": "Novotel Paris CDG", "chain": "Accor", "contract_id": "C-126", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-05T05:40:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-08T04:51:00Z", "duty_start_utc": "2026-08-08T09:15:00Z", "transfer_minutes": 14, "room_net": 263.68, "vat_rate": 10, "vat_amount": 26.37, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 295.25, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 295.25, "fx_rate": 1, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 275.38, "markup": 19.87, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854995", "vcc_auth_amount": 320.25, "folio_amount": 295.25, "settled_amount": 295.25, "settled_at": "2026-08-08T23:59:00Z", "contracted_rate": 295.25, "baseline_rate": 350.75, "market_rate": 340.23, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 350.75, "discount_pct": 15.82 }, { "id": "RS-8853062-1", "period": "2026-08", "night": "2026-08-07", "booking_id": "RS-8853062", "duty_id": "D-513062", "layover_id": "L-513063", "crew_id": "IRE-1001", "crew_name": "N. O Conaill", "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-114", "hotel": "Ibis Birmingham Airport", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "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-07T14:05:00Z", "transfer_minutes": 23, "room_net": 266.39, "vat_rate": 20, "vat_amount": 53.28, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 319.67, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 268.91, "fx_rate": 1.188773, "fx_date": "2026-08-07", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 292.28, "markup": 27.39, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853062", "vcc_auth_amount": 344.67, "folio_amount": 319.67, "settled_amount": 319.67, "settled_at": "2026-08-07T23:59:00Z", "contracted_rate": null, "baseline_rate": 367.18, "market_rate": 356.16, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.3, "complaint_theme": "room", "source_file_id": "AIMS-2026-08-07", "ingested_at": "2026-08-07T02:14:00Z", "version": 1, "public_rate": 367.18, "discount_pct": 12.94 }, { "id": "RS-8853302-1", "period": "2026-08", "night": "2026-08-07", "booking_id": "RS-8853302", "duty_id": "D-513302", "layover_id": "L-513303", "crew_id": "IRE-1041", "crew_name": "M. Fitzgerald", "crew_rank": "CC", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-06T16:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-07T15:03:00Z", "duty_start_utc": "2026-08-07T06:30:00Z", "transfer_minutes": 22, "room_net": 280.05, "vat_rate": 20, "vat_amount": 56.01, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 336.06, "ancillaries": 33.06, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 282.69, "fx_rate": 1.188773, "fx_date": "2026-08-07", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 301.77, "markup": 34.29, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853302", "vcc_auth_amount": 394.12, "folio_amount": 336.06, "settled_amount": 336.06, "settled_at": "2026-08-07T23:59:00Z", "contracted_rate": null, "baseline_rate": 415.51, "market_rate": 403.04, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 415.51, "discount_pct": 19.12 }, { "id": "RS-8853106-3", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8853106", "duty_id": "D-513106", "layover_id": "L-513107", "crew_id": "IRE-1055", "crew_name": "K. Mulligan", "crew_rank": "FO", "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": "no_show", "lead_time_days": 5, "booking_created_at": "2026-07-30T05:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-06T04:42:00Z", "duty_start_utc": "2026-08-06T09:15:00Z", "transfer_minutes": 23, "room_net": 233.24, "vat_rate": 20, "vat_amount": 46.65, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 279.89, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 235.07, "fx_rate": 1.190677, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 279.89, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853106", "vcc_auth_amount": 304.89, "folio_amount": 279.89, "settled_amount": 279.89, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": 279.89, "baseline_rate": 392.06, "market_rate": 380.3, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-06T02:14:00Z", "version": 1, "public_rate": 392.06, "discount_pct": 28.61 }, { "id": "RS-8853742-3", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8853742", "duty_id": "D-513742", "layover_id": "L-513743", "crew_id": "IRE-S206", "crew_name": "S. Devlin", "crew_rank": "STAFF", "traveller_type": "staff", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "training", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-03T15:00:00Z", "checkin_time": "15:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-06T14:01:00Z", "duty_start_utc": "2026-08-06T14:05:00Z", "transfer_minutes": 24, "room_net": 230.23, "vat_rate": 20, "vat_amount": 46.05, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 276.28, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 232.04, "fx_rate": 1.190677, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 276.28, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853742", "vcc_auth_amount": 301.28, "folio_amount": 276.28, "settled_amount": 276.28, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": 276.28, "baseline_rate": 399.14, "market_rate": 387.17, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-06T02:14:00Z", "version": 1, "public_rate": 399.14, "discount_pct": 30.78 }, { "id": "RS-8854210-1", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8854210", "duty_id": "D-514210", "layover_id": "L-514211", "crew_id": "BEL-1074", "crew_name": "M. De Smet", "crew_rank": "CPT", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 3, "booking_created_at": "2026-08-03T14:00:00Z", "checkin_time": "14:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-06T13:11:00Z", "duty_start_utc": "2026-08-06T09:15:00Z", "transfer_minutes": 14, "room_net": 263.88, "vat_rate": 10, "vat_amount": 26.39, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 295.47, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 295.47, "fx_rate": 1, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 295.47, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854210", "vcc_auth_amount": 320.47, "folio_amount": 295.47, "settled_amount": 295.47, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": 295.47, "baseline_rate": 429.42, "market_rate": 416.54, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 429.42, "discount_pct": 31.19 }, { "id": "RS-8854351-1", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8854351", "duty_id": "D-514351", "layover_id": "L-514352", "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": "no_show", "lead_time_days": 5, "booking_created_at": "2026-08-01T15:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-06T13:41:00Z", "duty_start_utc": "2026-08-06T09:15:00Z", "transfer_minutes": 44, "room_net": 245.34, "vat_rate": 15, "vat_amount": 36.8, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 282.14, "ancillaries": 0, "fee": 15.97, "currency_local": "ZAR", "rate_paid_local": 5616.18, "fx_rate": 0.050237, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 264.86, "markup": 17.28, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854351", "vcc_auth_amount": 265.92, "folio_amount": 282.14, "settled_amount": 282.14, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": 240.92, "baseline_rate": 326.48, "market_rate": 316.69, "rate_honoured": 0, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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": 326.48, "discount_pct": 13.58 }, { "id": "RS-8854087-2", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8854087", "duty_id": "D-514087", "layover_id": "L-514088", "crew_id": "BEL-1018", "crew_name": "V. Claes", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "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": "standby", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-02T01:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-04T00:00:00Z", "duty_start_utc": "2026-08-04T14:05:00Z", "transfer_minutes": 44, "room_net": 297.03, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 297.03, "ancillaries": 0, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2481.41, "fx_rate": 0.119702, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 297.03, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854087", "vcc_auth_amount": 322.03, "folio_amount": 297.03, "settled_amount": 297.03, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": 297.03, "baseline_rate": 436.63, "market_rate": 423.53, "rate_honoured": 1, "customer": "DHL", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 4.4, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 436.63, "discount_pct": 31.97 }, { "id": "RS-8854163-2", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8854163", "duty_id": "D-514163", "layover_id": "L-514164", "crew_id": "BEL-1047", "crew_name": "Y. Verhoeven", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "CDG", "country": "FR", "property_id": "P-126", "hotel": "Novotel Paris CDG", "chain": "Accor", "contract_id": "C-126", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-07-29T15:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-04T14:11:00Z", "duty_start_utc": "2026-08-04T11:50:00Z", "transfer_minutes": 14, "room_net": 262.47, "vat_rate": 10, "vat_amount": 26.25, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 293.92, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 293.92, "fx_rate": 1, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 277.22, "markup": 16.7, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854163", "vcc_auth_amount": 318.92, "folio_amount": 293.92, "settled_amount": 293.92, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": 293.92, "baseline_rate": 426.25, "market_rate": 413.46, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 2.5, "complaint_theme": "transfer", "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 426.25, "discount_pct": 31.05 }, { "id": "RS-8854860-2", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8854860", "duty_id": "D-514860", "layover_id": "L-514861", "crew_id": "FRA-1086", "crew_name": "D. Bernard", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "BRU", "country": "BE", "property_id": "P-119", "hotel": "Sheraton Brussels Airport", "chain": "Marriott", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 5, "booking_created_at": "2026-07-29T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-04T04:30:00Z", "duty_start_utc": "2026-08-04T06:30:00Z", "transfer_minutes": 35, "room_net": 334.86, "vat_rate": 6, "vat_amount": 20.09, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4.24, "rate_paid": 359.19, "ancillaries": 28.43, "fee": 0, "currency_local": "EUR", "rate_paid_local": 359.19, "fx_rate": 1, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 323.65, "markup": 35.54, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854860", "vcc_auth_amount": 412.62, "folio_amount": 359.19, "settled_amount": 359.19, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": null, "baseline_rate": 450.46, "market_rate": 436.95, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 450.46, "discount_pct": 20.26 }, { "id": "RS-8852957-1", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8852957", "duty_id": "D-512957", "layover_id": "L-512958", "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": "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": "no_show", "lead_time_days": 9, "booking_created_at": "2026-07-25T01:15:00Z", "checkin_time": "01:15", "checkout_time": "10:00", "duty_end_utc": "2026-08-03T00:18:00Z", "duty_start_utc": "2026-08-03T14:05:00Z", "transfer_minutes": 22, "room_net": 243.56, "vat_rate": 6, "vat_amount": 14.61, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 262.17, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 262.17, "fx_rate": 1, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 243.89, "markup": 18.28, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852957", "vcc_auth_amount": 287.17, "folio_amount": 262.17, "settled_amount": 262.17, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": 262.17, "baseline_rate": 346.29, "market_rate": 335.9, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "DUB-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 346.29, "discount_pct": 24.29 }, { "id": "RS-8853316-1", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8853316", "duty_id": "D-513316", "layover_id": "L-513317", "crew_id": "IRE-1001", "crew_name": "N. O Conaill", "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": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-02T14:00:00Z", "checkin_time": "14:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-03T13:02:00Z", "duty_start_utc": "2026-08-03T06:30:00Z", "transfer_minutes": 23, "room_net": 230.04, "vat_rate": 13.5, "vat_amount": 31.06, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 261.1, "ancillaries": 22.89, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 261.1, "fx_rate": 1, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 246.68, "markup": 14.42, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853316", "vcc_auth_amount": 308.99, "folio_amount": 261.1, "settled_amount": 261.1, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": 261.1, "baseline_rate": 353.3, "market_rate": 342.7, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 353.3, "discount_pct": 26.1 }, { "id": "RS-8854401-1", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8854401", "duty_id": "D-514401", "layover_id": "L-514402", "crew_id": "BEL-1065", "crew_name": "B. Willems", "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": "no_show", "lead_time_days": 1, "booking_created_at": "2026-08-02T22:30:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-03T20:59:00Z", "duty_start_utc": "2026-08-03T14:05:00Z", "transfer_minutes": 56, "room_net": 271.77, "vat_rate": 5, "vat_amount": 13.59, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 290.36, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1138.15, "fx_rate": 0.255116, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 270.51, "markup": 19.85, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854401", "vcc_auth_amount": 315.36, "folio_amount": 290.36, "settled_amount": 290.36, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": 290.36, "baseline_rate": 384.09, "market_rate": 372.57, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "LGG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 384.09, "discount_pct": 24.4 }, { "id": "RS-8855173-1", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8855173", "duty_id": "D-515173", "layover_id": "L-515174", "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": "MRS", "country": "FR", "property_id": "P-132", "hotel": "Holiday Inn Marseille", "chain": "IHG", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-07-25T16:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-03T15:09:00Z", "duty_start_utc": "2026-08-03T06:30:00Z", "transfer_minutes": 16, "room_net": 252.47, "vat_rate": 10, "vat_amount": 25.25, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 281.02, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 281.02, "fx_rate": 1, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 258.29, "markup": 22.73, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855173", "vcc_auth_amount": 306.02, "folio_amount": 281.02, "settled_amount": 281.02, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": null, "baseline_rate": 347.82, "market_rate": 337.39, "rate_honoured": 1, "customer": "DHL", "cost_centre": "CDG-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 347.82, "discount_pct": 19.21 }, { "id": "RS-8852923-1", "period": "2026-08", "night": "2026-08-01", "booking_id": "RS-8852923", "duty_id": "D-512923", "layover_id": "L-512924", "crew_id": "IRE-1042", "crew_name": "B. Brennan", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "CGN", "country": "DE", "property_id": "P-108", "hotel": "Leonardo Hotel Koln", "chain": "Leonardo", "contract_id": "C-108", "allotment_id": "A-108", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "no_show", "lead_time_days": 2, "booking_created_at": "2026-07-30T15:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-01T14:09:00Z", "duty_start_utc": "2026-08-01T14:05:00Z", "transfer_minutes": 16, "room_net": 250.21, "vat_rate": 7, "vat_amount": 17.51, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 272.72, "ancillaries": 9.04, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 272.72, "fx_rate": 1, "fx_date": "2026-08-01", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 254.54, "markup": 18.18, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852923", "vcc_auth_amount": 306.76, "folio_amount": 272.72, "settled_amount": 272.72, "settled_at": "2026-08-01T23:59:00Z", "contracted_rate": 272.72, "baseline_rate": 312.03, "market_rate": 302.67, "rate_honoured": 1, "customer": "UPS", "cost_centre": "EMA-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-01T02:14:00Z", "version": 1, "public_rate": 312.03, "discount_pct": 12.6 }, { "id": "RS-8853927-1", "period": "2026-08", "night": "2026-08-01", "booking_id": "RS-8853927", "duty_id": "D-513927", "layover_id": "L-513928", "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": "HKG", "country": "HK", "property_id": "P-120", "hotel": "Regal Airport Hotel", "chain": "Regal", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 1, "booking_created_at": "2026-07-31T14:00:00Z", "checkin_time": "14:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-01T12:29:00Z", "duty_start_utc": "2026-08-01T14:05:00Z", "transfer_minutes": 56, "room_net": 284.71, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 284.71, "ancillaries": 0, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2377.42, "fx_rate": 0.119756, "fx_date": "2026-08-01", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 253.37, "markup": 31.34, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853927", "vcc_auth_amount": 309.71, "folio_amount": 284.71, "settled_amount": 284.71, "settled_at": "2026-08-01T23:59:00Z", "contracted_rate": null, "baseline_rate": 346.66, "market_rate": 336.26, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": 3.5, "complaint_theme": null, "source_file_id": "AIMS-2026-08-01", "ingested_at": "2026-08-01T02:14:00Z", "version": 1, "public_rate": 346.66, "discount_pct": 17.87 }, { "id": "RS-8855050-1", "period": "2026-08", "night": "2026-08-01", "booking_id": "RS-8855050", "duty_id": "D-515050", "layover_id": "L-515051", "crew_id": "FRA-1012", "crew_name": "Y. Moreau", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "no_show", "lead_time_days": 9, "booking_created_at": "2026-07-23T16:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-01T15:15:00Z", "duty_start_utc": "2026-08-01T09:15:00Z", "transfer_minutes": 10, "room_net": 246.38, "vat_rate": 10, "vat_amount": 24.64, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 274.32, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 274.32, "fx_rate": 1, "fx_date": "2026-08-01", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 274.32, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855050", "vcc_auth_amount": 299.32, "folio_amount": 274.32, "settled_amount": 274.32, "settled_at": "2026-08-01T23:59:00Z", "contracted_rate": 274.32, "baseline_rate": 320.14, "market_rate": 310.54, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "MRS-CREW", "change_type": null, "change_source": null, "change_cost": 0, "modify_attempted": 0, "modify_failed_reason": null, "room_lost": 0, "exception_opened_at": null, "exception_resolved_at": null, "resolved_by": null, "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-01T02:14:00Z", "version": 1, "public_rate": 320.14, "discount_pct": 14.31 } ] }