{ "metric": "open_items", "label": "Open items", "note": "Nights carrying an amount that is not yet agreed. Shown outside the total, not inside it.", "table": "room_night", "sort": null, "dir": "desc", "filters": {}, "total": 79, "sums": { "public_rate": 29327.42, "rate_paid": 23043.34 }, "rows": [ { "id": "RS-8853067-1", "period": "2026-08", "night": "2026-08-31", "booking_id": "RS-8853067", "duty_id": "D-513067", "layover_id": "L-513068", "crew_id": "IRE-1034", "crew_name": "R. Cassidy", "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-116", "hotel": "Hampton by Hilton Stansted", "chain": "Hilton", "contract_id": "C-116", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 3, "booking_created_at": "2026-08-28T15:00:00Z", "checkin_time": "15:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-31T14:07:00Z", "duty_start_utc": "2026-08-31T09:15:00Z", "transfer_minutes": 18, "room_net": 254.42, "vat_rate": 20, "vat_amount": 50.88, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 305.3, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 257.1, "fx_rate": 1.187495, "fx_date": "2026-08-31", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 286.03, "markup": 19.27, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853067", "vcc_auth_amount": 330.3, "folio_amount": 482.8, "settled_amount": 482.8, "settled_at": "2026-08-31T23:59:00Z", "contracted_rate": 305.3, "baseline_rate": 423.39, "market_rate": 410.69, "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": "variance", "recon_amount": 177.5, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-31", "ingested_at": "2026-08-31T02:14:00Z", "version": 1, "public_rate": 423.39, "discount_pct": 27.89 }, { "id": "RS-8854547-3", "period": "2026-08", "night": "2026-08-31", "booking_id": "RS-8854547", "duty_id": "D-514547", "layover_id": "L-514548", "crew_id": "BEL-1048", "crew_name": "T. Vermeulen", "crew_rank": "CC", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-27T05:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-31T04:51:00Z", "duty_start_utc": "2026-08-31T14:05:00Z", "transfer_minutes": 14, "room_net": 290.05, "vat_rate": 10, "vat_amount": 29.01, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 324.26, "ancillaries": 34.41, "fee": 0, "currency_local": "EUR", "rate_paid_local": 324.26, "fx_rate": 1, "fx_date": "2026-08-31", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 324.26, "markup": 0, "commission_received": 31.53, "commission_shared": 15.76, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854547", "vcc_auth_amount": 383.67, "folio_amount": 396.71, "settled_amount": 396.71, "settled_at": "2026-08-31T23:59:00Z", "contracted_rate": null, "baseline_rate": 391.34, "market_rate": 379.6, "rate_honoured": 1, "customer": "UPS", "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": "variance", "recon_amount": 38.04, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-31T02:14:00Z", "version": 1, "public_rate": 391.34, "discount_pct": 17.14 }, { "id": "RS-8853888-3", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8853888", "duty_id": "D-513888", "layover_id": "L-513889", "crew_id": "BEL-1058", "crew_name": "L. Declerck", "crew_rank": "CC", "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": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-27T16:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-30T15:12:00Z", "duty_start_utc": "2026-08-30T11:50:00Z", "transfer_minutes": 13, "room_net": 300.66, "vat_rate": 6, "vat_amount": 18.04, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4.24, "rate_paid": 322.94, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 322.94, "fx_rate": 1, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 322.94, "markup": 0, "commission_received": 34.89, "commission_shared": 17.45, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853888", "vcc_auth_amount": 347.94, "folio_amount": 646.46, "settled_amount": 646.46, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": null, "baseline_rate": 388.52, "market_rate": 376.86, "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": "variance", "recon_amount": 323.52, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-28", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 388.52, "discount_pct": 16.88 }, { "id": "RS-8854156-3", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8854156", "duty_id": "D-514156", "layover_id": "L-514157", "crew_id": "BEL-S217", "crew_name": "H. Declerck", "crew_rank": "STAFF", "traveller_type": "staff", "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": "C-127", "allotment_id": "A-127", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-23T15:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-30T14:11:00Z", "duty_start_utc": "2026-08-30T06:30:00Z", "transfer_minutes": 14, "room_net": 262.57, "vat_rate": 10, "vat_amount": 26.26, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 294.03, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 294.03, "fx_rate": 1, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 294.03, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854156", "vcc_auth_amount": 319.03, "folio_amount": 525.81, "settled_amount": 525.81, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": 294.03, "baseline_rate": 346.73, "market_rate": 336.33, "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": "variance", "recon_amount": 231.78, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-28", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 346.73, "discount_pct": 15.2 }, { "id": "RS-8854547-2", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8854547", "duty_id": "D-514547", "layover_id": "L-514548", "crew_id": "BEL-1048", "crew_name": "T. Vermeulen", "crew_rank": "CC", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-27T05:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-30T04:51:00Z", "duty_start_utc": "2026-08-30T06:30:00Z", "transfer_minutes": 14, "room_net": 256.45, "vat_rate": 10, "vat_amount": 25.64, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 287.29, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 287.29, "fx_rate": 1, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 287.29, "markup": 0, "commission_received": 27.93, "commission_shared": 13.97, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854547", "vcc_auth_amount": 312.29, "folio_amount": 402.59, "settled_amount": 402.59, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": null, "baseline_rate": 346.73, "market_rate": 336.33, "rate_honoured": 1, "customer": "UPS", "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": "variance", "recon_amount": 115.3, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 346.73, "discount_pct": 17.14 }, { "id": "RS-8854646-2", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8854646", "duty_id": "D-514646", "layover_id": "L-514647", "crew_id": "BEL-1063", "crew_name": "C. Peeters", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "DXB", "country": "AE", "property_id": "P-123", "hotel": "Le Meridien Dubai", "chain": "Marriott", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-24T15:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-30T13:37:00Z", "duty_start_utc": "2026-08-30T14:05:00Z", "transfer_minutes": 48, "room_net": 277.61, "vat_rate": 5, "vat_amount": 13.88, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 296.49, "ancillaries": 0, "fee": 0, "currency_local": "AED", "rate_paid_local": 1150.14, "fx_rate": 0.257786, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 296.49, "markup": 0, "commission_received": 29.34, "commission_shared": 14.67, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854646", "vcc_auth_amount": 321.49, "folio_amount": 487.15, "settled_amount": 487.15, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": null, "baseline_rate": 351.5, "market_rate": 340.96, "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": "disputed", "recon_amount": 190.66, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 351.5, "discount_pct": 15.65 }, { "id": "RS-8854971-2", "period": "2026-08", "night": "2026-08-30", "booking_id": "RS-8854971", "duty_id": "D-514971", "layover_id": "L-514972", "crew_id": "FRA-1068", "crew_name": "M. Chevalier", "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-127", "hotel": "Pullman Paris CDG", "chain": "Accor", "contract_id": "C-127", "allotment_id": "A-127", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 9, "booking_created_at": "2026-08-20T22:30:00Z", "checkin_time": "22:30", "checkout_time": "08:15", "duty_end_utc": "2026-08-30T21:41:00Z", "duty_start_utc": "2026-08-30T14:05:00Z", "transfer_minutes": 14, "room_net": 262.59, "vat_rate": 10, "vat_amount": 26.26, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 294.05, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 294.05, "fx_rate": 1, "fx_date": "2026-08-30", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 275.28, "markup": 18.77, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854971", "vcc_auth_amount": 319.05, "folio_amount": 468.68, "settled_amount": 468.68, "settled_at": "2026-08-30T23:59:00Z", "contracted_rate": 294.05, "baseline_rate": 346.73, "market_rate": 336.33, "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": "variance", "recon_amount": 174.63, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-30T02:14:00Z", "version": 1, "public_rate": 346.73, "discount_pct": 15.19 }, { "id": "RS-8853209-2", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8853209", "duty_id": "D-513209", "layover_id": "L-513210", "crew_id": "IRE-1050", "crew_name": "G. Doyle", "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-108", "hotel": "Leonardo Hotel Koln", "chain": "Leonardo", "contract_id": "C-108", "allotment_id": "A-108", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-28T03:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-29T14:09:00Z", "duty_start_utc": "2026-08-29T11:50:00Z", "transfer_minutes": 16, "room_net": 248.92, "vat_rate": 7, "vat_amount": 17.42, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 271.34, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 271.34, "fx_rate": 1, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 253.88, "markup": 17.46, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853209", "vcc_auth_amount": 296.34, "folio_amount": 319.29, "settled_amount": 319.29, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 271.34, "baseline_rate": 321.67, "market_rate": 312.02, "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": "variance", "recon_amount": 47.95, "crew_rating": 2, "complaint_theme": "noise", "source_file_id": "AIMS-2026-08-28", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 321.67, "discount_pct": 15.65 }, { "id": "RS-8853871-3", "period": "2026-08", "night": "2026-08-29", "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": "standby", "night_status": "occupied", "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-29T13:41:00Z", "duty_start_utc": "2026-08-29T14:05: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": 0, "fee": 0, "currency_local": "ZAR", "rate_paid_local": 4729.85, "fx_rate": 0.050397, "fx_date": "2026-08-29", "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": 263.37, "folio_amount": 423.59, "settled_amount": 423.59, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 238.37, "baseline_rate": 271.95, "market_rate": 263.79, "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": "variance", "recon_amount": 185.22, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-27", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 271.95, "discount_pct": 12.35 }, { "id": "RS-8854150-1", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8854150", "duty_id": "D-514150", "layover_id": "L-514151", "crew_id": "BEL-1010", "crew_name": "O. Declerck", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-29T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-29T13:03:00Z", "duty_start_utc": "2026-08-29T14:05:00Z", "transfer_minutes": 22, "room_net": 242.62, "vat_rate": 6, "vat_amount": 14.56, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 261.18, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 261.18, "fx_rate": 1, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 261.18, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854150", "vcc_auth_amount": 286.18, "folio_amount": 323.56, "settled_amount": 323.56, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 261.18, "baseline_rate": 309.38, "market_rate": 300.1, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "cancel_rebook", "change_source": "aims", "change_cost": 220.8, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 1, "exception_opened_at": "2026-08-29T11:40:00Z", "exception_resolved_at": "2026-08-29T12:55:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "disputed", "recon_amount": 62.38, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 309.38, "discount_pct": 15.58 }, { "id": "RS-8854887-2", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8854887", "duty_id": "D-514887", "layover_id": "L-514888", "crew_id": "FRA-1054", "crew_name": "T. Roussel", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "CDG", "country": "FR", "property_id": "P-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": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-23T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-29T14:11:00Z", "duty_start_utc": "2026-08-29T06:30:00Z", "transfer_minutes": 14, "room_net": 262.85, "vat_rate": 10, "vat_amount": 26.28, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 294.33, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 294.33, "fx_rate": 1, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 294.33, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854887", "vcc_auth_amount": 319.33, "folio_amount": 353.64, "settled_amount": 353.64, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 294.33, "baseline_rate": 344.3, "market_rate": 333.97, "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": "disputed", "recon_amount": 59.31, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-28", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 344.3, "discount_pct": 14.51 }, { "id": "RS-8855109-1", "period": "2026-08", "night": "2026-08-29", "booking_id": "RS-8855109", "duty_id": "D-515109", "layover_id": "L-515110", "crew_id": "FRA-1008", "crew_name": "A. Chevalier", "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": "C-133", "allotment_id": "A-133", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-27T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-29T14:03:00Z", "duty_start_utc": "2026-08-29T11:50:00Z", "transfer_minutes": 22, "room_net": 221.91, "vat_rate": 10, "vat_amount": 22.19, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 246.98, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 246.98, "fx_rate": 1, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 229.43, "markup": 17.55, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855109", "vcc_auth_amount": 271.98, "folio_amount": 579.79, "settled_amount": 579.79, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": 246.98, "baseline_rate": 299.65, "market_rate": 290.66, "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": "variance", "recon_amount": 332.81, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-29", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 299.65, "discount_pct": 17.58 }, { "id": "RS-8855151-2", "period": "2026-08", "night": "2026-08-29", "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": "occupied", "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-29T21:45:00Z", "duty_start_utc": "2026-08-29T11:50:00Z", "transfer_minutes": 10, "room_net": 248.46, "vat_rate": 10, "vat_amount": 24.85, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 276.19, "ancillaries": 25.88, "fee": 0, "currency_local": "EUR", "rate_paid_local": 276.19, "fx_rate": 1, "fx_date": "2026-08-29", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 249.13, "markup": 27.06, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855151", "vcc_auth_amount": 327.07, "folio_amount": 540.34, "settled_amount": 540.34, "settled_at": "2026-08-29T23:59:00Z", "contracted_rate": null, "baseline_rate": 312.4, "market_rate": 303.03, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "CDG-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 14.71, "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": "variance", "recon_amount": 238.27, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-28", "ingested_at": "2026-08-29T02:14:00Z", "version": 1, "public_rate": 312.4, "discount_pct": 11.59 }, { "id": "RS-8855175-4", "period": "2026-08", "night": "2026-08-28", "booking_id": "RS-8855175", "duty_id": "D-515175", "layover_id": "L-515176", "crew_id": "FRA-1022", "crew_name": "D. Aubert", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "MRS", "country": "FR", "property_id": "P-132", "hotel": "Holiday Inn Marseille", "chain": "IHG", "contract_id": "C-132", "allotment_id": "A-132", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-25T02:00:00Z", "checkin_time": "14:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-28T13:09:00Z", "duty_start_utc": "2026-08-28T14:05:00Z", "transfer_minutes": 16, "room_net": 238.1, "vat_rate": 10, "vat_amount": 23.81, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 265.21, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 265.21, "fx_rate": 1, "fx_date": "2026-08-28", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 265.21, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855175", "vcc_auth_amount": 290.21, "folio_amount": 422.68, "settled_amount": 422.68, "settled_at": "2026-08-28T23:59:00Z", "contracted_rate": 265.21, "baseline_rate": 336.44, "market_rate": 326.35, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LYS-CREW", "change_type": "cancel_rebook", "change_source": "crew_app", "change_cost": 166.25, "modify_attempted": 1, "modify_failed_reason": "hotel_cutoff", "room_lost": 0, "exception_opened_at": "2026-08-28T11:40:00Z", "exception_resolved_at": "2026-08-28T18:40:00Z", "resolved_by": "human", "sla_breached": 0, "recon_state": "variance", "recon_amount": 157.47, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-25", "ingested_at": "2026-08-28T02:14:00Z", "version": 1, "public_rate": 336.44, "discount_pct": 21.17 }, { "id": "RS-8853706-1", "period": "2026-08", "night": "2026-08-27", "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": "occupied", "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-27T00:18:00Z", "duty_start_utc": "2026-08-27T14:05: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": 15.97, "currency_local": "GBP", "rate_paid_local": 269.56, "fx_rate": 1.185081, "fx_date": "2026-08-27", "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": 369.28, "settled_amount": 369.28, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 319.45, "baseline_rate": 431.28, "market_rate": 418.34, "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": "disputed", "recon_amount": 49.83, "crew_rating": 1.7, "complaint_theme": "noise", "source_file_id": "AIMS-2026-08-27", "ingested_at": "2026-08-27T02:14:00Z", "version": 1, "public_rate": 431.28, "discount_pct": 25.93 }, { "id": "RS-8854121-4", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8854121", "duty_id": "D-514121", "layover_id": "L-514122", "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": "HKG", "country": "HK", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "chain": "Marriott", "contract_id": "C-121", "allotment_id": "A-121", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-23T22:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-27T21:11:00Z", "duty_start_utc": "2026-08-27T14:05:00Z", "transfer_minutes": 44, "room_net": 298.87, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 298.87, "ancillaries": 0, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2505.6, "fx_rate": 0.119281, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 275.92, "markup": 22.95, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854121", "vcc_auth_amount": 323.87, "folio_amount": 606.83, "settled_amount": 606.83, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 298.87, "baseline_rate": 425.32, "market_rate": 412.56, "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": "disputed", "recon_amount": 307.96, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-24", "ingested_at": "2026-08-27T02:14:00Z", "version": 1, "public_rate": 425.32, "discount_pct": 29.73 }, { "id": "RS-8854499-1", "period": "2026-08", "night": "2026-08-27", "booking_id": "RS-8854499", "duty_id": "D-514499", "layover_id": "L-514500", "crew_id": "BEL-1022", "crew_name": "D. Declerck", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "BRU", "country": "BE", "property_id": "P-117", "hotel": "Thon Hotel EU", "chain": "Thon", "contract_id": "C-117", "allotment_id": "A-117", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-26T16:00:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-27T15:07:00Z", "duty_start_utc": "2026-08-27T14:05:00Z", "transfer_minutes": 18, "room_net": 341.7, "vat_rate": 6, "vat_amount": 20.5, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4.24, "rate_paid": 366.44, "ancillaries": 32.32, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 366.44, "fx_rate": 1, "fx_date": "2026-08-27", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 343.95, "markup": 22.49, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854499", "vcc_auth_amount": 381.57, "folio_amount": 456.65, "settled_amount": 456.65, "settled_at": "2026-08-27T23:59:00Z", "contracted_rate": 324.25, "baseline_rate": 454, "market_rate": 440.38, "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": "variance", "recon_amount": 57.89, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-27", "ingested_at": "2026-08-27T02:14:00Z", "version": 1, "public_rate": 454, "discount_pct": 19.29 }, { "id": "RS-8853035-2", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8853035", "duty_id": "D-513035", "layover_id": "L-513036", "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": "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": "held", "night_status": "occupied", "lead_time_days": null, "booking_created_at": null, "checkin_time": null, "checkout_time": null, "duty_end_utc": "2026-08-26T15:07:00Z", "duty_start_utc": "2026-08-26T06:30:00Z", "transfer_minutes": 18, "room_net": 286.61, "vat_rate": 20, "vat_amount": 57.32, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 343.93, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 290.13, "fx_rate": 1.185423, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 309.67, "markup": 34.26, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853035", "vcc_auth_amount": null, "folio_amount": 521.68, "settled_amount": 521.68, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": null, "baseline_rate": 435.26, "market_rate": 422.2, "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": "disputed", "recon_amount": 177.75, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-25", "ingested_at": "2026-08-26T02:14:00Z", "version": 1, "public_rate": 435.26, "discount_pct": 20.98 }, { "id": "RS-8853331-1", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8853331", "duty_id": "D-513331", "layover_id": "L-513332", "crew_id": "IRE-1056", "crew_name": "J. Healy", "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": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-24T16:00:00Z", "checkin_time": "16:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-26T14:41:00Z", "duty_start_utc": "2026-08-26T06:30:00Z", "transfer_minutes": 44, "room_net": 272.7, "vat_rate": 7, "vat_amount": 19.09, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 296.79, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 296.79, "fx_rate": 1, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 266.69, "markup": 30.1, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853331", "vcc_auth_amount": 321.79, "folio_amount": 326.96, "settled_amount": 326.96, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": null, "baseline_rate": 366.3, "market_rate": 355.31, "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": "variance", "recon_amount": 30.17, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-26", "ingested_at": "2026-08-26T02:14:00Z", "version": 1, "public_rate": 366.3, "discount_pct": 18.98 }, { "id": "RS-8853890-2", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8853890", "duty_id": "D-513890", "layover_id": "L-513891", "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": "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": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 3, "booking_created_at": "2026-08-22T01:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-26T00:00:00Z", "duty_start_utc": "2026-08-26T14:05:00Z", "transfer_minutes": 44, "room_net": 379.77, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 379.77, "ancillaries": 0, "fee": 0, "currency_local": "HKD", "rate_paid_local": 3182.95, "fx_rate": 0.119314, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 379.77, "markup": 0, "commission_received": 30.76, "commission_shared": 15.38, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853890", "vcc_auth_amount": 404.77, "folio_amount": 582.09, "settled_amount": 582.09, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": null, "baseline_rate": 445.08, "market_rate": 431.73, "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": "variance", "recon_amount": 202.32, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-25", "ingested_at": "2026-08-26T02:14:00Z", "version": 1, "public_rate": 445.08, "discount_pct": 14.67 }, { "id": "RS-8854275-2", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8854275", "duty_id": "D-514275", "layover_id": "L-514276", "crew_id": "BEL-1060", "crew_name": "C. Vermeulen", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 9, "booking_created_at": "2026-08-16T14:00:00Z", "checkin_time": "14:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-26T13:03:00Z", "duty_start_utc": "2026-08-26T06:30:00Z", "transfer_minutes": 22, "room_net": 241.26, "vat_rate": 6, "vat_amount": 14.48, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 259.74, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 259.74, "fx_rate": 1, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 239.98, "markup": 19.76, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854275", "vcc_auth_amount": 284.74, "folio_amount": 404.85, "settled_amount": 404.85, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": 259.74, "baseline_rate": 392.07, "market_rate": 380.31, "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": "disputed", "recon_amount": 145.11, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-25", "ingested_at": "2026-08-26T02:14:00Z", "version": 1, "public_rate": 392.07, "discount_pct": 33.75 }, { "id": "RS-8854878-4", "period": "2026-08", "night": "2026-08-26", "booking_id": "RS-8854878", "duty_id": "D-514878", "layover_id": "L-514879", "crew_id": "FRA-1088", "crew_name": "O. Lefevre", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "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": "positioning", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-21T05:40:00Z", "checkin_time": "05:40", "checkout_time": "08:15", "duty_end_utc": "2026-08-26T04:51:00Z", "duty_start_utc": "2026-08-26T11:50:00Z", "transfer_minutes": 14, "room_net": 261.47, "vat_rate": 10, "vat_amount": 26.15, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 292.82, "ancillaries": 34.5, "fee": 0, "currency_local": "EUR", "rate_paid_local": 292.82, "fx_rate": 1, "fx_date": "2026-08-26", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 292.82, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854878", "vcc_auth_amount": 352.32, "folio_amount": 517.11, "settled_amount": 517.11, "settled_at": "2026-08-26T23:59:00Z", "contracted_rate": 292.82, "baseline_rate": 426.21, "market_rate": 413.42, "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": "variance", "recon_amount": 189.79, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-26T02:14:00Z", "version": 1, "public_rate": 426.21, "discount_pct": 31.3 }, { "id": "RS-8853220-2", "period": "2026-08", "night": "2026-08-25", "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": "held", "night_status": "occupied", "lead_time_days": null, "booking_created_at": null, "checkin_time": null, "checkout_time": null, "duty_end_utc": "2026-08-25T14:03:00Z", "duty_start_utc": "2026-08-25T09:15:00Z", "transfer_minutes": 22, "room_net": 245.01, "vat_rate": 6, "vat_amount": 14.7, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 259.71, "ancillaries": 19.74, "fee": 0, "currency_local": "EUR", "rate_paid_local": 259.71, "fx_rate": 1, "fx_date": "2026-08-25", "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": null, "folio_amount": 539.61, "settled_amount": 539.61, "settled_at": "2026-08-25T23:59:00Z", "contracted_rate": 259.71, "baseline_rate": 384.96, "market_rate": 373.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": "variance", "recon_amount": 260.16, "crew_rating": 4.8, "complaint_theme": null, "source_file_id": "AIMS-2026-08-24", "ingested_at": "2026-08-25T02:14:00Z", "version": 1, "public_rate": 384.96, "discount_pct": 32.54 }, { "id": "RS-8853283-2", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8853283", "duty_id": "D-513283", "layover_id": "L-513284", "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": "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": "occupied", "lead_time_days": 9, "booking_created_at": "2026-08-14T14:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-24T13:07:00Z", "duty_start_utc": "2026-08-24T06:30:00Z", "transfer_minutes": 18, "room_net": 283.77, "vat_rate": 20, "vat_amount": 56.76, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 340.53, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 286.62, "fx_rate": 1.188078, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 340.53, "markup": 0, "commission_received": 28.38, "commission_shared": 14.19, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853283", "vcc_auth_amount": 365.53, "folio_amount": 504.08, "settled_amount": 504.08, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": null, "baseline_rate": 407.37, "market_rate": 395.15, "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": "disputed", "recon_amount": 163.55, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 407.37, "discount_pct": 16.41 }, { "id": "RS-8853801-1", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8853801", "duty_id": "D-513801", "layover_id": "L-513802", "crew_id": "IRE-1003", "crew_name": "G. Kavanagh", "crew_rank": "FO", "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": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-19T01:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-24T00:22:00Z", "duty_start_utc": "2026-08-24T06:30:00Z", "transfer_minutes": 18, "room_net": 250.89, "vat_rate": 20, "vat_amount": 50.18, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 301.07, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 253.41, "fx_rate": 1.188078, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 282.65, "markup": 18.42, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853801", "vcc_auth_amount": 326.07, "folio_amount": 500.34, "settled_amount": 500.34, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": 301.07, "baseline_rate": 407.37, "market_rate": 395.15, "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": "disputed", "recon_amount": 199.27, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-24", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 407.37, "discount_pct": 26.09 }, { "id": "RS-8853944-1", "period": "2026-08", "night": "2026-08-24", "booking_id": "RS-8853944", "duty_id": "D-513944", "layover_id": "L-513945", "crew_id": "BEL-1002", "crew_name": "T. De Smet", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "HKG", "country": "HK", "property_id": "P-121", "hotel": "Hong Kong SkyCity Marriott", "chain": "Marriott", "contract_id": "C-121", "allotment_id": "A-121", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-22T05:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-24T04:21:00Z", "duty_start_utc": "2026-08-24T06:30:00Z", "transfer_minutes": 44, "room_net": 294.84, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 294.84, "ancillaries": 0, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2463.63, "fx_rate": 0.119677, "fx_date": "2026-08-24", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 294.84, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853944", "vcc_auth_amount": 319.84, "folio_amount": 475.29, "settled_amount": 475.29, "settled_at": "2026-08-24T23:59:00Z", "contracted_rate": 294.84, "baseline_rate": 398.79, "market_rate": 386.83, "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": "variance", "recon_amount": 180.45, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-24", "ingested_at": "2026-08-24T02:14:00Z", "version": 1, "public_rate": 398.79, "discount_pct": 26.07 }, { "id": "RS-8853066-1", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8853066", "duty_id": "D-513066", "layover_id": "L-513067", "crew_id": "IRE-S208", "crew_name": "P. O Conaill", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 3, "booking_created_at": "2026-08-20T14:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-23T13:02:00Z", "duty_start_utc": "2026-08-23T14:05:00Z", "transfer_minutes": 23, "room_net": 231.98, "vat_rate": 13.5, "vat_amount": 31.32, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 263.3, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 263.3, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 244.06, "markup": 19.24, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853066", "vcc_auth_amount": 288.3, "folio_amount": 492.13, "settled_amount": 492.13, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": 263.3, "baseline_rate": 307.39, "market_rate": 298.17, "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": "variance", "recon_amount": 228.83, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-23T02:14:00Z", "version": 1, "public_rate": 307.39, "discount_pct": 14.34 }, { "id": "RS-8854060-3", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8854060", "duty_id": "D-514060", "layover_id": "L-514061", "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-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": "irops", "night_status": "occupied", "lead_time_days": 0, "booking_created_at": "2026-08-21T14:30:00Z", "checkin_time": "16:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-23T15:03:00Z", "duty_start_utc": "2026-08-23T11:50:00Z", "transfer_minutes": 22, "room_net": 261.28, "vat_rate": 6, "vat_amount": 15.68, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 280.96, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 280.96, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 280.96, "markup": 0, "commission_received": 26.19, "commission_shared": 13.09, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854060", "vcc_auth_amount": 305.96, "folio_amount": 508.01, "settled_amount": 508.01, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": null, "baseline_rate": 313.2, "market_rate": 303.8, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "BRU-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 14.06, "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": "disputed", "recon_amount": 227.05, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-23T02:14:00Z", "version": 1, "public_rate": 313.2, "discount_pct": 10.29 }, { "id": "RS-8854088-1", "period": "2026-08", "night": "2026-08-23", "booking_id": "RS-8854088", "duty_id": "D-514088", "layover_id": "L-514089", "crew_id": "BEL-1011", "crew_name": "T. Verhoeven", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "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": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-22T05:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-23T04:42:00Z", "duty_start_utc": "2026-08-23T11:50:00Z", "transfer_minutes": 23, "room_net": 258.47, "vat_rate": 6, "vat_amount": 15.51, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 277.98, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 277.98, "fx_rate": 1, "fx_date": "2026-08-23", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 256.32, "markup": 21.66, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854088", "vcc_auth_amount": 302.98, "folio_amount": 562.7, "settled_amount": 562.7, "settled_at": "2026-08-23T23:59:00Z", "contracted_rate": 277.98, "baseline_rate": 341.95, "market_rate": 331.69, "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": "variance", "recon_amount": 284.72, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-23", "ingested_at": "2026-08-23T02:14:00Z", "version": 1, "public_rate": 341.95, "discount_pct": 18.71 }, { "id": "RS-8853108-1", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8853108", "duty_id": "D-513108", "layover_id": "L-513109", "crew_id": "IRE-1036", "crew_name": "N. Byrne", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 9, "booking_created_at": "2026-08-13T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-22T04:42:00Z", "duty_start_utc": "2026-08-22T14:05:00Z", "transfer_minutes": 23, "room_net": 230.37, "vat_rate": 13.5, "vat_amount": 31.1, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 261.47, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 261.47, "fx_rate": 1, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 242.51, "markup": 18.96, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853108", "vcc_auth_amount": 286.47, "folio_amount": 381.86, "settled_amount": 381.86, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": 261.47, "baseline_rate": 309.75, "market_rate": 300.46, "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": "variance", "recon_amount": 120.39, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-22", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 309.75, "discount_pct": 15.59 }, { "id": "RS-8853527-2", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8853527", "duty_id": "D-513527", "layover_id": "L-513528", "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": "LGG", "country": "BE", "property_id": "P-111", "hotel": "Ibis Liege Centre", "chain": "Accor", "contract_id": "C-111", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "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-22T04:42:00Z", "duty_start_utc": "2026-08-22T09:15:00Z", "transfer_minutes": 23, "room_net": 256.93, "vat_rate": 6, "vat_amount": 15.42, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 276.35, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 276.35, "fx_rate": 1, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 258.77, "markup": 17.58, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853527", "vcc_auth_amount": 301.35, "folio_amount": 507.28, "settled_amount": 507.28, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": 276.35, "baseline_rate": 329.33, "market_rate": 319.45, "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": "variance", "recon_amount": 230.93, "crew_rating": 3.3, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 329.33, "discount_pct": 16.09 }, { "id": "RS-8854337-1", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8854337", "duty_id": "D-514337", "layover_id": "L-514338", "crew_id": "BEL-1063", "crew_name": "C. Peeters", "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-126", "hotel": "Novotel Paris CDG", "chain": "Accor", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-21T17:40:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-22T04:51:00Z", "duty_start_utc": "2026-08-22T14:05:00Z", "transfer_minutes": 14, "room_net": 281.43, "vat_rate": 10, "vat_amount": 28.14, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 314.77, "ancillaries": 18.42, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 314.77, "fx_rate": 1, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 287.44, "markup": 27.33, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854337", "vcc_auth_amount": 358.19, "folio_amount": 523.4, "settled_amount": 523.4, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": null, "baseline_rate": 349.15, "market_rate": 338.68, "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": "variance", "recon_amount": 190.21, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-22", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 349.15, "discount_pct": 9.85 }, { "id": "RS-8854434-1", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8854434", "duty_id": "D-514434", "layover_id": "L-514435", "crew_id": "BEL-1026", "crew_name": "L. De Smet", "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": "A-123", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "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-22T14:37:00Z", "duty_start_utc": "2026-08-22T14:05:00Z", "transfer_minutes": 48, "room_net": 276.45, "vat_rate": 5, "vat_amount": 13.82, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 295.27, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1150.74, "fx_rate": 0.256592, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 295.27, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854434", "vcc_auth_amount": 320.27, "folio_amount": 578.9, "settled_amount": 578.9, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": 295.27, "baseline_rate": 346.93, "market_rate": 336.52, "rate_honoured": 1, "customer": "UPS", "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": "variance", "recon_amount": 283.63, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-22", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 346.93, "discount_pct": 14.89 }, { "id": "RS-8854450-2", "period": "2026-08", "night": "2026-08-22", "booking_id": "RS-8854450", "duty_id": "D-514450", "layover_id": "L-514451", "crew_id": "BEL-1005", "crew_name": "J. Willems", "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-124", "hotel": "Protea OR Tambo", "chain": "Marriott", "contract_id": "C-124", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 9, "booking_created_at": "2026-08-12T22:30:00Z", "checkin_time": "22:30", "checkout_time": "04:30", "duty_end_utc": "2026-08-22T21:09:00Z", "duty_start_utc": "2026-08-22T06:30:00Z", "transfer_minutes": 46, "room_net": 199.75, "vat_rate": 15, "vat_amount": 29.96, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 229.71, "ancillaries": 0, "fee": 0, "currency_local": "ZAR", "rate_paid_local": 4581.92, "fx_rate": 0.050134, "fx_date": "2026-08-22", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 212.13, "markup": 17.58, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854450", "vcc_auth_amount": 254.71, "folio_amount": 562.66, "settled_amount": 562.66, "settled_at": "2026-08-22T23:59:00Z", "contracted_rate": 229.71, "baseline_rate": 276.82, "market_rate": 268.52, "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": "variance", "recon_amount": 332.95, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-22T02:14:00Z", "version": 1, "public_rate": 276.82, "discount_pct": 17.02 }, { "id": "RS-8852825-1", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8852825", "duty_id": "D-512825", "layover_id": "L-512826", "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": "STN", "country": "GB", "property_id": "P-116", "hotel": "Hampton by Hilton Stansted", "chain": "Hilton", "contract_id": "C-116", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 3, "booking_created_at": "2026-08-18T22:30:00Z", "checkin_time": "22:30", "checkout_time": "04:30", "duty_end_utc": "2026-08-21T21:37:00Z", "duty_start_utc": "2026-08-21T09:15:00Z", "transfer_minutes": 18, "room_net": 255.53, "vat_rate": 20, "vat_amount": 51.11, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 306.64, "ancillaries": 9.74, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 258.36, "fx_rate": 1.186893, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 306.64, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852825", "vcc_auth_amount": 341.38, "folio_amount": 614.39, "settled_amount": 614.39, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": 306.64, "baseline_rate": 402.3, "market_rate": 390.23, "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": "variance", "recon_amount": 298.01, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 402.3, "discount_pct": 23.78 }, { "id": "RS-8854992-1", "period": "2026-08", "night": "2026-08-21", "booking_id": "RS-8854992", "duty_id": "D-514992", "layover_id": "L-514993", "crew_id": "FRA-1006", "crew_name": "V. Roussel", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "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": "gds", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 3, "booking_created_at": "2026-08-18T15:00:00Z", "checkin_time": "15:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-21T14:15:00Z", "duty_start_utc": "2026-08-21T14:05:00Z", "transfer_minutes": 10, "room_net": 258.13, "vat_rate": 10, "vat_amount": 25.81, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 286.82, "ancillaries": 27.91, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 286.82, "fx_rate": 1, "fx_date": "2026-08-21", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 286.82, "markup": 0, "commission_received": 23.54, "commission_shared": 11.77, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854992", "vcc_auth_amount": 339.73, "folio_amount": 639.44, "settled_amount": 639.44, "settled_at": "2026-08-21T23:59:00Z", "contracted_rate": null, "baseline_rate": 344.75, "market_rate": 334.41, "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": "variance", "recon_amount": 324.71, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-21", "ingested_at": "2026-08-21T02:14:00Z", "version": 1, "public_rate": 344.75, "discount_pct": 16.8 }, { "id": "RS-8852937-3", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8852937", "duty_id": "D-512937", "layover_id": "L-512938", "crew_id": "IRE-1050", "crew_name": "G. Doyle", "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-108", "hotel": "Leonardo Hotel Koln", "chain": "Leonardo", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-17T01:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-20T00:24:00Z", "duty_start_utc": "2026-08-20T11:50:00Z", "transfer_minutes": 16, "room_net": 271.93, "vat_rate": 7, "vat_amount": 19.03, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 295.96, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 295.96, "fx_rate": 1, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 269.26, "markup": 26.7, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852937", "vcc_auth_amount": 320.96, "folio_amount": 512.75, "settled_amount": 512.75, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": null, "baseline_rate": 377.84, "market_rate": 366.5, "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": "variance", "recon_amount": 216.79, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-20T02:14:00Z", "version": 1, "public_rate": 377.84, "discount_pct": 21.67 }, { "id": "RS-8853604-3", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8853604", "duty_id": "D-513604", "layover_id": "L-513605", "crew_id": "IRE-1003", "crew_name": "G. Kavanagh", "crew_rank": "FO", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0, "booking_created_at": "2026-08-18T12:30:00Z", "checkin_time": "14:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-20T13:07:00Z", "duty_start_utc": "2026-08-20T09:15:00Z", "transfer_minutes": 18, "room_net": 252.42, "vat_rate": 20, "vat_amount": 50.48, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 302.9, "ancillaries": 30.31, "fee": 0, "currency_local": "GBP", "rate_paid_local": 255.56, "fx_rate": 1.18525, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 279.89, "markup": 23.01, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853604", "vcc_auth_amount": 358.21, "folio_amount": 571.22, "settled_amount": 571.22, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": 302.9, "baseline_rate": 440.22, "market_rate": 427.01, "rate_honoured": 1, "customer": "DHL", "cost_centre": "EMA-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 13.25, "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": "disputed", "recon_amount": 238.01, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-20T02:14:00Z", "version": 1, "public_rate": 440.22, "discount_pct": 31.19 }, { "id": "RS-8853735-3", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8853735", "duty_id": "D-513735", "layover_id": "L-513736", "crew_id": "IRE-1024", "crew_name": "O. Byrne", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-16T14:00:00Z", "checkin_time": "14:00", "checkout_time": "04:30", "duty_end_utc": "2026-08-20T13:03:00Z", "duty_start_utc": "2026-08-20T09:15:00Z", "transfer_minutes": 22, "room_net": 303.54, "vat_rate": 6, "vat_amount": 18.21, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 325.75, "ancillaries": 20.32, "fee": 0, "currency_local": "EUR", "rate_paid_local": 325.75, "fx_rate": 1, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 325.75, "markup": 0, "commission_received": 33, "commission_shared": 16.5, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853735", "vcc_auth_amount": 371.07, "folio_amount": 645.23, "settled_amount": 645.23, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": null, "baseline_rate": 379.35, "market_rate": 367.97, "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": "disputed", "recon_amount": 299.16, "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": 14.13 }, { "id": "RS-8854577-3", "period": "2026-08", "night": "2026-08-20", "booking_id": "RS-8854577", "duty_id": "D-514577", "layover_id": "L-514578", "crew_id": "BEL-1039", "crew_name": "R. Peeters", "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": "irops", "night_status": "occupied", "lead_time_days": 0, "booking_created_at": "2026-08-17T23:45:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-20T00:00:00Z", "duty_start_utc": "2026-08-20T11:50:00Z", "transfer_minutes": 56, "room_net": 333.53, "vat_rate": 5, "vat_amount": 16.68, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 355.21, "ancillaries": 0, "fee": 0, "currency_local": "AED", "rate_paid_local": 1385.56, "fx_rate": 0.256366, "fx_date": "2026-08-20", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 324.33, "markup": 30.88, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854577", "vcc_auth_amount": 380.21, "folio_amount": 618.1, "settled_amount": 618.1, "settled_at": "2026-08-20T23:59:00Z", "contracted_rate": null, "baseline_rate": 408.09, "market_rate": 395.85, "rate_honoured": 1, "customer": "FedEx", "cost_centre": "LGG-CREW", "change_type": "modify_in_place", "change_source": "travel_desk", "change_cost": 11.1, "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": "variance", "recon_amount": 262.89, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-20T02:14:00Z", "version": 1, "public_rate": 408.09, "discount_pct": 12.96 }, { "id": "RS-8852977-1", "period": "2026-08", "night": "2026-08-19", "booking_id": "RS-8852977", "duty_id": "D-512977", "layover_id": "L-512978", "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": "DUB", "country": "IE", "property_id": "P-102", "hotel": "Maldron Hotel Dublin Airport", "chain": "Dalata", "contract_id": "C-102", "allotment_id": "A-102", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-18T22:30:00Z", "checkin_time": "22:30", "checkout_time": "12:00", "duty_end_utc": "2026-08-19T21:32:00Z", "duty_start_utc": "2026-08-19T14:05:00Z", "transfer_minutes": 23, "room_net": 230.71, "vat_rate": 13.5, "vat_amount": 31.15, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 261.86, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 261.86, "fx_rate": 1, "fx_date": "2026-08-19", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 261.86, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852977", "vcc_auth_amount": 286.86, "folio_amount": 435.46, "settled_amount": 435.46, "settled_at": "2026-08-19T23:59:00Z", "contracted_rate": 261.86, "baseline_rate": 371.78, "market_rate": 360.63, "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": "variance", "recon_amount": 173.6, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-19", "ingested_at": "2026-08-19T02:14:00Z", "version": 1, "public_rate": 371.78, "discount_pct": 29.57 }, { "id": "RS-8853146-2", "period": "2026-08", "night": "2026-08-19", "booking_id": "RS-8853146", "duty_id": "D-513146", "layover_id": "L-513147", "crew_id": "IRE-1043", "crew_name": "Y. Mulligan", "crew_rank": "ENG", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "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": "held", "night_status": "occupied", "lead_time_days": null, "booking_created_at": null, "checkin_time": null, "checkout_time": null, "duty_end_utc": "2026-08-19T00:16:00Z", "duty_start_utc": "2026-08-19T14:05:00Z", "transfer_minutes": 24, "room_net": 233.79, "vat_rate": 20, "vat_amount": 46.76, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 280.55, "ancillaries": 33.5, "fee": 0, "currency_local": "GBP", "rate_paid_local": 236.16, "fx_rate": 1.187985, "fx_date": "2026-08-19", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 264.46, "markup": 16.09, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853146", "vcc_auth_amount": null, "folio_amount": 573.85, "settled_amount": 573.85, "settled_at": "2026-08-19T23:59:00Z", "contracted_rate": 280.55, "baseline_rate": 407.16, "market_rate": 394.95, "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": "variance", "recon_amount": 259.8, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-19T02:14:00Z", "version": 1, "public_rate": 407.16, "discount_pct": 31.1 }, { "id": "RS-8853887-2", "period": "2026-08", "night": "2026-08-18", "booking_id": "RS-8853887", "duty_id": "D-513887", "layover_id": "L-513888", "crew_id": "BEL-1089", "crew_name": "L. Willems", "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-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": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-12T05:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-18T04:21:00Z", "duty_start_utc": "2026-08-18T14:05:00Z", "transfer_minutes": 44, "room_net": 296.49, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 296.49, "ancillaries": 0, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2473.45, "fx_rate": 0.119869, "fx_date": "2026-08-18", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 296.49, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853887", "vcc_auth_amount": 321.49, "folio_amount": 570.43, "settled_amount": 570.43, "settled_at": "2026-08-18T23:59:00Z", "contracted_rate": 296.49, "baseline_rate": 426.37, "market_rate": 413.58, "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": "disputed", "recon_amount": 273.94, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-17", "ingested_at": "2026-08-18T02:14:00Z", "version": 1, "public_rate": 426.37, "discount_pct": 30.46 }, { "id": "RS-8853972-1", "period": "2026-08", "night": "2026-08-18", "booking_id": "RS-8853972", "duty_id": "D-513972", "layover_id": "L-513973", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "standby", "night_status": "occupied", "lead_time_days": 0.5, "booking_created_at": "2026-08-18T02:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-18T13:02:00Z", "duty_start_utc": "2026-08-18T14:05:00Z", "transfer_minutes": 23, "room_net": 256.58, "vat_rate": 6, "vat_amount": 15.39, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 275.97, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 275.97, "fx_rate": 1, "fx_date": "2026-08-18", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 254.51, "markup": 21.46, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853972", "vcc_auth_amount": 300.97, "folio_amount": 452.58, "settled_amount": 452.58, "settled_at": "2026-08-18T23:59:00Z", "contracted_rate": 275.97, "baseline_rate": 411.52, "market_rate": 399.17, "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": "variance", "recon_amount": 176.61, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-18", "ingested_at": "2026-08-18T02:14:00Z", "version": 1, "public_rate": 411.52, "discount_pct": 32.94 }, { "id": "RS-8852930-2", "period": "2026-08", "night": "2026-08-17", "booking_id": "RS-8852930", "duty_id": "D-512930", "layover_id": "L-512931", "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": "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": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-15T14:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-17T13:07:00Z", "duty_start_utc": "2026-08-17T09:15:00Z", "transfer_minutes": 18, "room_net": 251.46, "vat_rate": 20, "vat_amount": 50.29, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 301.75, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 254.68, "fx_rate": 1.184843, "fx_date": "2026-08-17", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 278.93, "markup": 22.82, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852930", "vcc_auth_amount": 326.75, "folio_amount": 514.39, "settled_amount": 514.39, "settled_at": "2026-08-17T23:59:00Z", "contracted_rate": 301.75, "baseline_rate": 422.12, "market_rate": 409.46, "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": "variance", "recon_amount": 212.64, "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": 28.52 }, { "id": "RS-8853045-1", "period": "2026-08", "night": "2026-08-17", "booking_id": "RS-8853045", "duty_id": "D-513045", "layover_id": "L-513046", "crew_id": "IRE-1066", "crew_name": "B. Brennan", "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-111", "hotel": "Ibis Liege Centre", "chain": "Accor", "contract_id": "C-111", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-16T22:30:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-17T21:32:00Z", "duty_start_utc": "2026-08-17T11:50:00Z", "transfer_minutes": 23, "room_net": 254.83, "vat_rate": 6, "vat_amount": 15.29, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 274.12, "ancillaries": 25.69, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 274.12, "fx_rate": 1, "fx_date": "2026-08-17", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 256.19, "markup": 17.93, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853045", "vcc_auth_amount": 324.81, "folio_amount": 562.69, "settled_amount": 562.69, "settled_at": "2026-08-17T23:59:00Z", "contracted_rate": 274.12, "baseline_rate": 387.75, "market_rate": 376.12, "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": "disputed", "recon_amount": 262.88, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-17", "ingested_at": "2026-08-17T02:14:00Z", "version": 1, "public_rate": 387.75, "discount_pct": 29.3 }, { "id": "RS-8853934-1", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8853934", "duty_id": "D-513934", "layover_id": "L-513935", "crew_id": "BEL-1027", "crew_name": "A. Peeters", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "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": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-11T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-16T04:09:00Z", "duty_start_utc": "2026-08-16T14:05:00Z", "transfer_minutes": 56, "room_net": 293.92, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 293.92, "ancillaries": 0, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2453.73, "fx_rate": 0.119785, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 274.98, "markup": 18.94, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853934", "vcc_auth_amount": 318.92, "folio_amount": 372.6, "settled_amount": 372.6, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": 293.92, "baseline_rate": 367.15, "market_rate": 356.14, "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": "variance", "recon_amount": 78.68, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-16", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 367.15, "discount_pct": 19.95 }, { "id": "RS-8854105-1", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8854105", "duty_id": "D-514105", "layover_id": "L-514106", "crew_id": "BEL-1027", "crew_name": "A. Peeters", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "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": "overnight", "night_status": "occupied", "lead_time_days": 3, "booking_created_at": "2026-08-13T16:00:00Z", "checkin_time": "16:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-16T14:29:00Z", "duty_start_utc": "2026-08-16T11:50:00Z", "transfer_minutes": 56, "room_net": 296.02, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 296.02, "ancillaries": 23.88, "fee": 15.97, "currency_local": "HKD", "rate_paid_local": 2471.26, "fx_rate": 0.119785, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 296.02, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854105", "vcc_auth_amount": 344.9, "folio_amount": 486.43, "settled_amount": 486.43, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": 296.02, "baseline_rate": 367.15, "market_rate": 356.14, "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": "variance", "recon_amount": 166.53, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-16", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 367.15, "discount_pct": 19.37 }, { "id": "RS-8854359-4", "period": "2026-08", "night": "2026-08-16", "booking_id": "RS-8854359", "duty_id": "D-514359", "layover_id": "L-514360", "crew_id": "BEL-1039", "crew_name": "R. Peeters", "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-120", "hotel": "Regal Airport Hotel", "chain": "Regal", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "standby", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-12T05:40:00Z", "checkin_time": "05:40", "checkout_time": "12:00", "duty_end_utc": "2026-08-16T04:09:00Z", "duty_start_utc": "2026-08-16T14:05:00Z", "transfer_minutes": 56, "room_net": 310.03, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 310.03, "ancillaries": 0, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2588.22, "fx_rate": 0.119785, "fx_date": "2026-08-16", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 310.03, "markup": 0, "commission_received": 24.65, "commission_shared": 12.33, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854359", "vcc_auth_amount": 335.03, "folio_amount": 515.56, "settled_amount": 515.56, "settled_at": "2026-08-16T23:59:00Z", "contracted_rate": null, "baseline_rate": 367.15, "market_rate": 356.14, "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": "variance", "recon_amount": 205.53, "crew_rating": 3.4, "complaint_theme": null, "source_file_id": "AIMS-2026-08-13", "ingested_at": "2026-08-16T02:14:00Z", "version": 1, "public_rate": 367.15, "discount_pct": 15.56 }, { "id": "RS-8853103-2", "period": "2026-08", "night": "2026-08-15", "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": "occupied", "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-15T04:50:00Z", "duty_start_utc": "2026-08-15T09:15:00Z", "transfer_minutes": 15, "room_net": 229.23, "vat_rate": 20, "vat_amount": 45.84, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 275.07, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 232.91, "fx_rate": 1.18102, "fx_date": "2026-08-15", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 249.56, "markup": 25.51, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853103", "vcc_auth_amount": 300.07, "folio_amount": 369.47, "settled_amount": 369.47, "settled_at": "2026-08-15T23:59:00Z", "contracted_rate": null, "baseline_rate": 348.32, "market_rate": 337.87, "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": "variance", "recon_amount": 94.4, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-15T02:14:00Z", "version": 1, "public_rate": 348.32, "discount_pct": 21.03 }, { "id": "RS-8853501-3", "period": "2026-08", "night": "2026-08-15", "booking_id": "RS-8853501", "duty_id": "D-513501", "layover_id": "L-513502", "crew_id": "IRE-1089", "crew_name": "T. Fitzgerald", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "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": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-08T15:00:00Z", "checkin_time": "15:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-15T14:14:00Z", "duty_start_utc": "2026-08-15T06:30:00Z", "transfer_minutes": 11, "room_net": 246.26, "vat_rate": 20, "vat_amount": 49.25, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 295.51, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 250.22, "fx_rate": 1.18102, "fx_date": "2026-08-15", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 277.92, "markup": 17.59, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853501", "vcc_auth_amount": 320.51, "folio_amount": 610.73, "settled_amount": 610.73, "settled_at": "2026-08-15T23:59:00Z", "contracted_rate": 295.51, "baseline_rate": 348.8, "market_rate": 338.34, "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": "disputed", "recon_amount": 315.22, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-13", "ingested_at": "2026-08-15T02:14:00Z", "version": 1, "public_rate": 348.8, "discount_pct": 15.28 }, { "id": "RS-8853856-2", "period": "2026-08", "night": "2026-08-15", "booking_id": "RS-8853856", "duty_id": "D-513856", "layover_id": "L-513857", "crew_id": "BEL-1036", "crew_name": "P. Vermeulen", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "BRU", "station": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "irops", "night_status": "occupied", "lead_time_days": 0, "booking_created_at": "2026-08-14T21:00:00Z", "checkin_time": "22:30", "checkout_time": "12:00", "duty_end_utc": "2026-08-15T21:33:00Z", "duty_start_utc": "2026-08-15T06:30:00Z", "transfer_minutes": 22, "room_net": 241.84, "vat_rate": 6, "vat_amount": 14.51, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 260.35, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 260.35, "fx_rate": 1, "fx_date": "2026-08-15", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 240.6, "markup": 19.75, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853856", "vcc_auth_amount": 285.35, "folio_amount": 567.06, "settled_amount": 567.06, "settled_at": "2026-08-15T23:59:00Z", "contracted_rate": 260.35, "baseline_rate": 316.41, "market_rate": 306.92, "rate_honoured": 1, "customer": "DHL", "cost_centre": "BRU-CREW", "change_type": "modify_in_place", "change_source": "aims", "change_cost": 13, "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": "disputed", "recon_amount": 306.71, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-15T02:14:00Z", "version": 1, "public_rate": 316.41, "discount_pct": 17.72 }, { "id": "RS-8854011-1", "period": "2026-08", "night": "2026-08-15", "booking_id": "RS-8854011", "duty_id": "D-514011", "layover_id": "L-514012", "crew_id": "BEL-1048", "crew_name": "T. Vermeulen", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "DXB", "country": "AE", "property_id": "P-122", "hotel": "Millennium Airport Hotel Dubai", "chain": "Millennium", "contract_id": "C-122", "allotment_id": "A-122", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "training", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-13T22:30:00Z", "checkin_time": "22:30", "checkout_time": "04:30", "duty_end_utc": "2026-08-15T20:59:00Z", "duty_start_utc": "2026-08-15T06:30:00Z", "transfer_minutes": 56, "room_net": 268.33, "vat_rate": 5, "vat_amount": 13.42, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 286.75, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1121.16, "fx_rate": 0.255762, "fx_date": "2026-08-15", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 266.96, "markup": 19.79, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854011", "vcc_auth_amount": 311.75, "folio_amount": 525.34, "settled_amount": 525.34, "settled_at": "2026-08-15T23:59:00Z", "contracted_rate": 286.75, "baseline_rate": 337.23, "market_rate": 327.11, "rate_honoured": 1, "customer": "UPS", "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": "disputed", "recon_amount": 238.59, "crew_rating": 2.6, "complaint_theme": "noise", "source_file_id": "AIMS-2026-08-15", "ingested_at": "2026-08-15T02:14:00Z", "version": 1, "public_rate": 337.23, "discount_pct": 14.97 }, { "id": "RS-8854223-1", "period": "2026-08", "night": "2026-08-15", "booking_id": "RS-8854223", "duty_id": "D-514223", "layover_id": "L-514224", "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": "LGG", "country": "BE", "property_id": "P-110", "hotel": "Van der Valk Liege", "chain": "Van der Valk", "contract_id": "C-110", "allotment_id": "A-110", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-14T05:40:00Z", "checkin_time": "05:40", "checkout_time": "11:00", "duty_end_utc": "2026-08-15T04:43:00Z", "duty_start_utc": "2026-08-15T09:15:00Z", "transfer_minutes": 22, "room_net": 244.16, "vat_rate": 6, "vat_amount": 14.65, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 262.81, "ancillaries": 11.67, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 262.81, "fx_rate": 1, "fx_date": "2026-08-15", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 247.75, "markup": 15.06, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854223", "vcc_auth_amount": 299.48, "folio_amount": 317.32, "settled_amount": 317.32, "settled_at": "2026-08-15T23:59:00Z", "contracted_rate": 262.81, "baseline_rate": 316.41, "market_rate": 306.92, "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": "variance", "recon_amount": 42.84, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-15", "ingested_at": "2026-08-15T02:14:00Z", "version": 1, "public_rate": 316.41, "discount_pct": 16.94 }, { "id": "RS-8852847-1", "period": "2026-08", "night": "2026-08-14", "booking_id": "RS-8852847", "duty_id": "D-512847", "layover_id": "L-512848", "crew_id": "IRE-S211", "crew_name": "S. Nolan", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "EMA", "station": "EMA", "country": "GB", "property_id": "P-104", "hotel": "Hilton East Midlands", "chain": "Hilton", "contract_id": "C-104", "allotment_id": "A-104", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 3, "booking_created_at": "2026-08-11T05:40:00Z", "checkin_time": "05:40", "checkout_time": "10:00", "duty_end_utc": "2026-08-14T04:50:00Z", "duty_start_utc": "2026-08-14T06:30:00Z", "transfer_minutes": 15, "room_net": 246.39, "vat_rate": 20, "vat_amount": 49.28, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 295.67, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 250.83, "fx_rate": 1.178783, "fx_date": "2026-08-14", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 278.97, "markup": 16.7, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8852847", "vcc_auth_amount": 320.67, "folio_amount": 610.7, "settled_amount": 610.7, "settled_at": "2026-08-14T23:59:00Z", "contracted_rate": 295.67, "baseline_rate": 377.74, "market_rate": 366.41, "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": "variance", "recon_amount": 315.03, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-14", "ingested_at": "2026-08-14T02:14:00Z", "version": 1, "public_rate": 377.74, "discount_pct": 21.73 }, { "id": "RS-8854795-4", "period": "2026-08", "night": "2026-08-14", "booking_id": "RS-8854795", "duty_id": "D-514795", "layover_id": "L-514796", "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": "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": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-06T05:40:00Z", "checkin_time": "05:40", "checkout_time": "04:30", "duty_end_utc": "2026-08-14T04:51:00Z", "duty_start_utc": "2026-08-14T11:50:00Z", "transfer_minutes": 14, "room_net": 262.06, "vat_rate": 10, "vat_amount": 26.21, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 5.2, "rate_paid": 293.47, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 293.47, "fx_rate": 1, "fx_date": "2026-08-14", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 275.92, "markup": 17.55, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854795", "vcc_auth_amount": 318.47, "folio_amount": 586.44, "settled_amount": 586.44, "settled_at": "2026-08-14T23:59:00Z", "contracted_rate": 293.47, "baseline_rate": 380.62, "market_rate": 369.2, "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": "variance", "recon_amount": 292.97, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-14T02:14:00Z", "version": 1, "public_rate": 380.62, "discount_pct": 22.9 }, { "id": "RS-8853317-1", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8853317", "duty_id": "D-513317", "layover_id": "L-513318", "crew_id": "IRE-1006", "crew_name": "E. Brennan", "crew_rank": "FO", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "CGN", "country": "DE", "property_id": "P-107", "hotel": "Ibis Koln Messe", "chain": "Accor", "contract_id": "C-107", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-12T15:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-13T14:15:00Z", "duty_start_utc": "2026-08-13T06:30:00Z", "transfer_minutes": 10, "room_net": 232.12, "vat_rate": 7, "vat_amount": 16.25, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 253.37, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 253.37, "fx_rate": 1, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "airline_contract", "supplier_cost": 253.37, "markup": 0, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853317", "vcc_auth_amount": 278.37, "folio_amount": 379.45, "settled_amount": 379.45, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 253.37, "baseline_rate": 372.65, "market_rate": 361.47, "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": "disputed", "recon_amount": 126.08, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-13", "ingested_at": "2026-08-13T02:14:00Z", "version": 1, "public_rate": 372.65, "discount_pct": 32.01 }, { "id": "RS-8854496-1", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8854496", "duty_id": "D-514496", "layover_id": "L-514497", "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": "BRU", "country": "BE", "property_id": "P-118", "hotel": "NH Brussels Airport", "chain": "NH", "contract_id": "C-118", "allotment_id": "A-118", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-12T22:30:00Z", "checkin_time": "22:30", "checkout_time": "12:00", "duty_end_utc": "2026-08-13T21:42:00Z", "duty_start_utc": "2026-08-13T06:30:00Z", "transfer_minutes": 13, "room_net": 305.64, "vat_rate": 6, "vat_amount": 18.34, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4.24, "rate_paid": 328.22, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 328.22, "fx_rate": 1, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 306.47, "markup": 21.75, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854496", "vcc_auth_amount": 353.22, "folio_amount": 653.7, "settled_amount": 653.7, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": 328.22, "baseline_rate": 447.61, "market_rate": 434.18, "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": "variance", "recon_amount": 325.48, "crew_rating": 2.9, "complaint_theme": "checkin", "source_file_id": "AIMS-2026-08-13", "ingested_at": "2026-08-13T02:14:00Z", "version": 1, "public_rate": 447.61, "discount_pct": 26.67 }, { "id": "RS-8854596-1", "period": "2026-08", "night": "2026-08-13", "booking_id": "RS-8854596", "duty_id": "D-514596", "layover_id": "L-514597", "crew_id": "BEL-1034", "crew_name": "G. Declerck", "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-124", "hotel": "Protea OR Tambo", "chain": "Marriott", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 9, "booking_created_at": "2026-08-04T01:15:00Z", "checkin_time": "01:15", "checkout_time": "10:00", "duty_end_utc": "2026-08-13T00:00:00Z", "duty_start_utc": "2026-08-13T09:15:00Z", "transfer_minutes": 46, "room_net": 229.1, "vat_rate": 15, "vat_amount": 34.37, "vat_country": "ZA", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 263.47, "ancillaries": 20.82, "fee": 15.97, "currency_local": "ZAR", "rate_paid_local": 5241.1, "fx_rate": 0.05027, "fx_date": "2026-08-13", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 239.29, "markup": 24.18, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854596", "vcc_auth_amount": 309.29, "folio_amount": 562.74, "settled_amount": 562.74, "settled_at": "2026-08-13T23:59:00Z", "contracted_rate": null, "baseline_rate": 326.93, "market_rate": 317.12, "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": "variance", "recon_amount": 278.45, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-13", "ingested_at": "2026-08-13T02:14:00Z", "version": 1, "public_rate": 326.93, "discount_pct": 19.41 }, { "id": "RS-8855058-1", "period": "2026-08", "night": "2026-08-12", "booking_id": "RS-8855058", "duty_id": "D-515058", "layover_id": "L-515059", "crew_id": "FRA-1021", "crew_name": "G. Perrin", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-07T15:00:00Z", "checkin_time": "15:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-12T14:07:00Z", "duty_start_utc": "2026-08-12T11:50:00Z", "transfer_minutes": 18, "room_net": 269.24, "vat_rate": 10, "vat_amount": 26.92, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 299.46, "ancillaries": 30.71, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 299.46, "fx_rate": 1, "fx_date": "2026-08-12", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 275.22, "markup": 24.24, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855058", "vcc_auth_amount": 355.17, "folio_amount": 532.53, "settled_amount": 532.53, "settled_at": "2026-08-12T23:59:00Z", "contracted_rate": null, "baseline_rate": 371.49, "market_rate": 360.35, "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": "disputed", "recon_amount": 202.36, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-12", "ingested_at": "2026-08-12T02:14:00Z", "version": 1, "public_rate": 371.49, "discount_pct": 19.39 }, { "id": "RS-8855097-1", "period": "2026-08", "night": "2026-08-12", "booking_id": "RS-8855097", "duty_id": "D-515097", "layover_id": "L-515098", "crew_id": "FRA-S200", "crew_name": "Y. Fontaine", "crew_rank": "STAFF", "traveller_type": "staff", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "LYS", "station": "MRS", "country": "FR", "property_id": "P-132", "hotel": "Holiday Inn Marseille", "chain": "IHG", "contract_id": "C-132", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-10T22:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-12T21:39:00Z", "duty_start_utc": "2026-08-12T09:15:00Z", "transfer_minutes": 16, "room_net": 239.57, "vat_rate": 10, "vat_amount": 23.96, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 3.3, "rate_paid": 266.83, "ancillaries": 35.21, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 266.83, "fx_rate": 1, "fx_date": "2026-08-12", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 251.95, "markup": 14.88, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8855097", "vcc_auth_amount": 327.04, "folio_amount": 572.56, "settled_amount": 572.56, "settled_at": "2026-08-12T23:59:00Z", "contracted_rate": 266.83, "baseline_rate": 377.06, "market_rate": 365.75, "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": "disputed", "recon_amount": 270.52, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-12", "ingested_at": "2026-08-12T02:14:00Z", "version": 1, "public_rate": 377.06, "discount_pct": 29.23 }, { "id": "RS-8853236-1", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8853236", "duty_id": "D-513236", "layover_id": "L-513237", "crew_id": "IRE-1051", "crew_name": "D. Kavanagh", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "BHX", "country": "GB", "property_id": "P-114", "hotel": "Ibis Birmingham Airport", "chain": "Accor", "contract_id": "C-114", "allotment_id": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-06T05:40:00Z", "checkin_time": "05:40", "checkout_time": "08:15", "duty_end_utc": "2026-08-11T04:42:00Z", "duty_start_utc": "2026-08-11T06:30:00Z", "transfer_minutes": 23, "room_net": 232.85, "vat_rate": 20, "vat_amount": 46.57, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 279.42, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 235.92, "fx_rate": 1.184406, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 261.98, "markup": 17.44, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853236", "vcc_auth_amount": 304.42, "folio_amount": 555.84, "settled_amount": 555.84, "settled_at": "2026-08-11T23:59:00Z", "contracted_rate": 279.42, "baseline_rate": 403.05, "market_rate": 390.96, "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": "variance", "recon_amount": 276.42, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-11T02:14:00Z", "version": 1, "public_rate": 403.05, "discount_pct": 30.67 }, { "id": "RS-8853918-1", "period": "2026-08", "night": "2026-08-11", "booking_id": "RS-8853918", "duty_id": "D-513918", "layover_id": "L-513919", "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": "DXB", "country": "AE", "property_id": "P-122", "hotel": "Millennium Airport Hotel Dubai", "chain": "Millennium", "contract_id": "C-122", "allotment_id": "A-122", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-06T01:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-11T00:00:00Z", "duty_start_utc": "2026-08-11T14:05:00Z", "transfer_minutes": 56, "room_net": 268.58, "vat_rate": 5, "vat_amount": 13.43, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 287.01, "ancillaries": 25.95, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1122.98, "fx_rate": 0.25558, "fx_date": "2026-08-11", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 266.78, "markup": 20.23, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853918", "vcc_auth_amount": 337.96, "folio_amount": 524.4, "settled_amount": 524.4, "settled_at": "2026-08-11T23:59:00Z", "contracted_rate": 287.01, "baseline_rate": 402.42, "market_rate": 390.35, "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": "disputed", "recon_amount": 211.44, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-11", "ingested_at": "2026-08-11T02:14:00Z", "version": 1, "public_rate": 402.42, "discount_pct": 28.68 }, { "id": "RS-8853723-2", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8853723", "duty_id": "D-513723", "layover_id": "L-513724", "crew_id": "IRE-1066", "crew_name": "B. Brennan", "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-106", "hotel": "Premier Inn Kegworth", "chain": "Whitbread", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-07T22:30:00Z", "checkin_time": "22:30", "checkout_time": "11:00", "duty_end_utc": "2026-08-10T21:17:00Z", "duty_start_utc": "2026-08-10T14:05:00Z", "transfer_minutes": 38, "room_net": 274.44, "vat_rate": 20, "vat_amount": 54.89, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 329.33, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 277.81, "fx_rate": 1.185465, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 329.33, "markup": 0, "commission_received": 31.81, "commission_shared": 15.91, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853723", "vcc_auth_amount": 354.33, "folio_amount": 541.67, "settled_amount": 541.67, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": null, "baseline_rate": 389.23, "market_rate": 377.55, "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": "variance", "recon_amount": 212.34, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-09", "ingested_at": "2026-08-10T02:14:00Z", "version": 1, "public_rate": 389.23, "discount_pct": 15.39 }, { "id": "RS-8854089-3", "period": "2026-08", "night": "2026-08-10", "booking_id": "RS-8854089", "duty_id": "D-514089", "layover_id": "L-514090", "crew_id": "BEL-1031", "crew_name": "N. Wouters", "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": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "gds", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 1, "booking_created_at": "2026-08-07T01:15:00Z", "checkin_time": "01:15", "checkout_time": "12:00", "duty_end_utc": "2026-08-10T00:17:00Z", "duty_start_utc": "2026-08-10T06:30:00Z", "transfer_minutes": 23, "room_net": 301.18, "vat_rate": 6, "vat_amount": 18.07, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4, "rate_paid": 323.25, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 323.25, "fx_rate": 1, "fx_date": "2026-08-10", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 323.25, "markup": 0, "commission_received": 31.66, "commission_shared": 15.83, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8854089", "vcc_auth_amount": 348.25, "folio_amount": 482.01, "settled_amount": 482.01, "settled_at": "2026-08-10T23:59:00Z", "contracted_rate": null, "baseline_rate": 380.6, "market_rate": 369.18, "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": "disputed", "recon_amount": 158.76, "crew_rating": 3.8, "complaint_theme": null, "source_file_id": "AIMS-2026-08-08", "ingested_at": "2026-08-10T02:14:00Z", "version": 1, "public_rate": 380.6, "discount_pct": 15.07 }, { "id": "RS-8854396-2", "period": "2026-08", "night": "2026-08-08", "booking_id": "RS-8854396", "duty_id": "D-514396", "layover_id": "L-514397", "crew_id": "BEL-1029", "crew_name": "H. Willems", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines Belgium", "legal_entity": "ASL Airlines Belgium NV", "home_base": "LGG", "station": "DXB", "country": "AE", "property_id": "P-122", "hotel": "Millennium Airport Hotel Dubai", "chain": "Millennium", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-08-02T22:30:00Z", "checkin_time": "22:30", "checkout_time": "12:00", "duty_end_utc": "2026-08-08T20:59:00Z", "duty_start_utc": "2026-08-08T14:05:00Z", "transfer_minutes": 56, "room_net": 244.05, "vat_rate": 5, "vat_amount": 12.2, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 261.25, "ancillaries": 21.74, "fee": 0, "currency_local": "AED", "rate_paid_local": 1018.8, "fx_rate": 0.256429, "fx_date": "2026-08-08", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 233.66, "markup": 27.59, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854396", "vcc_auth_amount": 307.99, "folio_amount": 496.91, "settled_amount": 496.91, "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": "variance", "recon_amount": 213.92, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-07", "ingested_at": "2026-08-08T02:14:00Z", "version": 1, "public_rate": 329.59, "discount_pct": 20.73 }, { "id": "RS-8854993-2", "period": "2026-08", "night": "2026-08-07", "booking_id": "RS-8854993", "duty_id": "D-514993", "layover_id": "L-514994", "crew_id": "FRA-1040", "crew_name": "T. Lefevre", "crew_rank": "FO", "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": "overnight", "night_status": "occupied", "lead_time_days": 9, "booking_created_at": "2026-07-28T14:00:00Z", "checkin_time": "14:00", "checkout_time": "12:00", "duty_end_utc": "2026-08-07T13:11:00Z", "duty_start_utc": "2026-08-07T06:30:00Z", "transfer_minutes": 14, "room_net": 276.45, "vat_rate": 10, "vat_amount": 27.65, "vat_country": "ES", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 304.1, "ancillaries": 25.42, "fee": 0, "currency_local": "EUR", "rate_paid_local": 304.1, "fx_rate": 1, "fx_date": "2026-08-07", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 275.47, "markup": 28.63, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854993", "vcc_auth_amount": 354.52, "folio_amount": 650.72, "settled_amount": 650.72, "settled_at": "2026-08-07T23:59:00Z", "contracted_rate": null, "baseline_rate": 370.82, "market_rate": 359.7, "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": "variance", "recon_amount": 321.2, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-06", "ingested_at": "2026-08-07T02:14:00Z", "version": 1, "public_rate": 370.82, "discount_pct": 17.99 }, { "id": "RS-8854146-2", "period": "2026-08", "night": "2026-08-06", "booking_id": "RS-8854146", "duty_id": "D-514146", "layover_id": "L-514147", "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": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-07-31T01:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-06T00:00:00Z", "duty_start_utc": "2026-08-06T11:50:00Z", "transfer_minutes": 56, "room_net": 300.99, "vat_rate": 5, "vat_amount": 15.05, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 321.04, "ancillaries": 0, "fee": 0, "currency_local": "AED", "rate_paid_local": 1252.8, "fx_rate": 0.256259, "fx_date": "2026-08-06", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 293.24, "markup": 27.8, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854146", "vcc_auth_amount": 346.04, "folio_amount": 540.73, "settled_amount": 540.73, "settled_at": "2026-08-06T23:59:00Z", "contracted_rate": null, "baseline_rate": 409.59, "market_rate": 397.3, "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": "variance", "recon_amount": 219.69, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-05", "ingested_at": "2026-08-06T02:14:00Z", "version": 1, "public_rate": 409.59, "discount_pct": 21.62 }, { "id": "RS-8853847-2", "period": "2026-08", "night": "2026-08-04", "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": "occupied", "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-04T15:02:00Z", "duty_start_utc": "2026-08-04T09:15: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": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 275.88, "fx_rate": 1, "fx_date": "2026-08-04", "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": 300.88, "folio_amount": 429.82, "settled_amount": 429.82, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": 275.88, "baseline_rate": 411.7, "market_rate": 399.35, "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": "variance", "recon_amount": 153.94, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 411.7, "discount_pct": 32.99 }, { "id": "RS-8854041-1", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8854041", "duty_id": "D-514041", "layover_id": "L-514042", "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": "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": "overnight", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-02T15:00:00Z", "checkin_time": "15:00", "checkout_time": "10:00", "duty_end_utc": "2026-08-04T13:37:00Z", "duty_start_utc": "2026-08-04T14:05:00Z", "transfer_minutes": 48, "room_net": 276.53, "vat_rate": 5, "vat_amount": 13.83, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 295.36, "ancillaries": 0, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1155.18, "fx_rate": 0.255683, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 274.79, "markup": 20.57, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854041", "vcc_auth_amount": 320.36, "folio_amount": 397.96, "settled_amount": 397.96, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": 295.36, "baseline_rate": 412.21, "market_rate": 399.84, "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": "disputed", "recon_amount": 102.6, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-04", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 412.21, "discount_pct": 28.35 }, { "id": "RS-8854314-1", "period": "2026-08", "night": "2026-08-04", "booking_id": "RS-8854314", "duty_id": "D-514314", "layover_id": "L-514315", "crew_id": "BEL-1055", "crew_name": "M. 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-117", "hotel": "Thon Hotel EU", "chain": "Thon", "contract_id": "C-117", "allotment_id": "A-117", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 2, "booking_created_at": "2026-08-02T01:15:00Z", "checkin_time": "01:15", "checkout_time": "08:15", "duty_end_utc": "2026-08-04T00:22:00Z", "duty_start_utc": "2026-08-04T06:30:00Z", "transfer_minutes": 18, "room_net": 302.36, "vat_rate": 6, "vat_amount": 18.14, "vat_country": "BE", "vat_recoverable": 1, "city_tax": 4.24, "rate_paid": 324.74, "ancillaries": 0, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 324.74, "fx_rate": 1, "fx_date": "2026-08-04", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 302.49, "markup": 22.25, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854314", "vcc_auth_amount": 349.74, "folio_amount": 533.65, "settled_amount": 533.65, "settled_at": "2026-08-04T23:59:00Z", "contracted_rate": 324.74, "baseline_rate": 449.94, "market_rate": 436.44, "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": "variance", "recon_amount": 208.91, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-04", "ingested_at": "2026-08-04T02:14:00Z", "version": 1, "public_rate": 449.94, "discount_pct": 27.83 }, { "id": "RS-8853002-2", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8853002", "duty_id": "D-513002", "layover_id": "L-513003", "crew_id": "IRE-1048", "crew_name": "B. Byrne", "crew_rank": "CPT", "traveller_type": "crew", "entity": "ASL Airlines Ireland", "legal_entity": "ASL Airlines (Ireland) Ltd", "home_base": "DUB", "station": "EMA", "country": "GB", "property_id": "P-104", "hotel": "Hilton East Midlands", "chain": "Hilton", "contract_id": "C-104", "allotment_id": "A-104", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 5, "booking_created_at": "2026-07-28T15:00:00Z", "checkin_time": "15:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-03T14:10:00Z", "duty_start_utc": "2026-08-03T09:15:00Z", "transfer_minutes": 15, "room_net": 246.86, "vat_rate": 20, "vat_amount": 49.37, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 296.23, "ancillaries": 0, "fee": 0, "currency_local": "GBP", "rate_paid_local": 249.43, "fx_rate": 1.187651, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 274.64, "markup": 21.59, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853002", "vcc_auth_amount": 321.23, "folio_amount": 356.49, "settled_amount": 356.49, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": 296.23, "baseline_rate": 401.27, "market_rate": 389.23, "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": "variance", "recon_amount": 60.26, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-02", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 401.27, "discount_pct": 26.18 }, { "id": "RS-8853086-3", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8853086", "duty_id": "D-513086", "layover_id": "L-513087", "crew_id": "IRE-1084", "crew_name": "R. Byrne", "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": null, "is_allotment_night": 0, "rate_type": "contracted", "duty_reason": "positioning", "night_status": "occupied", "lead_time_days": 9, "booking_created_at": "2026-07-23T22:30:00Z", "checkin_time": "22:30", "checkout_time": "10:00", "duty_end_utc": "2026-08-03T21:45:00Z", "duty_start_utc": "2026-08-03T09:15:00Z", "transfer_minutes": 10, "room_net": 234.88, "vat_rate": 7, "vat_amount": 16.44, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 256.32, "ancillaries": 17.04, "fee": 0, "currency_local": "EUR", "rate_paid_local": 256.32, "fx_rate": 1, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 241.97, "markup": 14.35, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853086", "vcc_auth_amount": 298.36, "folio_amount": 433.1, "settled_amount": 433.1, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": 256.32, "baseline_rate": 353.88, "market_rate": 343.26, "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": "disputed", "recon_amount": 159.74, "crew_rating": 2, "complaint_theme": "checkin", "source_file_id": "AIMS-2026-08-01", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 353.88, "discount_pct": 27.57 }, { "id": "RS-8853733-1", "period": "2026-08", "night": "2026-08-03", "booking_id": "RS-8853733", "duty_id": "D-513733", "layover_id": "L-513734", "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-108", "hotel": "Leonardo Hotel Koln", "chain": "Leonardo", "contract_id": null, "allotment_id": null, "is_allotment_night": 0, "rate_type": "bedbank", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 9, "booking_created_at": "2026-07-25T01:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-03T00:24:00Z", "duty_start_utc": "2026-08-03T09:15:00Z", "transfer_minutes": 16, "room_net": 271.81, "vat_rate": 7, "vat_amount": 19.03, "vat_country": "DE", "vat_recoverable": 1, "city_tax": 5, "rate_paid": 295.84, "ancillaries": 19.84, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 295.84, "fx_rate": 1, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 263.05, "markup": 32.79, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853733", "vcc_auth_amount": 340.68, "folio_amount": 437.72, "settled_amount": 437.72, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": null, "baseline_rate": 371.93, "market_rate": 360.77, "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": "disputed", "recon_amount": 122.04, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-03", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 371.93, "discount_pct": 20.46 }, { "id": "RS-8853927-3", "period": "2026-08", "night": "2026-08-03", "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": "training", "night_status": "occupied", "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-03T12:29:00Z", "duty_start_utc": "2026-08-03T09:15:00Z", "transfer_minutes": 56, "room_net": 335.83, "vat_rate": 0, "vat_amount": 0, "vat_country": "HK", "vat_recoverable": 0, "city_tax": 0, "rate_paid": 335.83, "ancillaries": 20.62, "fee": 0, "currency_local": "HKD", "rate_paid_local": 2807.68, "fx_rate": 0.119611, "fx_date": "2026-08-03", "currency": "EUR", "revenue_model": "vendor_net", "supplier_cost": 298.86, "markup": 36.97, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853927", "vcc_auth_amount": 381.45, "folio_amount": 623.56, "settled_amount": 623.56, "settled_at": "2026-08-03T23:59:00Z", "contracted_rate": null, "baseline_rate": 408.91, "market_rate": 396.64, "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": "variance", "recon_amount": 267.11, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-01", "ingested_at": "2026-08-03T02:14:00Z", "version": 1, "public_rate": 408.91, "discount_pct": 17.87 }, { "id": "RS-8853514-1", "period": "2026-08", "night": "2026-08-02", "booking_id": "RS-8853514", "duty_id": "D-513514", "layover_id": "L-513515", "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-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": "occupied", "lead_time_days": 5, "booking_created_at": "2026-07-28T15:00:00Z", "checkin_time": "15:00", "checkout_time": "08:15", "duty_end_utc": "2026-08-02T13:34:00Z", "duty_start_utc": "2026-08-02T06:30:00Z", "transfer_minutes": 51, "room_net": 228.91, "vat_rate": 13.5, "vat_amount": 30.9, "vat_country": "IE", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 259.81, "ancillaries": 23.55, "fee": 15.97, "currency_local": "EUR", "rate_paid_local": 259.81, "fx_rate": 1, "fx_date": "2026-08-02", "currency": "EUR", "revenue_model": "vendor_commission", "supplier_cost": 259.81, "markup": 0, "commission_received": 22.35, "commission_shared": 11.17, "commission_share_pct": 50, "rebate_received": 0, "vcc_ref": "VCC-8853514", "vcc_auth_amount": 308.36, "folio_amount": 527.22, "settled_amount": 527.22, "settled_at": "2026-08-02T23:59:00Z", "contracted_rate": null, "baseline_rate": 310.19, "market_rate": 300.88, "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": "disputed", "recon_amount": 243.86, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-02", "ingested_at": "2026-08-02T02:14:00Z", "version": 1, "public_rate": 310.19, "discount_pct": 16.24 }, { "id": "RS-8853754-1", "period": "2026-08", "night": "2026-08-02", "booking_id": "RS-8853754", "duty_id": "D-513754", "layover_id": "L-513755", "crew_id": "IRE-1034", "crew_name": "R. Cassidy", "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": "occupied", "lead_time_days": 9, "booking_created_at": "2026-07-24T14:00:00Z", "checkin_time": "14:00", "checkout_time": "11:00", "duty_end_utc": "2026-08-02T13:02:00Z", "duty_start_utc": "2026-08-02T09:15:00Z", "transfer_minutes": 23, "room_net": 233.62, "vat_rate": 20, "vat_amount": 46.72, "vat_country": "GB", "vat_recoverable": 1, "city_tax": 0, "rate_paid": 280.34, "ancillaries": 0, "fee": 15.97, "currency_local": "GBP", "rate_paid_local": 236.36, "fx_rate": 1.186072, "fx_date": "2026-08-02", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 264.62, "markup": 15.72, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853754", "vcc_auth_amount": 305.34, "folio_amount": 540.17, "settled_amount": 540.17, "settled_at": "2026-08-02T23:59:00Z", "contracted_rate": 280.34, "baseline_rate": 325.21, "market_rate": 315.45, "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": "variance", "recon_amount": 259.83, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-02", "ingested_at": "2026-08-02T02:14:00Z", "version": 1, "public_rate": 325.21, "discount_pct": 13.8 }, { "id": "RS-8854809-2", "period": "2026-08", "night": "2026-08-02", "booking_id": "RS-8854809", "duty_id": "D-514809", "layover_id": "L-514810", "crew_id": "FRA-1049", "crew_name": "M. Delacroix", "crew_rank": "CC", "traveller_type": "crew", "entity": "ASL Airlines France", "legal_entity": "ASL Airlines France SA", "home_base": "MRS", "station": "TLS", "country": "FR", "property_id": "P-133", "hotel": "Pullman Toulouse Airport", "chain": "Accor", "contract_id": "C-133", "allotment_id": "A-133", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "lead_time_days": 3, "booking_created_at": "2026-07-29T01:15:00Z", "checkin_time": "01:15", "checkout_time": "11:00", "duty_end_utc": "2026-08-02T00:18:00Z", "duty_start_utc": "2026-08-02T14:05:00Z", "transfer_minutes": 22, "room_net": 225.05, "vat_rate": 10, "vat_amount": 22.5, "vat_country": "FR", "vat_recoverable": 1, "city_tax": 2.88, "rate_paid": 250.43, "ancillaries": 0, "fee": 0, "currency_local": "EUR", "rate_paid_local": 250.43, "fx_rate": 1, "fx_date": "2026-08-02", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 233.92, "markup": 16.51, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8854809", "vcc_auth_amount": 275.43, "folio_amount": 303.64, "settled_amount": 303.64, "settled_at": "2026-08-02T23:59:00Z", "contracted_rate": 250.43, "baseline_rate": 297.48, "market_rate": 288.56, "rate_honoured": 1, "customer": "UPS", "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": "disputed", "recon_amount": 53.21, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-01", "ingested_at": "2026-08-02T02:14:00Z", "version": 1, "public_rate": 297.48, "discount_pct": 15.82 }, { "id": "RS-8853850-1", "period": "2026-08", "night": "2026-08-01", "booking_id": "RS-8853850", "duty_id": "D-513850", "layover_id": "L-513851", "crew_id": "BEL-1073", "crew_name": "M. Janssens", "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": "A-123", "is_allotment_night": 1, "rate_type": "contracted", "duty_reason": "overnight", "night_status": "occupied", "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-01T14:37:00Z", "duty_start_utc": "2026-08-01T11:50:00Z", "transfer_minutes": 48, "room_net": 271.87, "vat_rate": 5, "vat_amount": 13.59, "vat_country": "AE", "vat_recoverable": 0, "city_tax": 5, "rate_paid": 290.46, "ancillaries": 32.33, "fee": 15.97, "currency_local": "AED", "rate_paid_local": 1138.58, "fx_rate": 0.255107, "fx_date": "2026-08-01", "currency": "EUR", "revenue_model": "routespring_contract", "supplier_cost": 271.7, "markup": 18.76, "commission_received": 0, "commission_shared": 0, "commission_share_pct": 0, "rebate_received": 0, "vcc_ref": "VCC-8853850", "vcc_auth_amount": 347.79, "folio_amount": 576.67, "settled_amount": 576.67, "settled_at": "2026-08-01T23:59:00Z", "contracted_rate": 290.46, "baseline_rate": 358.17, "market_rate": 347.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": "variance", "recon_amount": 253.88, "crew_rating": null, "complaint_theme": null, "source_file_id": "AIMS-2026-08-01", "ingested_at": "2026-08-01T02:14:00Z", "version": 1, "public_rate": 358.17, "discount_pct": 18.9 } ] }