{
  "p": {
    "provider_id": "TP-111",
    "name": "Lyon Executive Cars",
    "station": "LYS",
    "country": "FR",
    "contract_id": "TC-111",
    "contract_start": "2026-01-01",
    "contract_end": "2027-06-30",
    "status": "active",
    "rate_model": "per_transfer",
    "base_rate": 74.54,
    "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 Faber",
    "contact_email": "ops@lyontransfers.com",
    "contact_phone": "+31 2849326",
    "notes": null
  },
  "contract": {
    "contract_id": "TC-111",
    "provider_id": "TP-111",
    "station": "LYS",
    "entity_scope": "ALL",
    "start_date": "2026-01-01",
    "end_date": "2027-06-30",
    "currency": "EUR",
    "sla_minutes": 11,
    "waiting_time_included_minutes": 45,
    "waiting_time_rate": 30.35,
    "night_surcharge_pct": 15,
    "airport_access_fee": 5.05,
    "cancellation_hours": 12,
    "no_show_charge_pct": 50,
    "payment_terms": "Net 45, invoice",
    "payment_terms_days": 30,
    "flight_tracking_required": 1,
    "meet_and_greet_included": 0,
    "sla_penalty_pct": 25,
    "auto_renew": 1,
    "renewal_notice_days": 90,
    "signed_on": "2025-12-05",
    "signed_by": "P. Costa",
    "status": "active"
  },
  "contacts": [
    {
      "contact_id": "TCT-54",
      "provider_id": "TP-111",
      "role": "account_manager",
      "name": "Diego Meyer",
      "email": "account@lyonexecutivecar.example",
      "phone": "+37 17 8438189",
      "hours": "Mon–Fri 09:00–17:00",
      "primary_contact": 1
    },
    {
      "contact_id": "TCT-57",
      "provider_id": "TP-111",
      "role": "billing",
      "name": "Diego Novak",
      "email": "billing@lyonexecutivecar.example",
      "phone": "+36 73 8198431",
      "hours": "Mon–Fri 09:00–17:00",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-55",
      "provider_id": "TP-111",
      "role": "dispatch",
      "name": "Tomas Meyer",
      "email": "dispatch@lyonexecutivecar.example",
      "phone": "+33 46 6748490",
      "hours": "24/7",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-56",
      "provider_id": "TP-111",
      "role": "night_desk",
      "name": "Ines Silva",
      "email": "night@lyonexecutivecar.example",
      "phone": "+40 42 1010965",
      "hours": "22:00–06:00",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-58",
      "provider_id": "TP-111",
      "role": "operations",
      "name": "Diego Kowalski",
      "email": "operations@lyonexecutivecar.example",
      "phone": "+41 71 4686075",
      "hours": "Mon–Sun 06:00–22:00",
      "primary_contact": 0
    }
  ],
  "tariffs": [
    {
      "tariff_id": "TT-61",
      "contract_id": "TC-111",
      "provider_id": "TP-111",
      "vehicle_class": "sedan",
      "seats_max": 3,
      "rate_basis": "per_transfer",
      "rate": 52.95,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 42.36,
      "note": null
    },
    {
      "tariff_id": "TT-62",
      "contract_id": "TC-111",
      "provider_id": "TP-111",
      "vehicle_class": "sedan",
      "seats_max": 3,
      "rate_basis": "per_transfer",
      "rate": 60.77,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 47.66,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-63",
      "contract_id": "TC-111",
      "provider_id": "TP-111",
      "vehicle_class": "mpv",
      "seats_max": 6,
      "rate_basis": "per_transfer",
      "rate": 70.35,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 56.28,
      "note": null
    },
    {
      "tariff_id": "TT-64",
      "contract_id": "TC-111",
      "provider_id": "TP-111",
      "vehicle_class": "mpv",
      "seats_max": 6,
      "rate_basis": "per_transfer",
      "rate": 83.67,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 63.32,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-65",
      "contract_id": "TC-111",
      "provider_id": "TP-111",
      "vehicle_class": "minibus",
      "seats_max": 12,
      "rate_basis": "per_transfer",
      "rate": 115.45,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 92.36,
      "note": null
    },
    {
      "tariff_id": "TT-66",
      "contract_id": "TC-111",
      "provider_id": "TP-111",
      "vehicle_class": "minibus",
      "seats_max": 12,
      "rate_basis": "per_transfer",
      "rate": 135.66,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 103.91,
      "note": "Night tariff. Most crew transfers fall in this window."
    }
  ],
  "fleet": [
    {
      "fleet_id": "TF-37",
      "provider_id": "TP-111",
      "vehicle_class": "sedan",
      "seats": 3,
      "count_total": 8,
      "count_dedicated": 3,
      "wheelchair_accessible": 0,
      "luggage_capacity": "2 cases",
      "avg_age_years": 5.86,
      "note": null
    },
    {
      "fleet_id": "TF-38",
      "provider_id": "TP-111",
      "vehicle_class": "mpv",
      "seats": 6,
      "count_total": 14,
      "count_dedicated": 0,
      "wheelchair_accessible": 0,
      "luggage_capacity": "6 cases",
      "avg_age_years": 1.77,
      "note": null
    },
    {
      "fleet_id": "TF-39",
      "provider_id": "TP-111",
      "vehicle_class": "minibus",
      "seats": 12,
      "count_total": 9,
      "count_dedicated": 0,
      "wheelchair_accessible": 0,
      "luggage_capacity": "14 cases",
      "avg_age_years": 5.18,
      "note": null
    },
    {
      "fleet_id": "TF-40",
      "provider_id": "TP-111",
      "vehicle_class": "coach",
      "seats": 30,
      "count_total": 4,
      "count_dedicated": 2,
      "wheelchair_accessible": 0,
      "luggage_capacity": "34 cases",
      "avg_age_years": 2.7,
      "note": null
    }
  ],
  "audits": [
    {
      "audit_id": "TAU-10",
      "provider_id": "TP-111",
      "audited_on": "2026-03-06",
      "auditor": "ASL Ground Safety",
      "operator_licence_ref": "FR-PSV-37522",
      "licence_expiry": "2027-08-25",
      "insurance_ref": "INS-678469",
      "insurance_expiry": "2026-11-07",
      "insured_value": 19000000,
      "driver_vetting_ok": 1,
      "drug_alcohol_policy_ok": 1,
      "vehicle_inspection_ok": 0,
      "gps_tracking_ok": 1,
      "score": 2.37,
      "outcome": "fail",
      "actions": "Vehicle inspection records incomplete.",
      "reinspect_due": "2026-06-04"
    }
  ],
  "use": {
    "legs": 212,
    "cost": 17008.98,
    "cost_per_leg": 80.23103773584906,
    "seats": 580,
    "late_pct": 10.377358490566039,
    "delay_total": 786,
    "rest_impact": 401,
    "failures": 1,
    "pooled": 18
  },
  "byPeriod": [
    {
      "period": "2026-03",
      "legs": 214,
      "cost": 16907.32,
      "late_pct": 7.4766355140186915
    },
    {
      "period": "2026-04",
      "legs": 246,
      "cost": 19322.57,
      "late_pct": 8.536585365853659
    },
    {
      "period": "2026-05",
      "legs": 238,
      "cost": 18942.86,
      "late_pct": 7.983193277310924
    },
    {
      "period": "2026-06",
      "legs": 236,
      "cost": 18545.18,
      "late_pct": 8.898305084745763
    },
    {
      "period": "2026-07",
      "legs": 230,
      "cost": 18472.16,
      "late_pct": 11.304347826086957
    },
    {
      "period": "2026-08",
      "legs": 212,
      "cost": 17008.98,
      "late_pct": 10.377358490566039
    }
  ]
}