{
  "p": {
    "provider_id": "TP-108",
    "name": "Dubai Crew Transfers",
    "station": "DXB",
    "country": "AE",
    "contract_id": "TC-108",
    "contract_start": "2026-01-01",
    "contract_end": "2027-06-30",
    "status": "active",
    "rate_model": "per_transfer",
    "base_rate": 155.9,
    "currency": "EUR",
    "vehicle_types": "Minibus 8, Coach 16, Sedan 3",
    "capacity_max": 16,
    "meet_and_greet": 0,
    "flight_tracking": 1,
    "sla_minutes": 11,
    "contact_name": "Elena Novak",
    "contact_email": "ops@dubaitransfers.com",
    "contact_phone": "+32 6364779",
    "notes": null
  },
  "contract": {
    "contract_id": "TC-108",
    "provider_id": "TP-108",
    "station": "DXB",
    "entity_scope": "ASL Airlines Belgium",
    "start_date": "2026-01-01",
    "end_date": "2027-06-30",
    "currency": "EUR",
    "sla_minutes": 11,
    "waiting_time_included_minutes": 45,
    "waiting_time_rate": 53.12,
    "night_surcharge_pct": 10,
    "airport_access_fee": 5.89,
    "cancellation_hours": 12,
    "no_show_charge_pct": 100,
    "payment_terms": "Net 14, invoice",
    "payment_terms_days": 14,
    "flight_tracking_required": 1,
    "meet_and_greet_included": 0,
    "sla_penalty_pct": 10,
    "auto_renew": 0,
    "renewal_notice_days": 30,
    "signed_on": "2025-11-22",
    "signed_by": "R. Menon",
    "status": "active"
  },
  "contacts": [
    {
      "contact_id": "TCT-39",
      "provider_id": "TP-108",
      "role": "account_manager",
      "name": "Sofie Sato",
      "email": "account@dubaicrewtransfe.example",
      "phone": "+39 50 7610825",
      "hours": "Mon–Fri 09:00–17:00",
      "primary_contact": 1
    },
    {
      "contact_id": "TCT-42",
      "provider_id": "TP-108",
      "role": "billing",
      "name": "Karl Moreau",
      "email": "billing@dubaicrewtransfe.example",
      "phone": "+41 86 6930757",
      "hours": "Mon–Fri 09:00–17:00",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-40",
      "provider_id": "TP-108",
      "role": "dispatch",
      "name": "Ines Novak",
      "email": "dispatch@dubaicrewtransfe.example",
      "phone": "+40 24 2522481",
      "hours": "24/7",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-41",
      "provider_id": "TP-108",
      "role": "night_desk",
      "name": "Ines Faber",
      "email": "night@dubaicrewtransfe.example",
      "phone": "+34 56 8130014",
      "hours": "22:00–06:00",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-43",
      "provider_id": "TP-108",
      "role": "operations",
      "name": "Liam Novak",
      "email": "operations@dubaicrewtransfe.example",
      "phone": "+38 77 7232610",
      "hours": "Mon–Sun 06:00–22:00",
      "primary_contact": 0
    }
  ],
  "tariffs": [
    {
      "tariff_id": "TT-47",
      "contract_id": "TC-108",
      "provider_id": "TP-108",
      "vehicle_class": "sedan",
      "seats_max": 3,
      "rate_basis": "per_transfer",
      "rate": 114.33,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 91.46,
      "note": null
    },
    {
      "tariff_id": "TT-48",
      "contract_id": "TC-108",
      "provider_id": "TP-108",
      "vehicle_class": "sedan",
      "seats_max": 3,
      "rate_basis": "per_transfer",
      "rate": 137.43,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 102.9,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-49",
      "contract_id": "TC-108",
      "provider_id": "TP-108",
      "vehicle_class": "mpv",
      "seats_max": 6,
      "rate_basis": "per_transfer",
      "rate": 165.55,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 132.44,
      "note": null
    },
    {
      "tariff_id": "TT-50",
      "contract_id": "TC-108",
      "provider_id": "TP-108",
      "vehicle_class": "mpv",
      "seats_max": 6,
      "rate_basis": "per_transfer",
      "rate": 192.24,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 149,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-51",
      "contract_id": "TC-108",
      "provider_id": "TP-108",
      "vehicle_class": "minibus",
      "seats_max": 12,
      "rate_basis": "per_transfer",
      "rate": 255.61,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 204.49,
      "note": null
    },
    {
      "tariff_id": "TT-52",
      "contract_id": "TC-108",
      "provider_id": "TP-108",
      "vehicle_class": "minibus",
      "seats_max": 12,
      "rate_basis": "per_transfer",
      "rate": 303.07,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 230.05,
      "note": "Night tariff. Most crew transfers fall in this window."
    }
  ],
  "fleet": [
    {
      "fleet_id": "TF-29",
      "provider_id": "TP-108",
      "vehicle_class": "sedan",
      "seats": 3,
      "count_total": 12,
      "count_dedicated": 5,
      "wheelchair_accessible": 0,
      "luggage_capacity": "2 cases",
      "avg_age_years": 2.05,
      "note": null
    },
    {
      "fleet_id": "TF-30",
      "provider_id": "TP-108",
      "vehicle_class": "mpv",
      "seats": 6,
      "count_total": 5,
      "count_dedicated": 0,
      "wheelchair_accessible": 0,
      "luggage_capacity": "6 cases",
      "avg_age_years": 5.14,
      "note": null
    },
    {
      "fleet_id": "TF-31",
      "provider_id": "TP-108",
      "vehicle_class": "minibus",
      "seats": 12,
      "count_total": 13,
      "count_dedicated": 0,
      "wheelchair_accessible": 1,
      "luggage_capacity": "14 cases",
      "avg_age_years": 6.32,
      "note": null
    },
    {
      "fleet_id": "TF-32",
      "provider_id": "TP-108",
      "vehicle_class": "coach",
      "seats": 30,
      "count_total": 3,
      "count_dedicated": 1,
      "wheelchair_accessible": 1,
      "luggage_capacity": "34 cases",
      "avg_age_years": 5.65,
      "note": null
    }
  ],
  "audits": [
    {
      "audit_id": "TAU-8",
      "provider_id": "TP-108",
      "audited_on": "2026-01-11",
      "auditor": "SGS (contracted)",
      "operator_licence_ref": "AE-PSV-95357",
      "licence_expiry": "2026-05-13",
      "insurance_ref": "INS-596154",
      "insurance_expiry": "2026-03-14",
      "insured_value": 13000000,
      "driver_vetting_ok": 1,
      "drug_alcohol_policy_ok": 1,
      "vehicle_inspection_ok": 1,
      "gps_tracking_ok": 1,
      "score": 4.48,
      "outcome": "pass",
      "actions": null,
      "reinspect_due": "2027-01-11"
    }
  ],
  "use": {
    "legs": 272,
    "cost": 44591.67,
    "cost_per_leg": 163.9399632352941,
    "seats": 820,
    "late_pct": 9.558823529411764,
    "delay_total": 1026,
    "rest_impact": 472,
    "failures": 6,
    "pooled": 30
  },
  "byPeriod": [
    {
      "period": "2026-03",
      "legs": 288,
      "cost": 48212.38,
      "late_pct": 7.638888888888889
    },
    {
      "period": "2026-04",
      "legs": 230,
      "cost": 38326.51,
      "late_pct": 9.565217391304348
    },
    {
      "period": "2026-05",
      "legs": 286,
      "cost": 47305.88,
      "late_pct": 10.48951048951049
    },
    {
      "period": "2026-06",
      "legs": 282,
      "cost": 46322.14,
      "late_pct": 8.865248226950355
    },
    {
      "period": "2026-07",
      "legs": 278,
      "cost": 46136.49,
      "late_pct": 11.151079136690647
    },
    {
      "period": "2026-08",
      "legs": 272,
      "cost": 44591.67,
      "late_pct": 9.558823529411764
    }
  ]
}