{
  "p": {
    "provider_id": "TP-102",
    "name": "Cologne Aviation Ground",
    "station": "CGN",
    "country": "DE",
    "contract_id": "TC-102",
    "contract_start": "2026-01-01",
    "contract_end": "2027-06-30",
    "status": "active",
    "rate_model": "per_seat",
    "base_rate": 109.16,
    "currency": "EUR",
    "vehicle_types": "Minibus 8, Coach 16, Sedan 3",
    "capacity_max": 16,
    "meet_and_greet": 0,
    "flight_tracking": 0,
    "sla_minutes": 14,
    "contact_name": "Liam Dolan",
    "contact_email": "ops@colognetransfers.com",
    "contact_phone": "+35 7054746",
    "notes": null
  },
  "contract": {
    "contract_id": "TC-102",
    "provider_id": "TP-102",
    "station": "CGN",
    "entity_scope": "ALL",
    "start_date": "2026-01-01",
    "end_date": "2027-06-30",
    "currency": "EUR",
    "sla_minutes": 14,
    "waiting_time_included_minutes": 45,
    "waiting_time_rate": 43.44,
    "night_surcharge_pct": 0,
    "airport_access_fee": 0,
    "cancellation_hours": 12,
    "no_show_charge_pct": 100,
    "payment_terms": "Net 30, invoice",
    "payment_terms_days": 30,
    "flight_tracking_required": 0,
    "meet_and_greet_included": 0,
    "sla_penalty_pct": 0,
    "auto_renew": 0,
    "renewal_notice_days": 30,
    "signed_on": "2025-12-12",
    "signed_by": "P. Costa",
    "status": "active"
  },
  "contacts": [
    {
      "contact_id": "TCT-11",
      "provider_id": "TP-102",
      "role": "account_manager",
      "name": "Karl Sato",
      "email": "account@cologneaviationg.example",
      "phone": "+44 70 5416707",
      "hours": "Mon–Fri 09:00–17:00",
      "primary_contact": 1
    },
    {
      "contact_id": "TCT-13",
      "provider_id": "TP-102",
      "role": "billing",
      "name": "Petra Silva",
      "email": "billing@cologneaviationg.example",
      "phone": "+43 23 5109578",
      "hours": "Mon–Fri 09:00–17:00",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-12",
      "provider_id": "TP-102",
      "role": "dispatch",
      "name": "Chloe Meyer",
      "email": "dispatch@cologneaviationg.example",
      "phone": "+33 50 6384840",
      "hours": "24/7",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-14",
      "provider_id": "TP-102",
      "role": "operations",
      "name": "Marc Rossi",
      "email": "operations@cologneaviationg.example",
      "phone": "+34 13 3306374",
      "hours": "Mon–Sun 06:00–22:00",
      "primary_contact": 0
    }
  ],
  "tariffs": [
    {
      "tariff_id": "TT-13",
      "contract_id": "TC-102",
      "provider_id": "TP-102",
      "vehicle_class": "sedan",
      "seats_max": 3,
      "rate_basis": "per_seat",
      "rate": 71.62,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 57.3,
      "note": null
    },
    {
      "tariff_id": "TT-14",
      "contract_id": "TC-102",
      "provider_id": "TP-102",
      "vehicle_class": "sedan",
      "seats_max": 3,
      "rate_basis": "per_seat",
      "rate": 86.92,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 64.46,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-15",
      "contract_id": "TC-102",
      "provider_id": "TP-102",
      "vehicle_class": "mpv",
      "seats_max": 6,
      "rate_basis": "per_seat",
      "rate": 120.02,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 96.02,
      "note": null
    },
    {
      "tariff_id": "TT-16",
      "contract_id": "TC-102",
      "provider_id": "TP-102",
      "vehicle_class": "mpv",
      "seats_max": 6,
      "rate_basis": "per_seat",
      "rate": 144.25,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 108.02,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-17",
      "contract_id": "TC-102",
      "provider_id": "TP-102",
      "vehicle_class": "minibus",
      "seats_max": 12,
      "rate_basis": "per_seat",
      "rate": 158.93,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 127.14,
      "note": null
    },
    {
      "tariff_id": "TT-18",
      "contract_id": "TC-102",
      "provider_id": "TP-102",
      "vehicle_class": "minibus",
      "seats_max": 12,
      "rate_basis": "per_seat",
      "rate": 178.6,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 143.04,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-19",
      "contract_id": "TC-102",
      "provider_id": "TP-102",
      "vehicle_class": "coach",
      "seats_max": 30,
      "rate_basis": "per_seat",
      "rate": 262.06,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 209.65,
      "note": null
    },
    {
      "tariff_id": "TT-20",
      "contract_id": "TC-102",
      "provider_id": "TP-102",
      "vehicle_class": "coach",
      "seats_max": 30,
      "rate_basis": "per_seat",
      "rate": 299.28,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 235.85,
      "note": "Night tariff. Most crew transfers fall in this window."
    }
  ],
  "fleet": [
    {
      "fleet_id": "TF-9",
      "provider_id": "TP-102",
      "vehicle_class": "sedan",
      "seats": 3,
      "count_total": 5,
      "count_dedicated": 0,
      "wheelchair_accessible": 0,
      "luggage_capacity": "2 cases",
      "avg_age_years": 2.47,
      "note": null
    },
    {
      "fleet_id": "TF-10",
      "provider_id": "TP-102",
      "vehicle_class": "mpv",
      "seats": 6,
      "count_total": 4,
      "count_dedicated": 2,
      "wheelchair_accessible": 0,
      "luggage_capacity": "6 cases",
      "avg_age_years": 5.43,
      "note": null
    },
    {
      "fleet_id": "TF-11",
      "provider_id": "TP-102",
      "vehicle_class": "minibus",
      "seats": 12,
      "count_total": 12,
      "count_dedicated": 3,
      "wheelchair_accessible": 0,
      "luggage_capacity": "14 cases",
      "avg_age_years": 2.82,
      "note": null
    },
    {
      "fleet_id": "TF-12",
      "provider_id": "TP-102",
      "vehicle_class": "coach",
      "seats": 30,
      "count_total": 4,
      "count_dedicated": 0,
      "wheelchair_accessible": 1,
      "luggage_capacity": "34 cases",
      "avg_age_years": 6.47,
      "note": null
    }
  ],
  "audits": [
    {
      "audit_id": "TAU-3",
      "provider_id": "TP-102",
      "audited_on": "2026-06-09",
      "auditor": "Routespring Supplier Assurance",
      "operator_licence_ref": "DE-PSV-95925",
      "licence_expiry": "2028-04-14",
      "insurance_ref": "INS-724792",
      "insurance_expiry": "2026-08-14",
      "insured_value": 18000000,
      "driver_vetting_ok": 1,
      "drug_alcohol_policy_ok": 1,
      "vehicle_inspection_ok": 1,
      "gps_tracking_ok": 0,
      "score": 3.82,
      "outcome": "pass",
      "actions": null,
      "reinspect_due": "2027-06-09"
    }
  ],
  "use": {
    "legs": 482,
    "cost": 160827.94,
    "cost_per_leg": 333.6679253112033,
    "seats": 1388,
    "late_pct": 29.25311203319502,
    "delay_total": 5757,
    "rest_impact": 2697,
    "failures": 11,
    "pooled": 47
  },
  "byPeriod": [
    {
      "period": "2026-03",
      "legs": 518,
      "cost": 179775.27,
      "late_pct": 27.606177606177607
    },
    {
      "period": "2026-04",
      "legs": 598,
      "cost": 204147.64,
      "late_pct": 26.755852842809364
    },
    {
      "period": "2026-05",
      "legs": 530,
      "cost": 186483.67,
      "late_pct": 29.62264150943396
    },
    {
      "period": "2026-06",
      "legs": 508,
      "cost": 178497.4,
      "late_pct": 24.606299212598426
    },
    {
      "period": "2026-07",
      "legs": 492,
      "cost": 166206.26,
      "late_pct": 27.03252032520325
    },
    {
      "period": "2026-08",
      "legs": 482,
      "cost": 160827.94,
      "late_pct": 29.25311203319502
    }
  ]
}