{ "metric": "released", "label": "Rooms released", "note": "Handed back inside the release window, so nothing was charged.", "table": "room_night", "sort": null, "dir": "desc", "filters": {}, "total": 37, "sums": { "public_rate": 13474.1, "rate_paid": 10602.34 }, "rows": [ { "id": "RS-8853871-4", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8853871", "duty_id": "D-513871", "layover_id": "L-513872", "crew_id": "BEL-1046", "crew_name": "N. Declerck", "crew_rank": "FO", "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": "released", "lead_time_days": 3, "booking_created_at": "2026-08-24T15:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-30T13:41:00Z", "duty_start_utc": "2026-08-30T11:50:00Z", "transfer_minutes": 44, "room_net": 207.28, "vat_rate": 15, "vat_amount": 31.09, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 238.37, "ancillaries": 27.36, "fee": 0, "currency_local": "ZAR", "rate_paid_local": 4737.27, "fx_rate": 0.050318, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 223.12, "markup": 15.25, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853871", "vcc_auth_amount": 290.73, "folio_amount": 265.73, "settled_amount": 265.73, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": 238.37, "baseline_rate": 291.32, "market_rate": 282.58, "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-27", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 291.32, "discount_pct": 18.18 }, { "id": "RS-8853375-2", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8853375", "duty_id": "D-513375", "layover_id": "L-513376", "crew_id": "IRE-1026", "crew_name": "V. Doyle", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-101", "hotel": "Clayton Hotel Dublin Airport", "chain": "Dalata", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "positioning", "night_status": "released", "lead_time_days": 1, "booking_created_at": "2026-08-27T15:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-29T14:10:00Z", "duty_start_utc": "2026-08-29T11:50:00Z", "transfer_minutes": 15, "room_net": 209.71, "vat_rate": 13.5, "vat_amount": 28.31, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 238.02, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 238.02, "fx_rate": 1, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 238.02, "markup": 0, "commission_received": 25.16, "commission_shared": 12.58, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853375", "vcc_auth_amount": 263.02, "folio_amount": 238.02, "settled_amount": 238.02, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": null, "baseline_rate": 281.35, "market_rate": 272.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-28", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 281.35, "discount_pct": 15.4 }, { "id": "RS-8853285-1", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8853285", "duty_id": "D-513285", "layover_id": "L-513286", "crew_id": "IRE-1019", "crew_name": "G. Mulligan", "crew_rank": "ENG", "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": "released", "lead_time_days": 5, "booking_created_at": "2026-08-23T16:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-28T15:03:00Z", "duty_start_utc": "2026-08-28T14:05:00Z", "transfer_minutes": 22, "room_net": 263.29, "vat_rate": 20, "vat_amount": 52.66, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 315.95, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 266.26, "fx_rate": 1.186615, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 298.76, "markup": 17.19, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853285", "vcc_auth_amount": 340.95, "folio_amount": 315.95, "settled_amount": 315.95, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": 315.95, "baseline_rate": 418.62, "market_rate": 406.06, "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-28", "ingested_at": "2026-08-28T02:14:00Z", "version": 1, "public_rate": 418.62, "discount_pct": 24.53 }, { "id": "RS-8853706-2", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8853706", "duty_id": "D-513706", "layover_id": "L-513707", "crew_id": "IRE-1033", "crew_name": "O. Quinn", "crew_rank": "ENG", "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": "released", "lead_time_days": 3, "booking_created_at": "2026-08-24T01:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-28T00:18:00Z", "duty_start_utc": "2026-08-28T06:30:00Z", "transfer_minutes": 22, "room_net": 266.21, "vat_rate": 20, "vat_amount": 53.24, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 319.45, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 269.21, "fx_rate": 1.186615, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 319.45, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853706", "vcc_auth_amount": 344.45, "folio_amount": 319.45, "settled_amount": 319.45, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": 319.45, "baseline_rate": 418.62, "market_rate": 406.06, "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-27", "ingested_at": "2026-08-28T02:14:00Z", "version": 1, "public_rate": 418.62, "discount_pct": 23.69 }, { "id": "RS-8855085-1", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8855085", "duty_id": "D-515085", "layover_id": "L-515086", "crew_id": "FRA-1010", "crew_name": "B. Aubert", "crew_rank": "FO", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "released", "lead_time_days": 0.5, "booking_created_at": "2026-08-28T02:00:00Z", "checkin_time": "14:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-28T13:15:00Z", "duty_start_utc": "2026-08-28T09:15:00Z", "transfer_minutes": 10, "room_net": 286.78, "vat_rate": 10, "vat_amount": 28.68, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 318.76, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 318.76, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 285.07, "markup": 33.69, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855085", "vcc_auth_amount": 343.76, "folio_amount": 318.76, "settled_amount": 318.76, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": null, "baseline_rate": 353.98, "market_rate": 343.36, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "MRS-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 17.15, "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": 353.98, "discount_pct": 9.95 }, { "id": "RS-8854839-1", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8854839", "duty_id": "D-514839", "layover_id": "L-514840", "crew_id": "FRA-1046", "crew_name": "E. Aubert", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "MAD", "country": "ES", "property_id": "P-135", "hotel": "Melia Barajas", "chain": "Melia", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "irops", "night_status": "released", "lead_time_days": 0.5, "booking_created_at": "2026-08-26T04:00:00Z", "checkin_time": "16:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-26T15:11:00Z", "duty_start_utc": "2026-08-26T09:15:00Z", "transfer_minutes": 14, "room_net": 333.26, "vat_rate": 10, "vat_amount": 33.33, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 366.59, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 366.59, "fx_rate": 1, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 328, "markup": 38.59, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854839", "vcc_auth_amount": 391.59, "folio_amount": 366.59, "settled_amount": 366.59, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": null, "baseline_rate": 414.04, "market_rate": 401.62, "rate_honoured": 1, "customer": "DHL", "cost_centre": "CDG-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 11, "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-26", "ingested_at": "2026-08-26T02:14:00Z", "version": 1, "public_rate": 414.04, "discount_pct": 11.46 }, { "id": "RS-8853596-2", "period": "2026-08", "night": "2026-08-25", "booking_id": "RS-8853596", "duty_id": "D-513596", "layover_id": "L-513597", "crew_id": "IRE-1073", "crew_name": "E. O Conaill", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "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": "gds", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 3, "booking_created_at": "2026-08-21T16:00:00Z", "checkin_time": "16:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-25T14:34:00Z", "duty_start_utc": "2026-08-25T09:15:00Z", "transfer_minutes": 51, "room_net": 271.99, "vat_rate": 13.5, "vat_amount": 36.72, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 308.71, "ancillaries": 24.08, "fee": 0, "currency_local": "EUR", "rate_paid_local": 308.71, "fx_rate": 1, "fx_date": "2026-08-25", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 308.71, "markup": 0, "commission_received": 31.48, "commission_shared": 15.74, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853596", "vcc_auth_amount": 357.79, "folio_amount": 332.79, "settled_amount": 332.79, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": null, "baseline_rate": 361.39, "market_rate": 350.55, "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-24", "ingested_at": "2026-08-25T02:14:00Z", "version": 1, "public_rate": 361.39, "discount_pct": 14.58 }, { "id": "RS-8853142-3", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8853142", "duty_id": "D-513142", "layover_id": "L-513143", "crew_id": "IRE-1015", "crew_name": "E. Kavanagh", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "EMA", "country": "GB", "property_id": "P-104", "hotel": "Hilton East Midlands", "chain": "Hilton", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 2, "booking_created_at": "2026-08-20T16:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-24T15:10:00Z", "duty_start_utc": "2026-08-24T14:05:00Z", "transfer_minutes": 15, "room_net": 278.49, "vat_rate": 20, "vat_amount": 55.7, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 334.19, "ancillaries": 25.26, "fee": 0, "currency_local": "GBP", "rate_paid_local": 281.29, "fx_rate": 1.188078, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 334.19, "markup": 0, "commission_received": 25.69, "commission_shared": 12.85, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853142", "vcc_auth_amount": 384.45, "folio_amount": 359.45, "settled_amount": 359.45, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": null, "baseline_rate": 394.33, "market_rate": 382.5, "rate_honoured": 1, "customer": "ASL own pax", "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-22", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 394.33, "discount_pct": 15.25 }, { "id": "RS-8854012-1", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8854012", "duty_id": "D-514012", "layover_id": "L-514013", "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": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 2, "booking_created_at": "2026-08-22T01:15:00Z", "checkin_time": "01:15", "checkout_time": "08:15", "duty_end_utc": "2026-08-24T00:18:00Z", "duty_start_utc": "2026-08-24T06:30:00Z", "transfer_minutes": 22, "room_net": 278.01, "vat_rate": 6, "vat_amount": 16.68, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 298.69, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 298.69, "fx_rate": 1, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 298.69, "markup": 0, "commission_received": 24.02, "commission_shared": 12.01, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854012", "vcc_auth_amount": 323.69, "folio_amount": 298.69, "settled_amount": 298.69, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": null, "baseline_rate": 358.41, "market_rate": 347.66, "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-24", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 358.41, "discount_pct": 16.66 }, { "id": "RS-8854535-1", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8854535", "duty_id": "D-514535", "layover_id": "L-514536", "crew_id": "BEL-1078", "crew_name": "H. Claes", "crew_rank": "CC", "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": "C-123", "allotment_id": "A-123", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "released", "lead_time_days": 0, "booking_created_at": "2026-08-24T21:00:00Z", "checkin_time": "22:30", "checkout_time": "04:30", "duty_end_utc": "2026-08-24T21:07:00Z", "duty_start_utc": "2026-08-24T14:05:00Z", "transfer_minutes": 48, "room_net": 358.13, "vat_rate": 5, "vat_amount": 17.91, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 381.04, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1481.27, "fx_rate": 0.257238, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 381.04, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854535", "vcc_auth_amount": 321.08, "folio_amount": 381.04, "settled_amount": 381.04, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": 296.08, "baseline_rate": 389.8, "market_rate": 378.11, "rate_honoured": 0, "customer": "UPS", "cost_centre": "BRU-CREW", "change_type": "modify_in_place", "change_source": "crew_app", "change_cost": 17.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": 3.7, "complaint_theme": null, "source_file_id": "AIMS-2026-08-24", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 389.8, "discount_pct": 2.25 }, { "id": "RS-8852960-1", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8852960", "duty_id": "D-512960", "layover_id": "L-512961", "crew_id": "IRE-S203", "crew_name": "O. Healy", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "STN", "country": "GB", "property_id": "P-116", "hotel": "Hampton by Hilton Stansted", "chain": "Hilton", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "training", "night_status": "released", "lead_time_days": 2, "booking_created_at": "2026-08-21T01:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-23T00:22:00Z", "duty_start_utc": "2026-08-23T14:05:00Z", "transfer_minutes": 18, "room_net": 246.61, "vat_rate": 20, "vat_amount": 49.32, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 295.93, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 249.63, "fx_rate": 1.185467, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 267.82, "markup": 28.11, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852960", "vcc_auth_amount": 320.93, "folio_amount": 295.93, "settled_amount": 295.93, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": null, "baseline_rate": 365.58, "market_rate": 354.61, "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-23", "ingested_at": "2026-08-23T02:14:00Z", "version": 1, "public_rate": 365.58, "discount_pct": 19.05 }, { "id": "RS-8854189-1", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8854189", "duty_id": "D-514189", "layover_id": "L-514190", "crew_id": "BEL-1033", "crew_name": "D. Lambert", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "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": "gds", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 3, "booking_created_at": "2026-08-20T01:15:00Z", "checkin_time": "01:15", "checkout_time": "08:15", "duty_end_utc": "2026-08-23T00:00:00Z", "duty_start_utc": "2026-08-23T09:15:00Z", "transfer_minutes": 44, "room_net": 210.26, "vat_rate": 15, "vat_amount": 31.54, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 241.8, "ancillaries": 0, "fee": 15.97, "currency_local": "ZAR", "rate_paid_local": 4830.2, "fx_rate": 0.05006, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 241.8, "markup": 0, "commission_received": 20.77, "commission_shared": 10.39, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854189", "vcc_auth_amount": 266.8, "folio_amount": 241.8, "settled_amount": 241.8, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": null, "baseline_rate": 286.4, "market_rate": 277.81, "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": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-23T02:14:00Z", "version": 1, "public_rate": 286.4, "discount_pct": 15.57 }, { "id": "RS-8853495-3", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8853495", "duty_id": "D-513495", "layover_id": "L-513496", "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": "STN", "country": "GB", "property_id": "P-115", "hotel": "Radisson Blu Stansted", "chain": "Radisson", "contract_id": "C-115", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 1, "booking_created_at": "2026-08-19T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-22T04:43:00Z", "duty_start_utc": "2026-08-22T06:30:00Z", "transfer_minutes": 22, "room_net": 264.22, "vat_rate": 20, "vat_amount": 52.84, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 317.06, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 267.29, "fx_rate": 1.186214, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 317.06, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853495", "vcc_auth_amount": 342.06, "folio_amount": 317.06, "settled_amount": 317.06, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": 317.06, "baseline_rate": 373.06, "market_rate": 361.87, "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-20", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 373.06, "discount_pct": 15.01 }, { "id": "RS-8853484-1", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8853484", "duty_id": "D-513484", "layover_id": "L-513485", "crew_id": "IRE-1085", "crew_name": "P. O Conaill", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 9, "booking_created_at": "2026-08-12T16:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-21T15:14:00Z", "duty_start_utc": "2026-08-21T11:50:00Z", "transfer_minutes": 11, "room_net": 248.15, "vat_rate": 20, "vat_amount": 49.63, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 297.78, "ancillaries": 24.09, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 250.89, "fx_rate": 1.186893, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 275.06, "markup": 22.72, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853484", "vcc_auth_amount": 346.87, "folio_amount": 321.87, "settled_amount": 321.87, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 297.78, "baseline_rate": 383.16, "market_rate": 371.67, "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-21", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 383.16, "discount_pct": 22.28 }, { "id": "RS-8854703-2", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8854703", "duty_id": "D-514703", "layover_id": "L-514704", "crew_id": "FRA-1065", "crew_name": "R. Fontaine", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "MAD", "country": "ES", "property_id": "P-136", "hotel": "Novotel Madrid Barajas", "chain": "Accor", "contract_id": "C-136", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 9, "booking_created_at": "2026-08-10T15:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-20T14:02:00Z", "duty_start_utc": "2026-08-20T09:15:00Z", "transfer_minutes": 23, "room_net": 250.7, "vat_rate": 10, "vat_amount": 25.07, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 275.77, "ancillaries": 17.24, "fee": 0, "currency_local": "EUR", "rate_paid_local": 275.77, "fx_rate": 1, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 256.57, "markup": 19.2, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854703", "vcc_auth_amount": 318.01, "folio_amount": 293.01, "settled_amount": 293.01, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": 275.77, "baseline_rate": 384.89, "market_rate": 373.34, "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-19", "ingested_at": "2026-08-20T02:14:00Z", "version": 1, "public_rate": 384.89, "discount_pct": 28.35 }, { "id": "RS-8853208-1", "period": "2026-08", "night": "2026-08-19", "booking_id": "RS-8853208", "duty_id": "D-513208", "layover_id": "L-513209", "crew_id": "IRE-1088", "crew_name": "K. 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-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": "released", "lead_time_days": 0.5, "booking_created_at": "2026-08-18T17:40:00Z", "checkin_time": "05:40", "checkout_time": "08:15", "duty_end_utc": "2026-08-19T04:14:00Z", "duty_start_utc": "2026-08-19T09:15:00Z", "transfer_minutes": 51, "room_net": 273.47, "vat_rate": 13.5, "vat_amount": 36.92, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 310.39, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 310.39, "fx_rate": 1, "fx_date": "2026-08-19", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 276.21, "markup": 34.18, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853208", "vcc_auth_amount": 335.39, "folio_amount": 310.39, "settled_amount": 310.39, "settled_at": "2026-08-19T23:59:00Z", "contracted_rate": null, "baseline_rate": 353.8, "market_rate": 343.19, "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-19", "ingested_at": "2026-08-19T02:14:00Z", "version": 1, "public_rate": 353.8, "discount_pct": 12.27 }, { "id": "RS-8853362-2", "period": "2026-08", "night": "2026-08-19", "booking_id": "RS-8853362", "duty_id": "D-513362", "layover_id": "L-513363", "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": "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": "released", "lead_time_days": 9, "booking_created_at": "2026-08-09T01:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-19T00:18:00Z", "duty_start_utc": "2026-08-19T11:50: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": 10.58, "fee": 0, "currency_local": "EUR", "rate_paid_local": 260.46, "fx_rate": 1, "fx_date": "2026-08-19", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 245.09, "markup": 15.37, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853362", "vcc_auth_amount": 296.04, "folio_amount": 271.04, "settled_amount": 271.04, "settled_at": "2026-08-19T23:59:00Z", "contracted_rate": 260.46, "baseline_rate": 388.29, "market_rate": 376.64, "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-18", "ingested_at": "2026-08-19T02:14:00Z", "version": 1, "public_rate": 388.29, "discount_pct": 32.92 }, { "id": "RS-8855037-2", "period": "2026-08", "night": "2026-08-18", "booking_id": "RS-8855037", "duty_id": "D-515037", "layover_id": "L-515038", "crew_id": "FRA-1053", "crew_name": "Y. Fontaine", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "MAD", "country": "ES", "property_id": "P-135", "hotel": "Melia Barajas", "chain": "Melia", "contract_id": "C-135", "allotment_id": "A-135", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "released", "lead_time_days": 0.5, "booking_created_at": "2026-08-17T04:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-18T15:11:00Z", "duty_start_utc": "2026-08-18T09:15:00Z", "transfer_minutes": 14, "room_net": 267.14, "vat_rate": 10, "vat_amount": 26.71, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 293.85, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 293.85, "fx_rate": 1, "fx_date": "2026-08-18", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 293.85, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855037", "vcc_auth_amount": 318.85, "folio_amount": 293.85, "settled_amount": 293.85, "settled_at": "2026-08-18T23:59:00Z", "contracted_rate": 293.85, "baseline_rate": 421.13, "market_rate": 408.5, "rate_honoured": 1, "customer": "ASL own pax", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 185.55, "modify_attempted": 1, "modify_failed_reason": "no_availability", "room_lost": 1, "exception_opened_at": "2026-08-18T11:40:00Z", "exception_resolved_at": "2026-08-18T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "matched", "recon_amount": 0, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-17", "ingested_at": "2026-08-18T02:14:00Z", "version": 1, "public_rate": 421.13, "discount_pct": 30.22 }, { "id": "RS-8853012-2", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8853012", "duty_id": "D-513012", "layover_id": "L-513013", "crew_id": "IRE-1037", "crew_name": "M. O Conaill", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-101", "hotel": "Clayton Hotel Dublin Airport", "chain": "Dalata", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "released", "lead_time_days": 0.5, "booking_created_at": "2026-08-15T03:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-16T14:10:00Z", "duty_start_utc": "2026-08-16T11:50:00Z", "transfer_minutes": 15, "room_net": 222.42, "vat_rate": 13.5, "vat_amount": 30.03, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 252.45, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 252.45, "fx_rate": 1, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 227.6, "markup": 24.85, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853012", "vcc_auth_amount": 277.45, "folio_amount": 252.45, "settled_amount": 252.45, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": null, "baseline_rate": 289.24, "market_rate": 280.56, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "cancel_rebook", "change_source": "travel_desk", "change_cost": 231.26, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 0, "exception_opened_at": "2026-08-16T17:22:00Z", "exception_resolved_at": "2026-08-16T07: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-15", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 289.24, "discount_pct": 12.72 }, { "id": "RS-8853103-3", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8853103", "duty_id": "D-513103", "layover_id": "L-513104", "crew_id": "IRE-1082", "crew_name": "J. Cassidy", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "EMA", "country": "GB", "property_id": "P-104", "hotel": "Hilton East Midlands", "chain": "Hilton", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 9, "booking_created_at": "2026-08-05T05:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-16T04:50:00Z", "duty_start_utc": "2026-08-16T11:50:00Z", "transfer_minutes": 15, "room_net": 229.55, "vat_rate": 20, "vat_amount": 45.91, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 275.46, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 232.73, "fx_rate": 1.183628, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 249.92, "markup": 25.54, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853103", "vcc_auth_amount": 300.46, "folio_amount": 275.46, "settled_amount": 275.46, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": null, "baseline_rate": 348.81, "market_rate": 338.35, "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-14", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 348.81, "discount_pct": 21.03 }, { "id": "RS-8853251-2", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8853251", "duty_id": "D-513251", "layover_id": "L-513252", "crew_id": "IRE-1015", "crew_name": "E. Kavanagh", "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": "bedbank", "duty_reason": "irops", "night_status": "released", "lead_time_days": 0, "booking_created_at": "2026-08-15T14:30:00Z", "checkin_time": "16:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-16T14:41:00Z", "duty_start_utc": "2026-08-16T09:15:00Z", "transfer_minutes": 44, "room_net": 253.53, "vat_rate": 7, "vat_amount": 17.75, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 276.28, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 276.28, "fx_rate": 1, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 250.8, "markup": 25.48, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853251", "vcc_auth_amount": 301.28, "folio_amount": 276.28, "settled_amount": 276.28, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": null, "baseline_rate": 312.94, "market_rate": 303.55, "rate_honoured": 1, "customer": "DHL", "cost_centre": "DUB-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 11.86, "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-15", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 312.94, "discount_pct": 11.71 }, { "id": "RS-8855140-2", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8855140", "duty_id": "D-515140", "layover_id": "L-515141", "crew_id": "FRA-1018", "crew_name": "A. Roussel", "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-128", "hotel": "Ibis Paris CDG", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "released", "lead_time_days": 9, "booking_created_at": "2026-08-06T22:30:00Z", "checkin_time": "22:30", "checkout_time": "08:15", "duty_end_utc": "2026-08-16T21:25:00Z", "duty_start_utc": "2026-08-16T14:05:00Z", "transfer_minutes": 30, "room_net": 253.3, "vat_rate": 10, "vat_amount": 25.33, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 283.83, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 283.83, "fx_rate": 1, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 254.63, "markup": 29.2, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855140", "vcc_auth_amount": 308.83, "folio_amount": 283.83, "settled_amount": 283.83, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": null, "baseline_rate": 356.84, "market_rate": 346.13, "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-15", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 356.84, "discount_pct": 20.46 }, { "id": "RS-8854414-4", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8854414", "duty_id": "D-514414", "layover_id": "L-514415", "crew_id": "BEL-1016", "crew_name": "G. Maes", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "JNB", "country": "ZA", "property_id": "P-124", "hotel": "Protea OR Tambo", "chain": "Marriott", "contract_id": "C-124", "allotment_id": "A-124", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "standby", "night_status": "released", "lead_time_days": 2, "booking_created_at": "2026-08-08T15:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-13T13:39:00Z", "duty_start_utc": "2026-08-13T09:15:00Z", "transfer_minutes": 46, "room_net": 201.03, "vat_rate": 15, "vat_amount": 30.16, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 231.19, "ancillaries": 0, "fee": 0, "currency_local": "ZAR", "rate_paid_local": 4598.97, "fx_rate": 0.05027, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 215.02, "markup": 16.17, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854414", "vcc_auth_amount": 256.19, "folio_amount": null, "settled_amount": null, "settled_at": null, "contracted_rate": 231.19, "baseline_rate": 326.93, "market_rate": 317.12, "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": "awaiting_folio", "recon_amount": 0, "crew_rating": 2.4, "complaint_theme": "transfer", "source_file_id": "AIMS-2026-08-10", "ingested_at": "2026-08-13T02:14:00Z", "version": 1, "public_rate": 326.93, "discount_pct": 29.28 }, { "id": "RS-8854921-3", "period": "2026-08", "night": "2026-08-12", "booking_id": "RS-8854921", "duty_id": "D-514921", "layover_id": "L-514922", "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": "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": "released", "lead_time_days": 1, "booking_created_at": "2026-08-09T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-12T14:03:00Z", "duty_start_utc": "2026-08-12T09:15:00Z", "transfer_minutes": 22, "room_net": 262.29, "vat_rate": 10, "vat_amount": 26.23, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 291.4, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 291.4, "fx_rate": 1, "fx_date": "2026-08-12", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 266.81, "markup": 24.59, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854921", "vcc_auth_amount": 316.4, "folio_amount": 291.4, "settled_amount": 291.4, "settled_at": "2026-08-12T23:59:00Z", "contracted_rate": null, "baseline_rate": 369.8, "market_rate": 358.71, "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-10", "ingested_at": "2026-08-12T02:14:00Z", "version": 1, "public_rate": 369.8, "discount_pct": 21.2 }, { "id": "RS-8854945-1", "period": "2026-08", "night": "2026-08-12", "booking_id": "RS-8854945", "duty_id": "D-514945", "layover_id": "L-514946", "crew_id": "FRA-1056", "crew_name": "B. Chevalier", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "CDG", "country": "FR", "property_id": "P-127", "hotel": "Pullman Paris CDG", "chain": "Accor", "contract_id": "C-127", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 3, "booking_created_at": "2026-08-09T01:15:00Z", "checkin_time": "01:15", "checkout_time": "04:30", "duty_end_utc": "2026-08-12T00:26:00Z", "duty_start_utc": "2026-08-12T09:15:00Z", "transfer_minutes": 14, "room_net": 263.02, "vat_rate": 10, "vat_amount": 26.3, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 294.52, "ancillaries": 10.98, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 294.52, "fx_rate": 1, "fx_date": "2026-08-12", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 271.58, "markup": 22.94, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854945", "vcc_auth_amount": 330.5, "folio_amount": 305.5, "settled_amount": 305.5, "settled_at": "2026-08-12T23:59:00Z", "contracted_rate": 294.52, "baseline_rate": 409.38, "market_rate": 397.1, "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": 3.4, "complaint_theme": null, "source_file_id": "AIMS-2026-08-12", "ingested_at": "2026-08-12T02:14:00Z", "version": 1, "public_rate": 409.38, "discount_pct": 28.06 }, { "id": "RS-8853882-1", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8853882", "duty_id": "D-513882", "layover_id": "L-513883", "crew_id": "BEL-1037", "crew_name": "L. Janssens", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "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": "released", "lead_time_days": 9, "booking_created_at": "2026-08-02T15:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-11T13:41:00Z", "duty_start_utc": "2026-08-11T06:30:00Z", "transfer_minutes": 44, "room_net": 208.63, "vat_rate": 15, "vat_amount": 31.29, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 239.92, "ancillaries": 24.15, "fee": 15.97, "currency_local": "ZAR", "rate_paid_local": 4759.75, "fx_rate": 0.050406, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 224.44, "markup": 15.48, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853882", "vcc_auth_amount": 289.07, "folio_amount": 264.07, "settled_amount": 264.07, "settled_at": "2026-08-11T23:59:00Z", "contracted_rate": 239.92, "baseline_rate": 339.16, "market_rate": 328.99, "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-11", "ingested_at": "2026-08-11T02:14:00Z", "version": 1, "public_rate": 339.16, "discount_pct": 29.26 }, { "id": "RS-8854903-1", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8854903", "duty_id": "D-514903", "layover_id": "L-514904", "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-133", "hotel": "Pullman Toulouse Airport", "chain": "Accor", "contract_id": "C-133", "allotment_id": "A-133", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 3, "booking_created_at": "2026-08-07T16:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-10T15:03:00Z", "duty_start_utc": "2026-08-10T11:50:00Z", "transfer_minutes": 22, "room_net": 224.9, "vat_rate": 10, "vat_amount": 22.49, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 250.27, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 250.27, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 230.86, "markup": 19.41, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854903", "vcc_auth_amount": 275.27, "folio_amount": 250.27, "settled_amount": 250.27, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": 250.27, "baseline_rate": 324.44, "market_rate": 314.71, "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-10", "ingested_at": "2026-08-10T02:14:00Z", "version": 1, "public_rate": 324.44, "discount_pct": 22.86 }, { "id": "RS-8853637-4", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8853637", "duty_id": "D-513637", "layover_id": "L-513638", "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-108", "hotel": "Leonardo Hotel Koln", "chain": "Leonardo", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "released", "lead_time_days": 9, "booking_created_at": "2026-07-28T15:00:00Z", "checkin_time": "15:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-09T14:09:00Z", "duty_start_utc": "2026-08-09T09:15:00Z", "transfer_minutes": 16, "room_net": 240.26, "vat_rate": 7, "vat_amount": 16.82, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 262.08, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 262.08, "fx_rate": 1, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 235.57, "markup": 26.51, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853637", "vcc_auth_amount": 287.08, "folio_amount": 262.08, "settled_amount": 262.08, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": null, "baseline_rate": 325.13, "market_rate": 315.38, "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": 2, "complaint_theme": "room", "source_file_id": "AIMS-2026-08-06", "ingested_at": "2026-08-09T02:14:00Z", "version": 1, "public_rate": 325.13, "discount_pct": 19.39 }, { "id": "RS-8855026-1", "period": "2026-08", "night": "2026-08-09", "booking_id": "RS-8855026", "duty_id": "D-515026", "layover_id": "L-515027", "crew_id": "FRA-1029", "crew_name": "L. Fontaine", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "CDG", "station": "LYS", "country": "FR", "property_id": "P-130", "hotel": "Comfort Hotel Lyon", "chain": "Choice", "contract_id": "C-130", "allotment_id": "A-130", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "released", "lead_time_days": 9, "booking_created_at": "2026-07-31T15:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-09T14:15:00Z", "duty_start_utc": "2026-08-09T11:50:00Z", "transfer_minutes": 10, "room_net": 246.54, "vat_rate": 10, "vat_amount": 24.65, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 274.49, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 274.49, "fx_rate": 1, "fx_date": "2026-08-09", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 274.49, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855026", "vcc_auth_amount": 299.49, "folio_amount": 274.49, "settled_amount": 274.49, "settled_at": "2026-08-09T23:59:00Z", "contracted_rate": 274.49, "baseline_rate": 326.75, "market_rate": 316.95, "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-09", "ingested_at": "2026-08-09T02:14:00Z", "version": 1, "public_rate": 326.75, "discount_pct": 15.99 }, { "id": "RS-8853938-1", "period": "2026-08", "night": "2026-08-07", "booking_id": "RS-8853938", "duty_id": "D-513938", "layover_id": "L-513939", "crew_id": "BEL-1042", "crew_name": "L. Claes", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "CDG", "country": "FR", "property_id": "P-127", "hotel": "Pullman Paris CDG", "chain": "Accor", "contract_id": "C-127", "allotment_id": "A-127", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "released", "lead_time_days": 1, "booking_created_at": "2026-08-06T22:30:00Z", "checkin_time": "22:30", "checkout_time": "04:30", "duty_end_utc": "2026-08-07T21:41:00Z", "duty_start_utc": "2026-08-07T14:05:00Z", "transfer_minutes": 14, "room_net": 262.97, "vat_rate": 10, "vat_amount": 26.3, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 294.47, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 294.47, "fx_rate": 1, "fx_date": "2026-08-07", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 276.27, "markup": 18.2, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853938", "vcc_auth_amount": 319.47, "folio_amount": 294.47, "settled_amount": 294.47, "settled_at": "2026-08-07T23:59:00Z", "contracted_rate": 294.47, "baseline_rate": 383.28, "market_rate": 371.78, "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-07", "ingested_at": "2026-08-07T02:14:00Z", "version": 1, "public_rate": 383.28, "discount_pct": 23.17 }, { "id": "RS-8853813-2", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8853813", "duty_id": "D-513813", "layover_id": "L-513814", "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": "training", "night_status": "released", "lead_time_days": 1, "booking_created_at": "2026-08-04T15:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-06T14:02:00Z", "duty_start_utc": "2026-08-06T09:15:00Z", "transfer_minutes": 23, "room_net": 233.5, "vat_rate": 13.5, "vat_amount": 31.52, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 265.02, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 265.02, "fx_rate": 1, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 245.48, "markup": 19.54, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853813", "vcc_auth_amount": 290.02, "folio_amount": 265.02, "settled_amount": 265.02, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": 265.02, "baseline_rate": 368.9, "market_rate": 357.83, "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-05", "ingested_at": "2026-08-06T02:14:00Z", "version": 1, "public_rate": 368.9, "discount_pct": 28.16 }, { "id": "RS-8855011-2", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8855011", "duty_id": "D-515011", "layover_id": "L-515012", "crew_id": "FRA-1024", "crew_name": "H. Moreau", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "CDG", "country": "FR", "property_id": "P-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": "released", "lead_time_days": 9, "booking_created_at": "2026-07-27T22:30:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-06T21:41:00Z", "duty_start_utc": "2026-08-06T11:50:00Z", "transfer_minutes": 14, "room_net": 262.76, "vat_rate": 10, "vat_amount": 26.28, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 294.24, "ancillaries": 18.61, "fee": 0, "currency_local": "EUR", "rate_paid_local": 294.24, "fx_rate": 1, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 273.66, "markup": 20.58, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855011", "vcc_auth_amount": 337.85, "folio_amount": 312.85, "settled_amount": 312.85, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": 294.24, "baseline_rate": 429.42, "market_rate": 416.54, "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-05", "ingested_at": "2026-08-06T02:14:00Z", "version": 1, "public_rate": 429.42, "discount_pct": 31.48 }, { "id": "RS-8855158-3", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8855158", "duty_id": "D-515158", "layover_id": "L-515159", "crew_id": "FRA-1087", "crew_name": "P. Girard", "crew_rank": "CC", "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": "released", "lead_time_days": 3, "booking_created_at": "2026-08-01T14:00:00Z", "checkin_time": "14:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-06T13:07:00Z", "duty_start_utc": "2026-08-06T11:50:00Z", "transfer_minutes": 18, "room_net": 242.85, "vat_rate": 10, "vat_amount": 24.28, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 270.43, "ancillaries": 25.5, "fee": 0, "currency_local": "EUR", "rate_paid_local": 270.43, "fx_rate": 1, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 270.43, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855158", "vcc_auth_amount": 320.93, "folio_amount": 295.93, "settled_amount": 295.93, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": 270.43, "baseline_rate": 376.75, "market_rate": 365.45, "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-04", "ingested_at": "2026-08-06T02:14:00Z", "version": 1, "public_rate": 376.75, "discount_pct": 28.22 }, { "id": "RS-8853440-1", "period": "2026-08", "night": "2026-08-05", "booking_id": "RS-8853440", "duty_id": "D-513440", "layover_id": "L-513441", "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": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 3, "booking_created_at": "2026-08-02T15:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-05T14:03:00Z", "duty_start_utc": "2026-08-05T09:15:00Z", "transfer_minutes": 22, "room_net": 279.11, "vat_rate": 6, "vat_amount": 16.75, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 299.86, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 299.86, "fx_rate": 1, "fx_date": "2026-08-05", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 267.16, "markup": 32.7, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853440", "vcc_auth_amount": 324.86, "folio_amount": 299.86, "settled_amount": 299.86, "settled_at": "2026-08-05T23:59:00Z", "contracted_rate": null, "baseline_rate": 371.18, "market_rate": 360.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-05", "ingested_at": "2026-08-05T02:14:00Z", "version": 1, "public_rate": 371.18, "discount_pct": 19.21 }, { "id": "RS-8853699-1", "period": "2026-08", "night": "2026-08-05", "booking_id": "RS-8853699", "duty_id": "D-513699", "layover_id": "L-513700", "crew_id": "IRE-1073", "crew_name": "E. O Conaill", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "BHX", "country": "GB", "property_id": "P-113", "hotel": "Novotel Birmingham Airport", "chain": "Accor", "contract_id": "C-113", "allotment_id": "A-113", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "released", "lead_time_days": 5, "booking_created_at": "2026-07-31T22:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-05T21:31:00Z", "duty_start_utc": "2026-08-05T11:50:00Z", "transfer_minutes": 24, "room_net": 229.64, "vat_rate": 20, "vat_amount": 45.93, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 275.57, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 231.83, "fx_rate": 1.188694, "fx_date": "2026-08-05", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 258.03, "markup": 17.54, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853699", "vcc_auth_amount": 300.57, "folio_amount": 275.57, "settled_amount": 275.57, "settled_at": "2026-08-05T23:59:00Z", "contracted_rate": 275.57, "baseline_rate": 396.24, "market_rate": 384.35, "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-05", "ingested_at": "2026-08-05T02:14:00Z", "version": 1, "public_rate": 396.24, "discount_pct": 30.45 }, { "id": "RS-8853697-1", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8853697", "duty_id": "D-513697", "layover_id": "L-513698", "crew_id": "IRE-1012", "crew_name": "G. Byrne", "crew_rank": "CPT", "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": "A-114", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "released", "lead_time_days": 3, "booking_created_at": "2026-08-01T22:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-04T21:32:00Z", "duty_start_utc": "2026-08-04T09:15:00Z", "transfer_minutes": 23, "room_net": 235.14, "vat_rate": 20, "vat_amount": 47.03, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 282.17, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 237.52, "fx_rate": 1.187978, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 263.09, "markup": 19.08, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853697", "vcc_auth_amount": 307.17, "folio_amount": 282.17, "settled_amount": 282.17, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": 282.17, "baseline_rate": 396.27, "market_rate": 384.38, "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-04T02:14:00Z", "version": 1, "public_rate": 396.27, "discount_pct": 28.79 }, { "id": "RS-8853847-1", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8853847", "duty_id": "D-513847", "layover_id": "L-513848", "crew_id": "BEL-1017", "crew_name": "M. Willems", "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": "released", "lead_time_days": 2, "booking_created_at": "2026-08-01T16:00:00Z", "checkin_time": "16:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-03T15:02:00Z", "duty_start_utc": "2026-08-03T14:05:00Z", "transfer_minutes": 23, "room_net": 256.49, "vat_rate": 6, "vat_amount": 15.39, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 275.88, "ancillaries": 27.82, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 275.88, "fx_rate": 1, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 275.88, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853847", "vcc_auth_amount": 328.7, "folio_amount": 303.7, "settled_amount": 303.7, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": 275.88, "baseline_rate": 384.47, "market_rate": 372.94, "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": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 384.47, "discount_pct": 28.24 } ] }